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