Comments by Santhosh23 (Top 71 by date)

Hi Bernhard Hiller,

I am modify the code with your syntax
but i got the this type Error Error
iTextSharp.text.pdf.PdfReader': type used in a using statement must be implicitly convertible to 'System.IDisposable'

hi prabu.. how r u.?

how to get the top 10 records from two tables. order by last-modification desc .

its possible..?
please help me prabhu..
thanks and regards

check your mail and See above Mode 5 stored procedure

give me your email id i will send the table script data

my queries are..
1) First get the Employee Working days between admin approve on days.
2) Second get the total hours for based on above days.
3) detect the hours more than 6 hours.

its possible for single query above requirements.?

if condition query get 4days. how to use 4days(if condition days). how to repeat the loop and get the total hours in particular day wise (above 4 days)

i get the 4 days in sub query how to write query for get the total hours per day wise.
how to repeat the loop.

its my original query..
in mode 5 am get the total working hours admin approved date.

if(@Mode=5) -- Get Total hours In Particular day with employee and ClientID (Client)
BEGIN
DECLARE @FromDate4 DateTime
DECLARE @RegHrs Int
SET @FromDate1 = @From
WHILE @FromDate1 <= @To
BEGIN
IF((select IsDeduct30minforevery6hours from dbo.tblEmployeeWagesFromClient where EmployeeID=@EmployeeID AND EmployerID=@ClientID)=0)
Begin



SELECT DISTINCT EmployeeName,E.EmployeeID,E.Wage, ClientID, (TotalTime/60) 'TotalHours', (TotalTime%60) 'Minites',((TotalTime/60)*60+(TotalTime%60) ) 'TotalMints',
((TotalTime/60)*60+(TotalTime%60) )'Remaing Mintus',
(Convert(varchar,((E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),2)))/60)))+':'+(convert(varchar,((E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),2)))%60))) 'Display',
(((E.TotalTime/60)*60+(E.TotalTime%60))*((E.Wage)/60)) 'PayPeriod',
CASE WHEN (TotalTime='' or Totaltime=0) THEN
(0)
ELSE (0) END 'Detect Mintus'

FROM (
SELECT DISTINCT Emp.EMPLOYEE_FIRSTNAME+' '+Emp.EMPLOYEE_LASTNAME 'EmployeeName',
CONVERT(decimal,EWC.ForHourRate) 'Wage', ETC.EmployeeID,ClientID,SUM(DATEDIFF(mi,FromTime,ToTime)) 'TotalTime'
FROM tblEmployeeTimeCards ETC INNER jOIN
EMPLOYEE_DETAILS Emp on Emp.EMPLOYEE_ID= ETC.EmployeeID inner join
tblEmployeeWagesFromClient EWC on EWC.EmployeeID=ETC.EmployeeID and EWC.EmployerID=ETC.ClientID

where ETC.EmployeeID=@EmployeeID and ETC.ClientID=@ClientID and
convert(Datetime,convert(char(10),ETC.AdminApporveOn,103),103) between convert(Datetime,convert(char(10),@From,103),103) AND convert(Datetime,convert(char(10),@To,103),103)
and
CONVERT(datetime, CONVERT(VARCHAR(10),etC.AdminApporveOn, 112)) = DATEADD(dd, 0, DATEDIFF(dd, 0,@FromDate1))
and ETC.IsAdminApporve=1 and ETC.AdminApporveOn is not null

GROUP BY ETC.EmployeeID,ETC.clientID,Emp.EMPLOYEE_FIRSTNAME,Emp.EMPLOYEE_LASTNAME,EWC.ForHourRate )E
WHERE E.EmployeeID=@EmployeeID and ClientID=@ClientID
SET @FromDate1 =DATEADD(d,1,@FromDate1)

END
ELSE
BEGIN


SELECT DISTINCT EmployeeName, E.EmployeeID,ClientID,Wage, (TotalTime/60) 'TotalHours', (TotalTime%60) 'Minites',((TotalTime/60)*60+(TotalTime%60) ) 'TotalMints',

CASE WHEN (E.TotalTime/60)>=6 THEN E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),1))
ELSE ((TotalTime/60)*60+(TotalTime%60) ) END 'Remaing Mintus',
CASE WHEN (E.TotalTime/60)>=6 THEN (30* ROUND(((E.TotalTime/60)/6),1))
ELSE 0 END 'Detect Mintus',

CASE WHEN (E.TotalTime/60)>=6 THEN (Convert(varchar,((E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),2)))/60)))+':'+(convert(varchar,((E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),2)))%60)))
ELSE (Convert(varchar,((E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),2)))/60)))+':'+(convert(varchar,((E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),2)))%60))) END 'Display',
CASE WHEN ((E.Wage != 0 Or E.Wage !='') and (E.TotalTime/60)>=6 )
THEN (E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),1)))*((Wage)/60)
ELSE (((E.TotalTime/60)*60+(E.TotalTime%60))*((Wage)/60) ) END 'PayPeriod'
FROM (
SELECT DISTINCT Emp.EMPLOYEE_FIRSTNAME+' '+Emp.EMPLOYEE_LASTNAME 'EmployeeName',
CONVERT(decimal,EWC.ForHourRate) 'Wage', ETC.EmployeeID,ClientID,SUM(DATEDIFF(mi,FromTime,ToTime)) 'TotalTime'
FROM tblEmployeeTimeCards ETC inner join
EMPLOYEE_DETAILS Emp on Emp.EMPLOYEE_ID= ETC.EmployeeID inner join
tblEmployeeWagesFromClient EWC on EWC.EmployeeID=ETC.EmployeeID and EWC.EmployerID=ETC.ClientID

where ETC.EmployeeID=@EmployeeID and ETC.ClientID=@ClientID and
CONVERT(datetime, CONVERT(VARCHAR(10),etC.AdminApporveOn, 112)) = DATEADD(dd, 0, DATEDIFF(dd, 0,@FromDate1))
AND
convert(Datetime,convert(char(10),ETC.AdminApporveOn,103),103) between convert(Datetime,convert(char(10),@From,103),103) AND convert(Datetime,convert(char(10),@To,103),103)
and IsAdminApporve=1 and AdminApporveOn is not null
GROUP BY ETC.EmployeeID,ETC.clientID,Emp.EMPLOYEE_FIRS

Declare @Days datetime
Begin


if((select Distinct DATEADD(dd, 0, DATEDIFF(dd, 0,SubmittedOn)) as WorkingDate
--SubmittedOn
from dbo.tblEmployeeTimeCards where
EmployeeID=71 and ClientID=20
and convert(Datetime,convert(char,AdminApporveOn,20),20) between
convert(Datetime,convert(char,'6-7-2013 7:00:00',20),20) AND convert(Datetime,convert(char,'6-21-2013 6:59:00',20),20)) is Not null)
Begin


END


END

just am tried in normal way.. please check my query

yup prabu.. i tried with sub query's. but i got the error like
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

am passing the admin approve date then display the employee working days or request days.

did you get the question 1.. idea..?

yup excalty.. prabu...

ya default value is NULL. when admin approve employee request that time am inserted.
employee send request for admin approval (2013-6-5 & 2013-6-7) but admin approved date is 2013-6-9.
when ever am select the admin approved date ex - 2013-6-9 then shows the working dates. this is question 1

and
2) display the the total working hours day wise. (2013-6-5 working 7hours) (2013-6-5 working 5 hours)
this 2 query example

3)now detect the 30 mints every 6 hours day wise.

Hi Prabu.. How r u..?
I have Employee Time sheet table in this table Form-time and to-time and Admin-Approve-on three columns are there. you are given good solution for me. same like that
1) Admin approve 10 records at a time based on employee request different dates. how to get the employee working dates when admin approve on date.
2) suppose am get 5 the 5 different days then how to get the time record for each and every day..?
3) how to get the working hours. above 6 hrs work detect the 30 mints.

please prabu give me any suggestions.?
thanks and regards

ya i tried declare variables. but not get total some value. another column means. display total some value with in same table.? its possible.?

Hi Prabu..
i have small doubt in sql query. am repeat the while loop in my query. same query executes 10 times. each and every time get some value. how to show total some value(all of some values) or how to sum all some values and display as anther column
please give me any ideas.

thanks and regards

ok prabu i solved my problem. am not mention single code. this is error in my query

hi prabhu how to get the days between two dates
my query like this
select ((DATEDIFF(d,2013-01-25,2013-03-25))) but output shows -2, i given yyyy-mm-dd format
what is error. how to get total days

hi prabu..
i want i more query using Case statement using case
above query inner join with anther table then i didn't get any rows. then how to update one table row value. if else after inner join display any rows no need to update query.

how it possible please help me..
thanks and regards


SELECT E.EmployeeID,E.Day, (E.TotalTime/60) 'TotalHours', (E.TotalTime%60) 'Minites',
CASE WHEN (E.TotalTime/60)>=6 THEN E.TotalTime - (30* ROUND((E.TotalTime/60*6),1))
ELSE (E.TotalTime/60) END 'TotalWorkHours'

good logic..
nice..

hi prabhu..
just am modify single line in your query now its working fine..

CASE WHEN (E.TotalTime/60)>=6 THEN E.TotalTime - (30* ROUND((E.TotalTime/60*6),1))
replace with

CASE WHEN (E.TotalTime/60)>=6 THEN E.TotalTime - (30* ROUND(((E.TotalTime/60)/6),1))

than q so much.. prabu..
i have any doubt in sql server query. i will contact with u..

thanks and regards

my second questions is how to detect the hours from TotalHours. i.e
employee working 14hours in single day. so my question is..
after every 6 hours subtract the 30 mints from TotalHours. employee worked on 14hrs in the Day. so Subtract the 60 mints in total hours. how to write the query for subtract detect hours and get the reaming hours..?
please help me prabhu..
thanks

hi prabu..
thanks for replay
your query is working fine. thank you so much...

just now execute your query display record between two dates

hi Macieij. thanks for your replay.
i have only one record in my table. the record dived into multiple rows based on from-date and to-date differnces

convert(Datetime,convert(char(10),SubmittedOn,103),103) between convert(Datetime,convert(char(10),@From,103),103) AND convert(Datetime,convert(char(10),@To,103),103)

its working fine

thanks dude.. its working fine..

yes.. my colomn datatype is datetime.. but i got the error..

hi Aarti..
thanks for your replay.
just now execute but i got the error

Msg 242, Level 16, State 3, Procedure USP_GetTimeCardReportForEmployee, Line 254
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Hi Friend.. thank for your replay..
i got the some logical ideas..

thank you so much.. Maciej

AjaxControlToolkit.dll is available in bin folder

ya.. AjaxControlToolkit.dll is available in bin folder

ya, am using Image button in child gridview.
please see my Gridview structure.

<asp:GridView ID="ParentGridview" GridLines="Horizontal" AutoGenerateColumns="false" runat="server"
ShowHeader="false" Width="100%" OnRowDataBound="ParentGridview_RowDataBound" Style="border: none!important;">
<columns>
<asp:TemplateField ShowHeader="false">
<itemtemplate>

<tr>
<td colspan="5" align="left" valign="top">
<asp:GridView ID="ChildGridview1" GridLines="Horizontal" OnRowDataBound="ChildGridview1_RowDataBound"
OnRowCommand="ChildGridview1_RowCommand" ShowHeader="false" AutoGenerateColumns="false"
runat="server" Width="100%" Style="border: none!important;">
<columns>
<asp:TemplateField ShowHeader="false">
<itemtemplate>
<table align="left" width="100%">

<tr>
<td colspan="5" align="left" valign="top">
<asp:GridView ID="ChildGridview2" GridLines="None" Width="100%" ShowHeader="true"
OnRowDataBound="ChildGridview2_RowDataBound" Visible="false" OnRowCommand="ChildGridview2_RowCommand" AutoGenerateColumns="false"
runat="server">
<columns>
<asp:TemplateField ShowHeader="true">

<itemtemplate>
<table width="100%">
<tr>

<td align="left" valign="top" width="1%">
<asp:ImageButton ID="imgEdit" runat="server" ImageUrl="../images/delete-icon.png"
CommandName="" />
<asp:ImageButton ID="imgDelete" runat="server" ImageUrl="../images/gtk-edit.png" />
</td>
<td colspan="5" align="left" valign="top">
<asp:GridView ID="ChildGridview3" GridLines="None" Width="100%" ShowHeader="true"

your above codeing working fine..

hi Aarti., Than q for your replay. but in my table Employer 7 having 14 records. how to display all records please help me Aarti..

than q and Regards

just now update my question please see once..

Hi Tadit dash,
Thank so much.. your code is working fine..

hi Vinod,

if($(this).attr("display")==="block") this syntax is correct. actually if condition having only == type format support na..?

i tried on this format, i got error procedure pass the too many multiple parameters, how to pass the 'value1','value1','value3','value4' this way

hi Milind,
your query wroking fine.

select SUBSTRING('city,sate,county,nat',0,CHARINDEX(',','city,sate,county,nat',0))

select SUBSTRING('city,sate,county,nat',
(CHARINDEX(',','city,sate,county,nat',0)+1),(lEN('city,sate,county,nat')-(CHARINDEX(',','city,sate,county,nat',0))))

how to write the same query using 4 parameters please help me

your query working sql statement. same query how to write in stored procedure
am execute procedure

SELECT RECORDID,AVAILABILITY,EMPLOYEMENTSTATUS,CLIENTNAME,DOB,SKILLS,EMAILID,VISA,CREATEDDATE,LOCATION,CITY+', '+C_STATE as LOCATION FROM dbo.RECORDDETAILS where CLIENTNAME in (@CLIENTNAME)

but exec SP_GET_RECORDDETAILS1 'Client Test','IBM','newclient' shows the error too many parameters.
exec SP_GET_RECORDDETAILS1 'Client Test,IBM,newclient'
its show no records
how to write same query in stored procedure.

thank for your replay,

just now am tring your query
am selection two names in listbox.

SELECT RECORDID,AVAILABILITY,EMPLOYEMENTSTATUS,CLIENTNAME,DOB,SKILLS,EMAILID,VISA,CREATEDDATE,LOCATION,CITY+', '+C_STATE as LOCATION
FROM dbo.RECORDDETAILS where CLIENTNAME='newclient,gdgf'

but no records found my query like this

thank for the your replay.
actually i don't have client_id field. and am passing the client-names. depend on user selection. so how to split the values by using , in database. actually we don't no for how many selections in client names

please tel me new approaches..

Hi thanq for you replay.
my is page is refresh is done, but i lost the text box values, how to maintain the textbox values after refresh the my page

how to cal mode parameter.

hi sandeep, this is my query
CREATE PROCEDURE `SP_GETBLOGS`(_MODE INT,_BLOGNAME VARCHAR(100),_DESCRIPTION longtext,_BLOGID INT,_BLOGSUBJECT varchar(100),_ADMINNAME Varchar(1000))
BEGIN
IF(_MODE=1) then
SELECT BLOGID,BLOGNAME, DESCRIPTION,BLOGSUBJECT,POSTEDDATE,ADMINNAME FROM blogpostbyadmin order by BLOGID desc ;
END if;

how write a syntax for my code.
please help me

hi, what is Envirement.? please provide full code. i cant understand your short code

hi thanks for your replay, i have doubt for above code. the two lines are used for which time insert into database or retrieve the data from database.

thanq for replay,
but cant work am tried

hi,
jquery was not called. and it's show the empty alert box.

please help me

Hi Frnd,
How to given correct url.. in your ajax method. me also tried in different ways. please send me your code.. or give me your suggestion
thank u

{"Message":"Cannot convert object of type \u0027System.String\u0027 to type \u0027System.Collections.Generic.IDictionary`2[System.String,System.Object]\u0027","StackTrace":" at System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeInternal(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeMain(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize(JavaScriptSerializer serializer, String input, Type type, Int32 depthLimit)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize[T](String input)\r\n at System.Web.Script.Services.RestHandler.GetRawParamsFromPostRequest(HttpContext context, JavaScriptSerializer serializer)\r\n at System.Web.Script.Services.RestHandler.GetRawParams(WebServiceMethodData methodData, HttpContext context)\r\n at System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext context, WebServiceMethodData methodData)","ExceptionType":"System.InvalidOperationException"}

i got the this type errors on my alert. am modifythe my script like below


<script language="javascript" type="text/javascript">


$(document).ready(function () {


$("#btnok").click(function () {


var title = $("#title").val();
var name = $("#name").val();
var city = $("#city").val();
var state = $("#state").val();
var date = $("#date").val();
var duratin = $("#duration").val();
var pay = $("#pay").val();
var type = $("#type").val();
var industry = $("#industry").val();
var status = $("#status").val();
var description = $("#description").val();
var qualification = $("#qualification").val();
// var data = { title: title, Name: name, city: city, state: state, date: date, duration: duratin, pay: pay, industry: industry, type: type, status: status, description: description, qualification: qualification };
var data = { title:$("#title").val(),name: $("#name").val(), city: $("#city").val(), state: $("#state").val(), date: $("#date").val(),duration:$("#duration").val(),pay:$("#pay").val(),type: $("#type").val(),industry:$("#industry").val(),status:$("#status").val(),description:$("#description").val(),qualification: $("#qualification").val() };
var data = JSON.stringify(data);
alert(data);
$.ajax({
type: "POST",
url: "http://localhost:3658/HostingService.asmx/SETPostJobDetails",
data:JSON.stringify(data),//"{'title':" + title + ",'C.Name':" + name + ",'city':" + city + ",'state':" + state + ",'date':" + date + ",'duration':" + duratin + ",'pay':" + pay + ",'industry':" + industry + ",'type':" + type + ",'status':" + status + ",'description':" + description + ",'qualification':" + qualification + "}",
// data: // "{'title':'" + $("#title").val() + "','C.Name':'" + $("#name").val() + "','city':'" + $("#city").val() + "','state':'" + $("#state").val() + "','date':'" + $("#date").val() + "','duration':'" + $("#duration").val() + "','pay':'" + $("#pay").val() + "','industry':'" + $("#industry").val() + "','type':'" + $("#type").val() + "','status':'" + $("#status").val() + "','description':'" + $("#description").val() + "','qualification':'" + $("#qualification").val() + "'}",
contentType: "application/json;charset=utf-8",
processData: false,
dataType: "json",
success: function (data) {
alert('Success');
},
error: function (data, status, error)

i got the new error in like. this error shows firebug
Error while calling a function using jquery-ajax ("NetworkError: 500 Internal Server Error)

hi tharaka MTR,
just now am modify the script in On-error function. but it shows the empty alert box only. how to solve my problem please help me.

ok this is my services code

[WebMethod, ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public string SETPostJobDetails(string Title, string Type, string Description, string Qualification, string Compensation, string openings, string city,
string state, string name, string phone, string email, string date, string zipcode, string job_categories, string client_id)
{
DataSet ds = new DataSet();
try
{
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = new SqlCommand();
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
adp.SelectCommand.Connection = (SqlConnection)OpenConnection1();
adp.SelectCommand.CommandText = "SP_POST_JOBDETAILS_SET";
SqlParameter[] Parameters = new SqlParameter[15];
Parameters[0] = new SqlParameter("@JOB_TITLE", SqlDbType.VarChar, 100);
Parameters[0].Value = Title;

Parameters[1] = new SqlParameter("@JOB_TYPE", SqlDbType.VarChar, 50);
Parameters[1].Value = Type;

Parameters[2] = new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 5000);
Parameters[2].Value = Description;

Parameters[3] = new SqlParameter("@QUALIFICATIONS", SqlDbType.VarChar, 1000);
Parameters[3].Value = Qualification;

Parameters[4] = new SqlParameter("@COMPENSATION_RANGE", SqlDbType.VarChar, 200);
Parameters[4].Value = Compensation;

Parameters[5] = new SqlParameter("@NO_OF_OPENINGS", SqlDbType.VarChar, 50);
Parameters[5].Value = openings;

Parameters[6] = new SqlParameter("@CITY", SqlDbType.VarChar, 200);
Parameters[6].Value = city;

Parameters[7] = new SqlParameter("@STATE", SqlDbType.VarChar, 100);
Parameters[7].Value = state;

Parameters[8] = new SqlParameter("@CONTACT_NAME", SqlDbType.VarChar, 500);
Parameters[8].Value = name;

Parameters[9] = new SqlParameter("@CONTACT_PHONE", SqlDbType.VarChar, 50);
Parameters[9].Value = phone;

Parameters[10] = new SqlParameter("@EMAIL", SqlDbType.VarChar, 100);
Parameters[10].Value = email;

Parameters[11] = new SqlParameter("@START_DATE", SqlDbType.DateTime);
Parameters[11].Value = Convert.ToDateTime(date);

Parameters[12] = new SqlParameter("@ZIPCODE", SqlDbType.VarChar, 20);
Parameters[12].Value = zipcode;

Parameters[13] = new SqlParameter("@JOB_CATEGORIES", SqlDbType.VarChar, 200);
Parameters[13].Value = job_categories;

Parameters[14] = new SqlParameter("@CLIENT_ID", SqlDbType.Int);
Parameters[14].Value = int.Parse(client_id);

adp.SelectCommand.Parameters.AddRange(Parameters);
adp.Fill(ds);
string[][] JaggedArray = new string[ds.Tables[0].Rows.Count][];
//int i = 0;
//Dictionary<object, object> resultMain = new Dictionary<object, object>();
List<object> resultMain = new List<object>();
foreach (DataRow rs in ds.Tables[0].Rows)
{

Dictionary<string, object=""> result = new Dictionary<string, object="">();

foreach (DataColumn dc in ds.Tables[0].Columns)
{

result.Add(dc.ColumnName, rs[dc].ToString());

}

resultMain.Add(result);


//i = i + 1;
}

JavaScriptSerializer js = new JavaScriptSerializer();

string strJSON = js.Serialize(resultMain);
return strJSON;
}
catch

just now am tired.. but not working and already i added [ScriptService] method in .asmx page..

Yes, get the OnError alert box, and i dont get the data values and always i got undefined values in alert box. and object xmlhttprequest error.. this is are me facing the problems. please help me.. thank and regards

am using versions in phpmyadmin Server version: 5.0.77 ,Protocol version: 10,
Server: mysql2.netcarrier.com via TCP/IP

phpMyAdmin - 2.11.8.1,
MySQL client version: 5.0.51a
Used PHP extensions: mysql

any problem for my versions.. please help me

thanks for your replay..
i am modified the my procedure but i got the error
DELIMITER //
CREATE PROCEDURE `SP_GET_ALLJOBIDS`()
BEGIN
select * from jobdetails ;
END //
DELIMITER ;

Error is:

DELIMITER //
CREATE PROCEDURE `SP_GET_ALLJOBIDS`()
BEGIN
select * from jobdetails ;
END //


SQL query: Documentation

DELIMITER // CREATE PROCEDURE `SP_GET_ALLJOBIDS`() BEGIN select * from jobdetails ; END //

MySQL said: Documentation
#1044 - Access denied for user '***'@'216.178.92.138' to database '****'

a tried your code i got the this type of error
Nullable object must have a value.

thanq u so much... its wrking fine

how to write query for slipt..?