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