public string Save(List <HumanResource_EmployeeBasic> objEmployee, DateTime objStartDate, List <Common_WeekOff> objWeekOff, User user) { string rv = ""; try { foreach (var witem in objWeekOff) { Common_WeekOff eWeekOff = new Common_WeekOff(); eWeekOff.DayID = witem.DayID; eWeekOff.StartDate = objStartDate; foreach (var item in objEmployee) { eWeekOff.EmpID = item.EmpID; _dataService.Save(eWeekOff, user); } } rv = Operation.Success.ToString(); } catch (Exception e) { rv = Operation.Error.ToString(); } return(rv); }
private void InsertShift(Common_WeekOff ww, User user) { _dbConn = new SqlConnection(_connectionString); _dbConn.Open(); _cmd = new SqlCommand("sp_Insert_WeekOff", _dbConn) { CommandType = CommandType.StoredProcedure }; _cmd.Parameters.Add(new SqlParameter("@call_name", "InsertWeekOff")); _cmd.Parameters.Add(new SqlParameter("@EmpID", ww.EmpID)); _cmd.Parameters.Add(new SqlParameter("@DayID", ww.DayID)); _cmd.Parameters.Add(new SqlParameter("@StartDate", ww.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 void Save(Common_WeekOff eWeekOff, User user) { InsertShift(eWeekOff, user); }