private long insertData(DataTable attendanceLogtable, int rowno, string monthCol) { MTSHRDataLayer.AttendanceLog attendanceLog = new MTSHRDataLayer.AttendanceLog(); var result = attendanceLog.InsertAttData(attendanceLogtable.Rows[rowno]["Employee Code"].ToString().Trim(), attendanceLogtable.Rows[rowno]["Employee Name"].ToString().Trim(), attendanceLogtable.Rows[rowno]["In Device Name"].ToString().Trim(), attendanceLogtable.Rows[rowno]["Out Device Name"].ToString().Trim(), attendanceLogtable.Rows[rowno]["Status Code"].ToString().Trim(), Convert.ToInt64(attendanceLogtable.Rows[rowno]["Duration"]), attendanceLogtable.Rows[rowno]["Punch Records"].ToString().Trim(), (attendanceLogtable.Rows[rowno]["In DateTime"].ToString().Trim() != "")? ParseRequestDate(attendanceLogtable.Rows[rowno]["In DateTime"].ToString()):(DateTime?)null, (attendanceLogtable.Rows[rowno]["out DateTime"].ToString().Trim() != "") ? ParseRequestDate(attendanceLogtable.Rows[rowno]["out DateTime"].ToString()) : (DateTime?)null, (monthCol.Trim() != "") ?ParseRequestDate(monthCol) : (DateTime?)null); return(result == -1 ? 0 : result); }
public JsonResult ReadMonthlyAttendanceDetails() { DateTime date = Convert.ToDateTime(TempData["Date"]); TempData.Keep("Date"); DataTable dt = new DataTable(); try { Int64 RoleId = Int64.Parse(Session["RoleId"].ToString()); Int64 UserId = Int64.Parse(Session["UserID"].ToString()); MTSHRDataLayer.AttendanceLog attendance_Log = new MTSHRDataLayer.AttendanceLog(); dt = attendance_Log.ReadMonthlyAttendanceDetails(date, RoleId, UserId); } catch (Exception ex) { ex.Data.Clear(); dt = new DataTable(); } return(Json(JsonConvert.SerializeObject(dt), JsonRequestBehavior.AllowGet)); }