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());
}
