public ActionResult Save(List <HumanResource_EmployeeBasic> objEmployee, Common_Shift objShift) { var user = (User)Session["CurrentUser"]; var res = _employeeShiftRepository.Save(objEmployee, objShift, user); return(Json(res, JsonRequestBehavior.AllowGet)); }
public string SaveShift(Common_Shift objShift) { string rv = ""; try { Insert_Update_Shift("sp_Insert_Common_Shift", "saveShiftinfo", objShift); rv = Operation.Success.ToString(); } catch (Exception ex) { rv = ex.Message; } return(rv); }
private void InsertShift(Common_Shift ss, User user) { _dbConn = new SqlConnection(_connectionString); _dbConn.Open(); _cmd = new SqlCommand("sp_Insert_Shift", _dbConn) { CommandType = CommandType.StoredProcedure }; _cmd.Parameters.Add(new SqlParameter("@call_name", "InsertShift")); _cmd.Parameters.Add(new SqlParameter("@EmpID", ss.EmpID)); _cmd.Parameters.Add(new SqlParameter("@ShiftID", ss.ShiftID)); _cmd.Parameters.Add(new SqlParameter("@StartDate", ss.StartDate.ToString("yyyy-MM-dd"))); _cmd.Parameters.Add(new SqlParameter("@UserID", user.USERID)); _cmd.Parameters.Add(new SqlParameter("@TerminalID", user.TermID)); _da = new SqlDataAdapter(_cmd); _dt = new DataTable(); _da.Fill(_dt); _dbConn.Close(); }
public DataTable Insert_Update_Shift(string procedure, string callname, Common_Shift objShift) { dbConn = new SqlConnection(ConnectionString); dbConn.Open(); cmd = new SqlCommand(procedure, dbConn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@call_name", callname)); cmd.Parameters.Add(new SqlParameter("@p_ShiftId", objShift.ShiftID)); cmd.Parameters.Add(new SqlParameter("@p_ShiftName", objShift.ShiftName)); cmd.Parameters.Add(new SqlParameter("@p_ShiftShort", objShift.ShiftShort)); cmd.Parameters.Add(new SqlParameter("@p_ShiftIn", objShift.MinDateChange(objShift.ShiftIn))); cmd.Parameters.Add(new SqlParameter("@p_ShiftLate", objShift.MinDateChange(objShift.ShiftLate))); cmd.Parameters.Add(new SqlParameter("@p_ShiftAbsent", objShift.MinDateChange(objShift.ShiftAbsent))); cmd.Parameters.Add(new SqlParameter("@p_ShiftEarly", objShift.MinDateChange(objShift.ShiftEarly))); cmd.Parameters.Add(new SqlParameter("@p_ShiftOut", objShift.MinDateChange(objShift.ShiftOut))); cmd.Parameters.Add(new SqlParameter("@p_ShiftLastPunch", objShift.MinDateChange(objShift.ShiftLastPunch))); cmd.Parameters.Add(new SqlParameter("@p_ShiftLunchFrom", objShift.MinDateChange(objShift.ShiftLunchFrom))); cmd.Parameters.Add(new SqlParameter("@p_ShiftLunchTill", objShift.MinDateChange(objShift.ShiftLunchTill))); cmd.Parameters.Add(new SqlParameter("@p_ShiftIfterFrom", objShift.MinDateChange(objShift.ShiftIfterFrom))); cmd.Parameters.Add(new SqlParameter("@p_ShiftIfterTill", objShift.MinDateChange(objShift.ShiftIfterTill))); cmd.Parameters.Add(new SqlParameter("@p_NightBreakFrom", objShift.MinDateChange(objShift.NightBreakFrom))); cmd.Parameters.Add(new SqlParameter("@p_NightBreakTill", objShift.MinDateChange(objShift.NightBreakTill))); cmd.Parameters.Add(new SqlParameter("@p_SheriBreakFrom ", objShift.MinDateChange(objShift.SheriBreakFrom))); cmd.Parameters.Add(new SqlParameter("@p_SheriBreakTill", objShift.MinDateChange(objShift.SheriBreakTill))); cmd.Parameters.Add(new SqlParameter("@p_IsLunch", objShift.IsLunch)); cmd.Parameters.Add(new SqlParameter("@p_IsTiffin", objShift.IsTiffin)); cmd.Parameters.Add(new SqlParameter("@p_TiffinTime", objShift.MinDateChange(objShift.TiffinTime))); cmd.Parameters.Add(new SqlParameter("@p_IsIfter", objShift.IsIfter)); cmd.Parameters.Add(new SqlParameter("@p_IfterTime", objShift.MinDateChange(objShift.IfterTime))); cmd.Parameters.Add(new SqlParameter("@p_IsNight", objShift.IsNight)); cmd.Parameters.Add(new SqlParameter("@p_NightTime", objShift.MinDateChange(objShift.NightTime))); cmd.Parameters.Add(new SqlParameter("@p_ShiftType", objShift.ShiftType)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); dbConn.Close(); return(dt); }
public string Save(List <HumanResource_EmployeeBasic> objEmployee, Common_Shift objShift, User user) { string rv = ""; try { foreach (var item in objEmployee) { Common_Shift Ss = new Common_Shift(); Ss.EmpID = item.EmpID; Ss.ShiftID = objShift.ShiftID; Ss.StartDate = objShift.StartDate; _dataService.Save(Ss, user); } rv = Operation.Success.ToString(); } catch (Exception e) { rv = Operation.Error.ToString(); } return(rv); }
public void Save(Common_Shift ss, User user) { InsertShift(ss, user); }
public string SaveShift(Common_Shift objShift) { return(_ShiftDataService.SaveShift(objShift)); }