Click here to Skip to main content
15,171,729 members

Comments by R Harshal (Top 200 by date)

R Harshal 1-Apr-16 9:58am View
   
apart from droping the table ,so you mean to say there is no way to add column before exsisting column.
R Harshal 4-Nov-15 6:29am View
   
Hi george sir,
for easy understanding i gave the whole code on CodeProject.com.i just want the alignment should be in centre for mobile.so if you help me in the code i will be very thankful to you.i search the bootstrap on google but its going from my head.please help me out .
R Harshal 4-Nov-15 5:41am View
   
yes right .but how is it possible.i am totally confused.would anyone can guide me in my given code.
R Harshal 4-Nov-15 2:26am View
   
too cool.

thank you so much
R Harshal 3-Nov-15 8:33am View
   
thanks buddy .its working
R Harshal 3-Nov-15 8:09am View
   
& should be in center. is there any way .Please let me know.i am confused
R Harshal 3-Nov-15 8:08am View
   
& should be in center. is there any way .Please let me know.
R Harshal 3-Nov-15 8:07am View
   
& should be in center. is there any way .Please let me know.
R Harshal 3-Nov-15 3:13am View
   
would u help me please.
R Harshal 3-Nov-15 3:13am View
   
would u help me please.
R Harshal 3-Nov-15 2:35am View
   
in that 26th august 2015. so 2 looks small in front of 6.In that case its look like up and down.
R Harshal 3-Nov-15 2:35am View
   
in that 26th august 2015. so 2 looks small in front of 6.In that case its look like up and down.
R Harshal 2-Nov-15 11:11am View
   
sorry i did not get you.
what i exactly need is :
i have a two line. Between two line i have the word lets begin.so basically line has one start point and one end point so now for first line, i want curve shape at start point and on end point for first line.same as for second line. i think now the question is clear for all my friends.please do let me know.
R Harshal 2-Nov-15 10:47am View
   
if i replace with with <svg>
the answer from varun is right but problem is i want curve shape from one point to another point for both the lines that is before Lets begin and after Lets Begin.Please let me know.
R Harshal 2-Nov-15 10:46am View
   
if i replace with <svg>. its gives me one single line which i dont want. i want both lines it should be curve from end point that is starting point and ending point.
the answer from varun is right but problem is i want curve shape from one point to another point for both the lines that is before Lets begin and after Lets Begin.Please let me know.
R Harshal 2-Nov-15 10:43am View
   
the answer from varun is right but problem is i want curve shape from one point to another point for both the lines that is before Lets begin and after Lets Begin.Please let me know.
R Harshal 2-Nov-15 10:05am View
   
how can i give round shape to end of the line(considering for both the lines.)
R Harshal 2-Nov-15 9:11am View
   
i dont want the curved shape.i want the round to the line
R Harshal 27-Oct-15 9:38am View
   
it showing the cell blank below mobile and address which not required..Any idea.
R Harshal 27-Oct-15 4:22am View
   
hey buddy
its actually works.
thanks buddy.
R Harshal 27-Oct-15 3:46am View
   
thank you so much ...
R Harshal 27-Oct-15 1:30am View
   
thanks to all of you ...
R Harshal 24-Oct-15 6:45am View
   
Answer is incomplete.Anyone can guide me for the same.
R Harshal 24-Oct-15 6:35am View
   
Please guide me for : to reduce the hr line size from leftside and rightside.
and i want to color Lets Begin word.
R Harshal 24-Oct-15 6:19am View
   
secondily i want to reduce the hr line size from leftside and rightside.
and i want to color Lets Begin word.
R Harshal 19-Oct-15 3:14am View
   
Hi KrunalRohit,
Please let me know
R Harshal 19-Oct-15 3:07am View
   
i have tried this but its not working
<table width="600" border="0" cellpadding="0" cellspacing="0" align="center" class="deviceWidth" style="border:1px solid black;">
R Harshal 19-Oct-15 2:55am View
   
I want the 3 images in one border.i have written the one image code as above.
R Harshal 19-Oct-15 2:54am View
   
I want the 3 images in one border.
R Harshal 19-Oct-15 2:53am View
   
Please give me reference.Please give some idea
R Harshal 24-Oct-14 10:11am View
   
Wish you a Happy Diwali ...
R Harshal 24-Oct-14 10:10am View
   
You are Great Sir(Tadit) ...
R Harshal 24-Oct-14 10:02am View
   
Thanks you so much Tadit Sir.
R Harshal 24-Oct-14 9:42am View
   
Sorry Sir,
I have updated the code.Please have a look.
Thanks in Advance
Harshal
R Harshal 24-Oct-14 9:29am View
   
Can i post another Question for the Textbox .Is it Fine??
R Harshal 24-Oct-14 9:28am View
   
ohh Tadit ...
this is not done Sir..
R Harshal 24-Oct-14 9:28am View
   
ohh Maciej ...
this is not done Sir..
R Harshal 24-Oct-14 8:47am View
   
As i have updated the Question .
R Harshal 24-Oct-14 8:43am View
   
if i want to use textbox in cell .I have tried this
for (var index = 0; index < employee.length; index++) {
$("#tbNames tr:last").after("<tr><td>" + employee[index].Id + "</td> <td>" +<input id="nameTextBox" type="text" />
+ "</td> <td>" + $('#ageTextBox').val(employee[index].Age) + "</td> </tr>");
}

But it not works
Will anyone can guide me .
Thanks in Advance
R Harshal 24-Oct-14 8:01am View
   
Thanks Tadit
R Harshal 24-Oct-14 7:22am View
   
Hi Team,
Please help me out .
R Harshal 24-Oct-14 6:48am View
   
Hi ALL/Sinsia,
I have updated the Code but no use ,I am not getting the Array data in HTMl TAble.

Please guide me.
R Harshal 22-Aug-14 5:13am View
   
please let me know .
R Harshal 21-Aug-14 6:13am View
   
Please Team.Kindly revert .Do anyone have any idea for the same.
R Harshal 20-Aug-14 9:58am View
   
Hi Ryan,
according to your suggestion i have modify the code but it cant work .it cannot read the second table column .Please Team let me know.

Thanks in Advance
Harshal
R Harshal 18-Aug-14 6:17am View
   
How to solve it for Character .
Please let me know. Regex is for other operation .
R Harshal 18-Aug-14 6:12am View
   
HI Hard-Rockz
If i found any character then it should return null.this what i want i am trying to do .
Thanks in advance
R Harshal 18-Aug-14 5:56am View
   
If i found any character then it should return null.this what i want i am trying to do .
Thanks in advance
R Harshal 18-Aug-14 5:26am View
   
I have try this .
public static string ExtractValue(string rawValue)
{
if (rawValue == string.Empty || Regex(@"[a-zA-z\s]*").Replace(rawValue, null))
{
return null;
}
else
{
return new Regex(@"[a-zA-z\s]*").Replace(rawValue, string.Empty);
}
}

but still i am getting the same error.
R Harshal 18-Aug-14 5:22am View
   
I want to check for text.Do you have any idea for that.
R Harshal 18-Aug-14 4:28am View
   
Thank you Magic Wonder.
R Harshal 18-Aug-14 3:57am View
   
In my table's column[Weight] data is blank.
R Harshal 18-Aug-14 3:48am View
   
Sorry to say ,I did not get it .
what exactly i need to do ??
R Harshal 6-Aug-14 8:35am View
   
I have created table and after filling the data in entity i want to put one value in one column and second value in second column after using split method.do u have any idea about this kind of issue .
I am confused not sure .
Thanks for help .
R Harshal 6-Aug-14 8:14am View
   
No .Not this
suppose i have column Name and address .i want to put temparr[0] value in Name and temparr[1] value in address after split.How to do that ??
R Harshal 4-Aug-14 10:20am View
   
what I need is

sql_query(Query as String;ChosenRange as Range)
R Harshal 4-Aug-14 10:14am View
   
I have a excel sheet name as follows:
WCEL_DBBH_REPORT_MASTER_HAR_20140803.xls .
In this excel sheet there are 256 columns .I want to select only the last column that is 256 (namely:xyz )
My query will be like
SELECT [xyz] FROM [WCEL_DBBH_REPORT_MASTER_HAR_20140803.xls$]
Is that so .Please let me know.

Thanks
Harshal
R Harshal 1-Aug-14 9:05am View
   
Hey Guys Come on Team ..
Let get it sort this problem ..
R Harshal 1-Aug-14 7:21am View
   
Come on Team ,I am waiting for your answer.
if i get the same digit in my mobile number(9869475978),ie 9 and 7 are repeative.
My this Condition if (val.indexOf(1) == 11 && val.indexOf(5) == 12) is not working
Do anyone have answer for the same.

Thanks in advance
Harshal.
R Harshal 1-Aug-14 6:54am View
   
Mr.Rohan
As no one have posted the Answer.Can i create a new question with same description.
As Code Project page does not allow me to modify the question .it says "Internal error occured in the item ."
Kindly revert.
Thanks in Advance
Harshal
R Harshal 1-Aug-14 6:14am View
   
As i cant modify the question .So please kindly help in my Question above.
There is nothing to modify in my question .So question is same only thing i need a solution for the same.
Thanks in advance
harshal
R Harshal 1-Aug-14 6:10am View
   
But My Problem I cant Modify My Question its give error .Internal error Occured .Thats why mention descreption in comments.

Thanks in advance
Harshal
R Harshal 1-Aug-14 5:58am View
   
Team let me know how to sort this problem.Anyone from Code Team Please

Thanks in Advance
harshal
R Harshal 1-Aug-14 5:51am View
   
Please Kindly Revert .
R Harshal 1-Aug-14 5:32am View
   
In This Condition ,'+918869472915' is a Indian Number but it returns me False .This is my Problem .If you Check i have not submitted this type of question before this ..so how could you say this is a repeated question ..Please check it.
R Harshal 1-Aug-14 5:29am View
   
Mr.Rohan why r u not trying to understand the Problem ..
Accorcing to Code Project terms and Conditions ,I did not say to give me Answer for my Question .I already stuck in my Condition that why i am trying to get help from Code Team .
R Harshal 1-Aug-14 5:22am View
   
Hi Rohan,
If you See Properly, this time Conditions are Different.I have not repeated the question.
R Harshal 31-Jul-14 10:59am View
   
Team help Please.
R Harshal 31-Jul-14 8:02am View
   
Thank you so much buddy ..its work.
R Harshal 31-Jul-14 7:27am View
   
Please team help me ..

Thanks in Advance
harshal
R Harshal 31-Jul-14 7:20am View
   
for example : '9869472979','9932145698'
In first mobile number, index 0 and 1 have value 9 and 8
In Second Mobile Number, index 0 and 1 have value 9 and 9
So If index o and 1 have value 9 and 8 then show otherwise don't show that number .

Thanks in Advance
Harshal
R Harshal 31-Jul-14 7:03am View
   
Hi Kumarbs,

Please guide Me for the updated Question.

Thanks in Advance
Harshal
R Harshal 31-Jul-14 6:25am View
   
Most of my query get solved from Peter and Chill60 thats why i wrote their name ..
Secondily ,its work for me .
I want to know were i am wrong
I have array as follows :
var mobileArray =
[{
num1: 9869472979
},
{
num1: 9930216658
},
{
num1: 6598364266
}];
Is it something wrong in my array ??
let me know.
Thank you Sir ..
R Harshal 31-Jul-14 5:56am View
   
Hi Peter and CHill60.
Please guide me in this situation.

Thanks in Advance
Harshal
R Harshal 30-Jul-14 6:06am View
   
this trick i have done but no use .Why is it so ?
Thanks in advance
Harshal
R Harshal 29-Jul-14 11:14am View
   
Thank You peter .
I made a mistake ..
Thanks for your help.
R Harshal 25-Jul-14 6:49am View
   
please give me references to create a modal on page .Please kindly revert .Is there anyone who can help me.

Thanks in advance
Harshal
R Harshal 25-Jul-14 5:54am View
   
Kindly revert please.
R Harshal 25-Jul-14 5:54am View
   
Kindly guide me Team .
Thanks in Advance
Harshal
R Harshal 24-Jul-14 10:54am View
   
HEllo Team .
Please guide me .Why i am getting the error .Please Team

Thanks in advance
Harshal
R Harshal 24-Jul-14 10:40am View
   
Kindly revert .please
R Harshal 24-Jul-14 5:47am View
   
thanks for your reply .I get it.
R Harshal 18-Jul-14 11:18am View
   
if i get nqiSqiEntity.Circle == "Select" . i dont want to execute that if Condition ..
thanks in Advance
Harshal
R Harshal 18-Jul-14 10:54am View
   
Please Someone Guide ME.
Thanks Harshal
R Harshal 18-Jul-14 10:43am View
   
Hi King_Fisher ,I got the Solution on This .
if (nqiSqiEntity.Month != string.Empty)
{
query.AppendFormat("select * from K2_NQISQI with (nolock) where MONTH = '{0}'", nqiSqiEntity.Month);
if (nqiSqiEntity.Tech != string.Empty || nqiSqiEntity.Tech != "Select")
{
query.AppendFormat("' and TECH = '{0}'", nqiSqiEntity.Tech);
}

if (nqiSqiEntity.Circle != string.Empty || nqiSqiEntity.Circle != "Select")
{
query.AppendFormat("' and CIRCLE = '{0}'", nqiSqiEntity.Circle);
}

query.AppendLine(" order by id asc");
}
ITS WORKING SIR bUT THERE IS A TWIST IN MY CONDITION.sometime i am getting nqiSqiEntity.Circle = "Select" ,if this include it should not satisfy the Circle Condition.I wrote this code if (nqiSqiEntity.Circle != string.Empty || nqiSqiEntity.Circle !="Select") dont read the Circle Value ,But its reading the Circle Value .Please Guide me Where I am getting Wrong.
Thanks Harshal
R Harshal 18-Jul-14 9:52am View
   
No Issue Sir,But is there any luck to improve my If Else ,Else If Condition .So that my confusion will get cleared.

Thanks in Advance
harshal
R Harshal 18-Jul-14 9:07am View
   
Oh my God ,
the King_Fisher (Guinness of Code project ).Thanks for your reply Sir, But According to the company requirement i don't want to use stored procedure.So will you please help me in my C# If Else and Else If condition .It will be great thankful to me.

Thanks in Advance
Harshal
R Harshal 18-Jul-14 8:45am View
   
if else condition are not working .
Please help.. help..
R Harshal 18-Jul-14 8:39am View
   
Hi Rob .
will you guide me for my if else ,else if condition.

Thanks in advance
Harshal
R Harshal 18-Jul-14 4:12am View
   
Deleted
Soory team
i got the answer
nqiSqiEntity.Month = $('#monthSelect option:selected').text();

Thanks
R Harshal 17-Jul-14 7:35am View
   
Thanks Buddy
its work .
R Harshal 15-Jul-14 8:53am View
   
Thank you SarveshKumar.
Now all queries get Completed .

Thanks
Harshal
R Harshal 15-Jul-14 8:08am View
   
OK. Thanks For Solving 1 st condition ,can you guide me for this condition ,as this condition is pending from long time .
Condition:if i found more than 4 record for the same CircleId it should not allow to save and return 1 in same stored procedure.

Thanks in Advance
Harshal
R Harshal 15-Jul-14 7:56am View
   
Thanks Sarvesh for your reply .
But in my stored procedure there is a twist .
The twist is I don't require if not exist in my stored procedure because i made stored procedure to check existing records in both condition ,do you get my point.
If you remember my condition as follows:
1 st Condition :If i found the same record in database,it should not save the Record and return 1.
2 nd Condition:if i found more than 4 record for the same CircleId it should not allow to save and return 1.So in my stored procedure I want to check for if exists for both the condition ,but i am confused to implement it that's why i have taken help from Code Project Team,But no one have understand my question .I hope you get my point.If anyone have dought for the same please ask me ,don't ignore it please..
Please have a look on latest Stored Procedure.

Thanks in Advance.
Harshal
R Harshal 15-Jul-14 7:40am View
   
now the problem is if the same record is not present in database then to it gives me return as 1.This could not happen.Please find the latest Stored Procedure
ALTER PROCEDURE [dbo].[K2_CHECKENTRYINFILELOG]
@FILENAME VARCHAR(150),
@FILEPATH VARCHAR(MAX),
@FILETYPE int,
@FILEDATE datetime,
@CIRCLEID INT,
@TOTALROWS int,
@SUCCESSCOUNT int,
@FAILURECOUNT int,
@PROCESSED bit,
@ERROR varchar(MAX),
@VENDORID int,
@CREATEDBY INT = 1,
@CREATEDON DATETIME,
@DELETED BIT=0,
@FILELOGID BIGINT OUTPUT

AS
BEGIN



--IF EXISTS (
set @FILELOGID = (select count(CIRCLEID) as CircleId from K2FILELOG where FILEPATH = @FILEPATH and
[FILENAME] = @FILENAME and
FILETYPE = @FILETYPE and
FILEDATE = @FILEDATE and
CIRCLEID = @CIRCLEID and
TOTALROWS = @TOTALROWS and
SUCCESSCOUNT = @SUCCESSCOUNT and
FAILURECOUNT = @FAILURECOUNT and
PROCESSED = @PROCESSED and
ERROR = @ERROR and
VENDORID = @VENDORID and
CREATEDBY = @CREATEDBY and
CREATEDON = @CREATEDON and
DELETED = @DELETED)
--)

begin

select count (CIRCLEID) as CircleId from K2FILELOG with (nolock) where FILETYPE = @FILETYPE and
[FILENAME] = @FILENAME and
FILEPATH = @FILEPATH and
FILEDATE = @FILEDATE and
CIRCLEID = @CIRCLEID
GROUP BY CIRCLEID having count(CIRCLEID) >= 4

end

END
R Harshal 15-Jul-14 7:36am View
   
Anyone from the Code Project Team can tell me ,how to use If Exists statement for two condition ,As i got lot of confusion in my stored procedure ,Some the Engineer from Code MAster have closed my issue without giving the proper answer,as they says same issue was assign for number of times ,but if you check procedure are same but question are different.I dont know why they closed all those ticket .The Ticket which is open have not given reply from long time .would anyone from CodeMaster Team can help me from this situation.

Thanks in Advance
Harshal.
R Harshal 15-Jul-14 7:31am View
   
Dear Sarvesh,
I am still waiting for your answer.Please let me know.

Thanks
R Harshal 14-Jul-14 10:14am View
   
YEah ,Actually I am troubleshooting my stored Procedure with so many situation .
Now this post is different from rest of the others.

Thanks
Harshal
R Harshal 14-Jul-14 8:20am View
   
so you mean to say there is nothing to modify in stored procedure.

Cheers
Harshal
R Harshal 14-Jul-14 8:09am View
   
If you check the stored procedure ,Problem are different at every post
Thanks
Harshal.
R Harshal 14-Jul-14 7:08am View
   
I forget to declare my values in Select statement.
thanks for your reply.



R Harshal 14-Jul-14 7:07am View
   
Yes you are absolutely Right.I forget to declare my values

thanks hypermellow.
R Harshal 14-Jul-14 6:54am View
   
I got the Solution .
Thanks
Harshal
R Harshal 14-Jul-14 6:18am View
   
Hi Vipul,
I want to perform the action over here
fileLog.FileType = dataReader[KaizenConstants.FILETYPE].ObjectToString();
In this how i can implicit convert.

please Guide me.
R Harshal 14-Jul-14 5:40am View
   
Hi Sarvesh.
Please kindly revert.
R Harshal 14-Jul-14 5:06am View
   
Thanks for your reply .
But There is a twist in my stored Procedure .
I have make another stored PRocedure for saving the new Record.
In this Stored Procedure i need to check the existing Reccord.I want to perform only two condition.
1 st Condition :If i found the same record in database,it should not save the Record.
2 nd Condition:if i found more than 4 record for the same CircleId it should not allow to save.
What changes i need to make in my stored PRocedure,it gives me error :Incorrect syntax near the keyword 'ELSE'.

ALTER PROCEDURE [dbo].[K2_CHECKENTRYINFILELOG]
@FILENAME VARCHAR(150),
@FILEPATH VARCHAR(MAX),
@FILETYPE int,
@FILEDATE datetime,
@CIRCLEID INT,
@TOTALROWS int,
@SUCCESSCOUNT int,
@FAILURECOUNT int,
@PROCESSED bit,
@ERROR varchar(MAX),
@VENDORID int,
@CREATEDBY INT = 1,
@CREATEDON DATETIME,
@DELETED BIT=0,
@FILELOGID bigINT

AS
BEGIN
IF NOT EXISTS (
select count(CIRCLEID) from K2FILELOG where FILEPATH = @FILEPATH and
[FILENAME] = @FILENAME and
FILETYPE = @FILETYPE and
FILEDATE = @FILEDATE and
CIRCLEID = @CIRCLEID and
TOTALROWS = @TOTALROWS and
SUCCESSCOUNT = @SUCCESSCOUNT and
FAILURECOUNT = @FAILURECOUNT and
PROCESSED = @PROCESSED and
ERROR = @ERROR and
VENDORID = @VENDORID and
CREATEDBY = @CREATEDBY and
CREATEDON = @CREATEDON and
DELETED = @DELETED)


ELSE

begin
select count (CIRCLEID) from K2FILELOG with (nolock) where FILETYPE = @FILETYPE and
FILEDATE = @FILEDATE and
CIRCLEID = @CIRCLEID
GROUP BY CIRCLEID having count(CIRCLEID) >= 4
END


END
R Harshal 14-Jul-14 4:26am View
   
I made some mistake in Stored Procedure which I am not able to solve it.
Please Kindly Revert.
Thanks Harshal.
R Harshal 14-Jul-14 4:22am View
   
Yes I am confuse on same place.I want to perform this three Condition.
1 st Condition :If i found the same record in database,it should not save the Record.
2 nd Condition: New Record should get Add.
3 rd Condition:if i found more than 4 record for the same CircleId it should not allow to save.

will you Guide me ,Where should i need to modify the Stored Procedure.

Please Guide me.

Thanks Harshal
R Harshal 11-Jul-14 11:22am View
   
Kindly revert.
Thanks Harshal
R Harshal 11-Jul-14 10:09am View
   
I WANT TO USE GROUP BY HAVING CLAUSE FOR MY FIRST CONDITION WHICH IS NOT WORKING.
There are two Condition in my Stored procedure as follows:
First Condition:if i found the number of records greater than equal to 4(IF I GET COUNT OF 4 RECORDS) for circleID = 14 then it will not allowed to save the record.
Second Condition:if records is already exists return zero.
R Harshal 11-Jul-14 9:52am View
   
LETS TAKE COUNT(CIRCLEID)
Kindly revert.
Thanks
HArshal
R Harshal 11-Jul-14 9:08am View
   
Please Kindly Guide me.
Thanks
Harshal
R Harshal 11-Jul-14 6:30am View
   
Please Guys Guide Me for The Same.
Thanks
Harshal.
R Harshal 9-Jul-14 4:22am View
   
i dont want to access only one element .I want to access all in my dropDown.
Kindly Guide Me.If I write fileTypeList[0] it will give me the first array record which i dont want ,I want all.
Thanks
Harshal.
R Harshal 8-Jul-14 7:23am View
   
if you check my comment i am getting the records in fileTypeList.And from that fileTypeList i want to show one proerties in my dropdown.Kindly refer the Code.If you have any dought please let me know.
Thanks Harshal
R Harshal 8-Jul-14 6:09am View
   
Please kindly Guide me.
Thanks
Harshal.
R Harshal 8-Jul-14 5:34am View
   
As i am getting number of records as follows:
fileTypeList
[
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
,
Object
]
R Harshal 8-Jul-14 5:33am View
   
Please have a look on this .
fileTypeList
[
Object
CreatedBy: 0
CreatedOn: null
Deleted: 0
Error: Object
Id: 1
IsValid: true
K2FileType: "DsrGsm"
Key: 0
UpdatedBy: 0
UpdatedOn: null
]

Kindly revert
Thanks
Harshal
R Harshal 30-Jun-14 10:11am View
   
Thank You So much Buddy .
R Harshal 30-Jun-14 10:10am View
   
Thank you so much Buddy .
R Harshal 30-Jun-14 9:49am View
   
Thanks For your Reply.
My question is :
if i checked the checkbox it should return me true which means YES.
if i Unchecked the checkbox it should return me false which means NO.
This I want .
Please Advice
Thanks
Harshal
R Harshal 16-Jun-14 10:06am View
   
Thanks you Richard and phil.
R Harshal 16-Jun-14 10:05am View
   
Thanks for your answer .
Thank you very much.
Harshal
R Harshal 16-Jun-14 6:35am View
   
I have already done this but no use .
Kindly Revert.
Thanks Harshal
R Harshal 16-Jun-14 5:11am View
   
According to your solution ,It gives me the same error .
Its not work for me.
Please Advice.
Thanks
Harshal
R Harshal 12-Jun-14 10:11am View
   
Thanks for your reply.
Thank you very Much.
Harshal
R Harshal 11-Jun-14 6:33am View
   
I am reading the Name from excel which must be same.
In my Excel file, column name is: Session Configuration Success Rate (< 95%)
And the same Name i have paste to the xml file :Session Configuration Success Rate (< 95%).As i am not getting the error for greater than sign .I am getting error only for this statement.
Should i need to change the column name in Excel.O do you have any other option.
please let me know.
Thanks
HArshal
R Harshal 22-May-14 10:05am View
   
Thanks Buddy
Thanks A lot.
R Harshal 22-May-14 4:01am View
   
Thank you Friend .
Thanks A lot.
R Harshal 22-May-14 3:48am View
   
Thanks Friend.
Thanks A lot.
R Harshal 21-May-14 12:34pm View
   
One query please ,
i want to delete the last records from the collection.I am using this:
for (int i = singleCellRecords.Count - singleCellRecords[0]; i >= 0; i--)
{
if (singleCellRecords.Count > 1)
{
singleCellRecords.RemoveAt(i);
break;
}
}
but it gives me error as follows
Error 15 Operator '-' cannot be applied to operands of type 'int' and 'Kaizen.Entities.Kaizen2G.IZteBbh'
Please kindly revert .what changes i need to do .
R Harshal 21-May-14 11:22am View
   
In future please guide i will do this for u ...
Have a great day Buddy.
Thanks.
R Harshal 21-May-14 11:20am View
   
Thanks to u ..
R Harshal 21-May-14 11:16am View
   
Thank you brother ..
Thanks a lot.
R Harshal 21-May-14 11:03am View
   
i am having the collection.
R Harshal 21-May-14 11:00am View
   
Thanks Buddy its working .
one more query Kindly revert it .
if i have duplicate records in this loop
for (int i = singleCellRecords.Count - 1; i >= 0; i--)
{

// singleCellRecords.RemoveAt(i);
}
I want to delete only one record from that duplicate than what changes i need to do .please Brother, kindly revert.
R Harshal 21-May-14 7:03am View
   
its so advanced .Actually its good BUt in my requirement there is twist.Is there any other way to get it solve.At the time of reading i want to ignore that duplicate records not at the time of adding.

Thanks
Harshal.
R Harshal 21-May-14 6:34am View
   
HI Nikhil_S
Thanks for your reply .
Actually i want if their are two duplicate records ,So i want to insert only one record from that.
The condition which you gave me is if its contains(element) then Add(element) which is not my requirement .please advice if i wrong.
Thanks Harshal
R Harshal 21-May-14 6:20am View
   
yes.migrating Records From Excel.

Thanks
Harshal.
R Harshal 21-May-14 5:40am View
   
Yeah Sure Sir.
R Harshal 20-May-14 9:48am View
   
Not in SQL My Friend .I want to perform in C#.Please find the updated code.
Thanks
Harshal
R Harshal 20-May-14 9:47am View
   
Please have a look.I have modified the code as follows:
R Harshal 20-May-14 9:11am View
   
Deleted
if (isBlank)
{
////blankRecords.Add(singleCellRecords[count]);
blankRecords.Remove(singleCellRecords[count]);
}
but how can i ignore the second data from that count.
Please advice
Thanks
Harshal
R Harshal 20-May-14 9:11am View
   
Deleted
&& singleCellRecords[count].DataErlang == 0
&& singleCellRecords[count].VoiceDataErlangs == 0
&& singleCellRecords[count].SdBlkNom == 0
&& singleCellRecords[count].SdBlkDeNom == 0
&& singleCellRecords[count].SdDropNom == 0
&& singleCellRecords[count].SdDropDeNom == 0
&& singleCellRecords[count].TchBlkNom == 0
&& singleCellRecords[count].TchBlkDeNom == 0
&& singleCellRecords[count].TchDropNom == 0
&& singleCellRecords[count].TchDropDeNom == 0
&& singleCellRecords[count].HosrNom == 0
&& singleCellRecords[count].HosrDeNom == 0
&& singleCellRecords[count].NoOfDynPdchPreemptionForCsService == 0
&& singleCellRecords[count].CcrVoiceServicesNom1 == 0
&& singleCellRecords[count].CcrVoiceServicesDeNom1 == 0
&& singleCellRecords[count].CcrVoiceServicesNom2 == 0
&& singleCellRecords[count].CcrVoiceServicesDeNom2 == 0
&& singleCellRecords[count].CcrVoiceServicesNom3 == 0
&& singleCellRecords[count].CcrVoiceServicesDeNom3 == 0
&& singleCellRecords[count].CcrVoiceServicesNom4 == 0
&& singleCellRecords[count].CcrVoiceServicesDeNom4 == 0
&& singleCellRecords[count].TasrNom == 0
&& singleCellRecords[count].TasrDeNom == 0
&& singleCellRecords[count].UlQualNom == 0
&& singleCellRecords[count].UlQualDeNom == 0
&& singleCellRecords[count].DlQualNom == 0
&& singleCellRecords[count].DlQualDeNom == 0
&& singleCellRecords[count].RachNom == 0
&& singleCellRecords[count].RachDeNom == 0;

if (isBlank)
{
////blankRecords.Add(singleCellRecords[count]);
blankRecords.Remove(singleCellRecords[count]);
}
}
What i need to find is ,if i found any duplicate records with same value ,then i want to ignore the second record .As in if condition i wrote
R Harshal 20-May-14 9:10am View
   
Deleted
&& singleCellRecords[count].Fr == 0
&& singleCellRecords[count].Hr == 0
&& singleCellRecords[count].AmrFr == 0
&& singleCellRecords[count].AmrHr == 0
&& singleCellRecords[count].TchAssignSuccessRate == 0
&& singleCellRecords[count].VoiceErlangs == 0
&& singleCellRecords[count].RadioNtwUtiliztaionRate == 0
&& singleCellRecords[count].TbfSuccessRateUl == 0
&& singleCellRecords[count].TbfSuccessRateDl == 0
&& singleCellRecords[count].UlGprsThroughputRlc == 0
&& singleCellRecords[count].DlGprsThroughputRlc == 0
&& singleCellRecords[count].UlEGprsThroughputRlc == 0
&& singleCellRecords[count].DlEGprsThroughputRlc == 0
&& singleCellRecords[count].RrRescCongRateNomDlBlocking == 0
&& singleCellRecords[count].RrRescCongRateDeNomDlBlocking == 0
&& singleCellRecords[count].RrRescCongRateDlBlockingRate == 0
&& singleCellRecords[count].RrRescCongRateNomUlBlocking == 0
&& singleCellRecords[count].RrRescCongRateDeNomUlBlocking == 0
&& singleCellRecords[count].RrRescCongRateUlBlockingRate == 0
&& singleCellRecords[count].AbisRescCongRate == 0
&& singleCellRecords[count].UppbdDspRescCongRate == 0
&& singleCellRecords[count].GprsRlcPayloadUplink == 0
&& singleCellRecords[count].GprsRlcPayloadDownlink == 0
&& singleCellRecords[count].EGprsRlcPayloadUplink == 0
&& singleCellRecords[count].EGprsRlcPayloadDownlink == 0
&& singleCellRecords[count].SdcchBlocking == 0
&& singleCellRecords[count].SdcchDrp == 0
&& singleCellRecords[count].TtslTchBlkRate == 0
&& singleCellRecords[count].NoOfStatTs == 0
&& singleCellRecords[count].NoOfDynTs == 0
&& singleCellRecords[count].MaxNoOfUsedPdch == 0
&& singleCellRecords[count].AvgNoOfUsedPdch == 0
&& singleCellRecords[count].NoOfForceConerDynFromPdchToTchByBsc
R Harshal 20-May-14 9:08am View
   
Deleted
Please find the code as follows:
List<iztebbh> singleCellRecords = duplicateRecords.Where(item => (item.CombinedMaster as ICombinedMaster).Id.ToString() == cellId).ToList();
//// Check for same records.
List<iztebbh> blankRecords = new List<iztebbh>();
for (int count = 0; count < singleCellRecords.Count; count++)
{
//// Check for blank
bool isBlank = singleCellRecords[count].Ru60Ru02 == string.Empty
&& singleCellRecords[count].NumberOfTrxs == 0
&& singleCellRecords[count].EquippedTrxs == 0
&& singleCellRecords[count].SdcchSlots == 0
&& singleCellRecords[count].PdtchTs == 0
&& singleCellRecords[count].HrEnable == false
&& singleCellRecords[count].AmrThreshold == 0
&& singleCellRecords[count].AvailableTchFullHalfChannel == 0
&& singleCellRecords[count].DesinedCapacity == 0
&& singleCellRecords[count].AvailableTchFr == 0
&& singleCellRecords[count].DesinedCapacityFr == 0
&& singleCellRecords[count].NoOfSdcchAvailable == 0
&& singleCellRecords[count].NoOfSdcchTimeSlots == 0
&& singleCellRecords[count].PeakOfSdcchUsed == 0
&& singleCellRecords[count].NoOfAvailableTch == 0
&& singleCellRecords[count].PeakOfTchOrFUsed == 0
&& singleCellRecords[count].NoOfPdch == 0
&& singleCellRecords[count].NoOfPdchSwitchable == 0
&& singleCellRecords[count].NoOfPdchUsed == 0
&& singleCellRecords[count].TotalValidateAttempts == 0
&& singleCellRecords[count].TotalEstablishedCalls == 0
&& singleCellRecords[count].CssrPerc == 0
&& singleCellRecords[count].DroppedCalls == 0
&& singleCellRecords[count].DroppedCallsRate == 0
&& singleCellRecords[count].HandOverAttempts == 0
&& singleCellRecords[count].SuccessfulHandOverAttempts == 0
&& singleCellRecords[count].HandOverSuccessRate == 0
&& singleCellRecords[count].HandOverFailureRate == 0
&& singleCellRecords[count].RandomAccessSuccessRate == 0
&& singleCellRecords[count].SdcchBlks == 0
&& singleCellRecords[count].SdcchCongInTime == 0
&& singleCellRecords[count].TchBlks == 0
&& singleCellRecords[count].TchCongInTime == 0
&& singleCellRecords[count].CongHandovers == 0
&& singleCellRecords[count].DirectedRetryCalls == 0
&& singleCellRecords[count].SdcchDrps == 0
&& singleCellRecords[count].DynSdcchUsed == 0
&& singleCellRecords[count].TchDrps == 0
&& singleCellRecords[count].ErlMinDrop == 0
&& singleCellRecords[cou
R Harshal 16-May-14 10:07am View
   
Anybody can guide me .Please

Thanks
Harshal
R Harshal 16-May-14 7:03am View
   
if you have any query feel free to ask .
R Harshal 16-May-14 7:02am View
   
Please go through the code once again ,as i have made some changes in it.

Thanks
Harshal
R Harshal 16-May-14 6:52am View
   
I have try a lot but then to my If condition is not working .Please advice me.

Thanks
Harshal
R Harshal 16-May-14 6:40am View
   
for any reference please have a look in code.
public IEntityCollectionBase GetZteBbhRecords(IEntityBase xmlConfiguration)
{
IDataReader dataReader = null;
ExcelDataAccess excelDataAccess = null;
IEntityCollectionBase zteBbhRecords = Kaizen2GEntityCreator.GetZteBbhEntityCollection();
try
{
IXmlConfiguration xmlConfig = xmlConfiguration as IXmlConfiguration;
Logger.Write("Inside ZteBbhDataManager.GetZteBbhRecords()", xmlConfig.LogTypeInfo);
excelDataAccess = CommonDataManager.GetDataAccess(xmlConfig);
dataReader = excelDataAccess.ExecuteReader();
IZteBbh zteBbhEntity = null;
while (dataReader.Read())
{
zteBbhEntity = Kaizen2GEntityCreator.GetZteBbhEntity();
zteBbhEntity = CommonDataManager.GetEntityFromExcelRow(dataReader, xmlConfig, zteBbhEntity) as IZteBbh;
if (zteBbhEntity != null)
{
if ((zteBbhEntity.CombinedMaster as ICombinedMaster).CellId > 0
&& !(zteBbhEntity.CombinedMaster as ICombinedMaster).CellName.ToUpper().Contains("TEST"))
{
//// match the record for same CellId.here i need to check
string[] matchID = zteBbhRecords.Cast<iztebbh>().Select(zteBbh => (zteBbh.CombinedMaster as ICombinedMaster).CellId.ToString()).GroupBy(item => item).Where(items => items.Count() > 1).Select(item => item.Key).Distinct().ToArray();
//// string result = ( from m in select m (zteBbhEntity.CombinedMaster as ICombinedMaster).CellId select m).Distinct().ToList();
if (matchID.Length > 0)
{
zteBbhRecords.Cast<iztebbh>().Select(zteBbh => (zteBbh.CombinedMaster as ICombinedMaster).CellId.ToString()).GroupBy(item => item).Where(items => items.Count() > 1).Select(item => item.Key).Distinct().ToArray();
}

if ((zteBbhEntity.CombinedMaster as ICombinedMaster).Circle.Trim().ToUpper() == "ROTN")
{
(zteBbhEntity.CombinedMaster as ICombinedMaster).Circle = "ROTN-ZTE";
}
else if ((zteBbhEntity.CombinedMaster as ICombinedMaster).Circle.Trim().ToUpper() == "AP")
{
(zteBbhEntity.CombinedMaster as ICombinedMaster).Circle = "AP-ZTE";
}

zteBbhEntity.FileLogId = xmlConfig.FileLogId;
zteBbhEntity.HandOverSuccessRate = zteBbhEntity.HandOverSuccessRate * 100;
zteBbhEntity.HandOverFailureRate = zteBbhEntity.HandOverFailureRate * 100;
zteBbhEntity.RandomAccessSuccessRate = zteBbhEntity.RandomAccessSuccessRate * 100;
zteBbhEntity.TbfSuccessRateUl = zteBbhEntity.TbfSuccessRateUl * 100;
zteBbhEntity.TbfSuccessRateDl = zteBbhEntity.TbfSuccessRateDl * 100;
zteBbhRecords.Add(zteBbhEntity);
}
}
}

Logger.Write("Exiting ZteBbhDataManager.GetZteBbhRecords()", xmlConfig.LogTypeInfo);
}
catch (Exception exception)
{
throw exception;
}
finally
{
dataReader.CloseDataReader();
excelDataAccess.CloseConnection();
}

return zteBbhRecords;
}
R Harshal 16-May-14 6:19am View
   
Thanks Brother .
its working .Thanks A lot.
R Harshal 16-May-14 2:59am View
   
yes you are absolutely right .please can you guide me in my code .it will helpful to me .

Thanks
Harshal
R Harshal 15-May-14 7:38am View
   
yeah i gone through but it get confused in my code .
No worries i got it.
Thanks
Harshal
R Harshal 15-May-14 7:37am View
   
Thanks Buddy.
Thank you so much.
R Harshal 15-May-14 7:14am View
   
I want to use for loop and get one item at a time compare it with all other
items in next for loop for same CellId....as will get it match with any other just break from the loop and return the value in which columns are not null
R Harshal 15-May-14 6:58am View
   
i will make it more easier to understand<br><br>
it has 5 columns say (CellID, A1, A2, B1, B2) If CellID is 1 ,then i want to read the value for CellId<br>
in which other columns are not null. Secondily,no 2 rows will have same CellID but no value in other columns.In this senario,I want to read the value in which<br><br><br>
other column values are not null , even though cellId are same ,Ignore the cellid in which other columns are null .<br><br><br>
this what i want to perform in If condition.I hope everyone can understand what i Required.<br>
CellID| A1 | A2 | B1 | B2 |<br>
--------------------------<br>
1 | 123 | XY | | | <br>
1 | | | | |<br>

In first Row, CellID = 1,A1 = 123,A2 = XY
In Second Row,CellID = 1,A1 = null,A2 = null
Thanks<br>
Harshal
R Harshal 15-May-14 6:33am View
   
In other words,if we found the two record with same cellID then read the cellid record in which other
columns are not null,dont consider the record in which other columns are null.
as simple as that.this I want to implement in my IF Condition.Please anyone can guide me.
very thanks
Harshal
R Harshal 15-May-14 5:21am View
   
In Simple words if i have two records with same CellId then i want to read only the cellID which contains value in other columns as there are number of columns
with cellID,if value is not present in other column then neglect that record.how to implement this in if condition.
Thanks
Harshal
R Harshal 15-May-14 5:03am View
   
Is anyone can help me.

Thanks
Harshal
R Harshal 14-May-14 12:19pm View
   
If the above condition is true for 1 st If condition then it should get the first Record in which data is present not the second one in which values are null.
R Harshal 14-May-14 12:05pm View
   
Please anyone can help me .

Thankful
Harshal.
R Harshal 14-May-14 11:16am View
   
if you want you can refer the above code as i want to make changes in above code .I want to implement the If condition within the exciting If Condition.

Thanks
Harshal
R Harshal 14-May-14 10:37am View
   
i have the excel file .i am reading the data from excel file.In Excel file i have the CellId as Column.
There are two condition i want to implement in it :
1 st condition:
In excel, if cellid(as column) are same for both the rows means in one row values are null and in other rows values are present. it means cellid are same for both row ,one row values are null and in other rows values are present.how can i implement this in if condition.
let us solve this condition for time being later on we will go for other condition.

Thanks
Harshal
R Harshal 13-May-14 9:23am View
   
Ok Thank You .
R Harshal 12-May-14 8:31am View
   
i want to know the statement ,what exactly its doing.
R Harshal 12-May-14 8:30am View
   
its not my own code, it was already written.I want to know it.Its only the select statement but what exactly its selecting will you please let me know.Thanks for your reply.
R Harshal 12-May-14 6:24am View
   
Thanks for your reply.
I got it Buddy.
R Harshal 9-May-14 3:32am View
   
I got the another solutions :
its simple .
we need to modify this
HttpContext.Current.Response.Redirect("Login.aspx");
instead of
Response.Redirect("Login.aspx");

thanks
Harshal
R Harshal 8-May-14 12:36pm View
   
its true ..no worries .
Thank you so much .. for helping ..
R Harshal 8-May-14 12:27pm View
   
should is there any other way ,its getting difficult for me .
thanks
Harshal
R Harshal 8-May-14 12:24pm View
   
i am fresher in this .Please let me know what changes i need to do in my code .Please Fluffy.
Thankful
harshal
R Harshal 8-May-14 12:16pm View
   
for session its work and what about for Response.Redirect .I am getting the same error .
R Harshal 8-May-14 12:16pm View
   
Please help Fluffy ..
R Harshal 8-May-14 12:15pm View
   
for session its work and what about for Response.Redirect .I am getting the same error .
Please help ..
R Harshal 8-May-14 11:56am View
   
yeah but its give me error as follows:

Error 45 An object reference is required for the non-static field, method, or property 'System.Web.UI.Page.Session.get' G:\Quantum IndiaProjects\Code\Kaizen.UI\Kaizen.UI.WEB\Kaizen2G\WebForm1.aspx.cs 32 17 Kaizen.UI.WEB

I have tried this but its give me error.,Kindly help
Thanks
Harshal
R Harshal 8-May-14 10:16am View
   
Anyone can help me please ..
R Harshal 8-May-14 9:30am View
   
Thank you for both of you ..i will keep this in mind.
R Harshal 8-May-14 6:34am View
   
its working for me .<br>
thank you so much .<br>
but this want i want to do .I am not clever in logic ,so how can i improve it.<br>
 <br>
Thanks<br>
harshal
R Harshal 8-May-14 6:29am View
   
yes i got it ...
thank you Sir ...
R Harshal 8-May-14 6:29am View
   
Where it is amended Solution?? .Please let me know.

Thankful
harshal
R Harshal 8-May-14 6:27am View
   
Thank you MR.Swarup Chavan.
Its working .
one more question please,this what i want to build my logic .i want to improve my logic .
how can it possible .
please any reference ..let me know.
Thanks
harshal
R Harshal 8-May-14 5:27am View
   
Please anyone can help me.
R Harshal 8-May-14 5:02am View
   
Thanks for yur reply but i want the space like this : ignore the dots<br>
0<br>
.1<br>
..1<br>
...2<br>
not like this:<br>
0<br>
1<br>
1<br>
2<br>
3<br>
please guide me .<br>
Thanks <br>
Harshal
R Harshal 8-May-14 3:32am View
   
Thanks Buddy.
R Harshal 7-May-14 5:57am View
   
i read it thats why i wrote, the answer which you have provided its already used in my code .
R Harshal 7-May-14 5:45am View
   
Secondily if i use this code on site.master.cs
[WebMethod]
public static void CheckSession()
{
if (Session[KaizenConstants.CURRENTLOGGEDINUSER] == null)
{
Response.Redirect("Login.aspx");
}
}

I am getting the error as :
Error 69 An object reference is required for the non-static field, method, or property 'System.Web.UI.UserControl.Response.get'.

Why is it so .
Please let me know
Thanks
Harshal
R Harshal 7-May-14 5:40am View
   
I already added
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true"
CodeBehind="Kaizen2GChartReport.aspx.cs" Inherits="Kaizen.UI.WEB.Kaizen2GChartReport"
EnableEventValidation="false" %>

but then too i am getting the error :
post http://localhost:49669/kaizen2g/site.master/checksession 500(internal Server Error)

Please help me .
thanks
harshal
R Harshal 6-May-14 12:52pm View
   
its give me the error ..Please guide me.
post http://localhost:49669/kaizen2g/site.master/checksession 500(internal Server Error)
R Harshal 6-May-14 12:49pm View
   
I already used it ..why its not working .Please let me know .i cant get you.
Thanks
harshal
R Harshal 6-May-14 3:32am View
   
Thank you so much.
R Harshal 6-May-14 3:32am View
   
Thank you so much.
R Harshal 5-May-14 11:14am View
   
Thanks Buddy.
R Harshal 5-May-14 11:07am View
   
So i need to write like this as below:
window.location = '<%= this.ResolveClientUrl("Kaizen2GChartReport.aspx") %>';

Is it.??
R Harshal 5-May-14 11:06am View
   
Ok Thank you So much friend
Thanks A Lot .
R Harshal 5-May-14 11:04am View
   
I wrote the code as follows:
$(function () {
debugger;
var timeout = 60000;
$(document).bind("idle.idleTimer", function () {
// function fire when the user goes idle
$.timeoutDialog({ timeout: 1, countdown: 60, logout_redirect_url: 'Login.aspx', restart_on_yes: true });
});
$(document).bind("active.idleTimer", function () {
// function I want to fire when the user becomes active again
window.location.href = "Kaizen2GChartReport.aspx";
});
$.idleTimer(timeout);
});

But i dont have the above .js file .Because of that i cant do anything.Please i want to know how can i get that .js File

please lease Guide me.
Thanks
Harshal
R Harshal 5-May-14 10:55am View
   
is it same as this :
window.location.href = "Kaizen2GChartReport.aspx";

Please let me know.
Thanks
Harshal
R Harshal 5-May-14 10:44am View
   
how to get this both .js files .Please Guide Me .
Thanks
Harshal
R Harshal 5-May-14 10:43am View
   
Please anyone Guide me
R Harshal 2-May-14 12:12pm View
   
u can check the code in my question number :5
i have copy pasted the Code .

Thanks
Harshal