public static string manualAtt(string enrollno, string pdate, string inTime, string outTime, string companyid, string inNid, string oNid, string Addedby) { StringBuilder sb = new StringBuilder(); ClsAttendence objAtt = new ClsAttendence(); DataSet ds = new DataSet(); objAtt.Enrollno = enrollno; objAtt.Action = "Insert"; objAtt.Date = pdate; objAtt.CompanyID = companyid; objAtt.Ptime = inTime; objAtt.PTime1 = outTime; objAtt.Inid = inNid; objAtt.Onid = oNid; objAtt.AddedBy = ""; ds = objAtt.OpAttendance(); string msg = ""; if (ds.Tables[0].Rows.Count > 0) { msg = ds.Tables[0].Rows[0][1].ToString(); } return(msg); }
public static string getAttandence(string fromdate, string todate, string companyid, string userid) { StringBuilder sb = new StringBuilder(); ClsAttendence objAtt = new ClsAttendence(); objAtt.Action = "DateFilter"; objAtt.Enrollno = userid; objAtt.Date = fromdate; objAtt.EndDate = todate; objAtt.CompanyID = companyid; DataSet ds = new DataSet(); ds = objAtt.GetAttendence(); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { sb.Append("<table class='table table-success mb30'>"); sb.Append("<tr class='gridheader'>"); for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { sb.Append("<th>" + ds.Tables[0].Columns[i].ColumnName + "</th>"); } sb.Append("</tr>"); for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { sb.Append("<tr>"); for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { sb.Append("<td>" + ds.Tables[0].Rows[j][i].ToString() + "</td>"); } sb.Append("</tr>"); } sb.Append("</table>"); } } return(sb.ToString()); }
public static string getNID(string enrollno, string pdate, string companyid) { StringBuilder sb = new StringBuilder(); ClsAttendence objAtt = new ClsAttendence(); DataSet ds = new DataSet(); objAtt.Enrollno = enrollno; objAtt.Action = "getnid"; objAtt.Date = pdate; objAtt.CompanyID = companyid; ds = objAtt.OpAttendance(); if (ds.Tables[0].Rows.Count > 0) { sb.Append(ds.Tables[0].Rows[0]["intime"].ToString() + "###"); sb.Append(ds.Tables[0].Rows[0]["outtime"].ToString() + "###"); sb.Append(ds.Tables[0].Rows[0]["inNid"].ToString() + "###"); sb.Append(ds.Tables[0].Rows[0]["onid"].ToString()); } return(sb.ToString()); }