public static ReturnObject CheckShiftCodeAssigned(string shift_code)
{
masters_manage_shift page_object = new masters_manage_shift();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
string query = string.Empty;
int is_active = 0;
try
{
/*check for Employee is anybody has this shift */
query = "SELECT count(Emp_Shift_Detail) from EmployeeMaster where Emp_Shift_Detail='" + shift_code + "' and Emp_Status=1 ";
is_active = db_connection.GetRecordCount(query);
return_object.status = "success";
return_object.return_data = JsonConvert.SerializeObject(is_active, Formatting.Indented);
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_COMPANY_CATEGORY");
return_object.status = "error";
return_object.return_data = "An error occurred while loading data for OT Eligibility. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
return(return_object);
}
public static ReturnObject EditShift(string current)
{
masters_manage_shift page_object = new masters_manage_shift();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
string shift_name = string.Empty;
int count = 0;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
JObject current_data = JObject.Parse(current);
shift_name = current_data["shift_desc"].ToString();
//JObject previous_data = JObject.Parse(previous);
//original_shift_name = previous_data["shift_desc"].ToString();
// if (original_shift_name != shift_name) {
// count = page_object.CheckShiftName(shift_name);
// if (count > 0) {
// return_object.status = "error";
// return_object.return_data = "Shift Name has been taken. Please try again with a different Name.";
// return return_object;
// }
// }
page_object.UpdateDatabase(current_data, "U");
return_object.status = "success";
return_object.return_data = "Shift edited successfully!";
}
catch (Exception ex)
{
Logger.LogException(ex, page, "EDIT_SHIFT");
return_object.status = "error";
return_object.return_data = "An error occurred while saving Shift details. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
public static ReturnObject GetCompanyCategory(string company_code)
{
masters_manage_shift page_object = new masters_manage_shift();
DBConnection db_connection = new DBConnection();
DataTable temp_data_table = new DataTable();
DataSet return_data_set = new DataSet();
ReturnObject return_object = new ReturnObject();
string query = string.Empty;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
/* getting employee category data and adding it to Data set to be returned */
query = "select empcategorycode as employee_category_code, empcategoryname as employee_category_name from employeecategorymaster where companycode = '" + company_code + "' order by empcategoryname";
temp_data_table = db_connection.ReturnDataTable(query);
temp_data_table.TableName = "employee_category";
return_data_set.Tables.Add(temp_data_table);
/* get branch data and add it to the data set to be returned. */
temp_data_table = page_object.GetBranchData(company_code);
temp_data_table.TableName = "branch";
return_data_set.Tables.Add(temp_data_table);
return_object.status = "success";
return_object.return_data = JsonConvert.SerializeObject(return_data_set, Formatting.Indented);
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_COMPANY_CATEGORY");
return_object.status = "error";
return_object.return_data = "An error occurred while loading data for OT Eligibility. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
public static ReturnObject GetShiftDetails(string shift_code)
{
masters_manage_shift page_object = new masters_manage_shift();
DBConnection db_connection = new DBConnection();
DataTable shifts_data_table = new DataTable();
ReturnObject return_object = new ReturnObject();
string query = string.Empty;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
query = "select c.CompanyCode as company_code, c.CompanyName as company_name, s.Shift_Code as shift_code, s.Shift_Desc as shift_desc, s.In_Time as in_time, s.Out_Time as out_time, s.MaxWorkTime as max_overtime, s.ingrace as in_grace, s.brkingrace as break_in_grace, s.brkoutgrace as break_out_grace, s.breakout as break_out, s.breakin as break_in, s.outgrace as out_grace, s.Minovertime as min_overtime, s.StatusNightShift as status_night_shift, s.StatusHalfDay as status_half_day, s.HalfDay as half_day, s.max_overtime as max_shift_end_cut_off_time, s.WeeklyOff1 as weekly_off1, s.WeeklyOff2 as weekly_off2, s.endtime_halfday as end_time_half_day, s.GraceIn as grace_in, s.GraceOut as grace_out, s.Ramadan_InTime as ramadan_in_time, s.Ramadan_OutTime as ramadan_out_time, s.chkifNormalShift as check_if_normal_shift, s.Grace_Bout as grace_break_out, s.Grace_BIn as grace_break_in, s.starttime_halfday as start_time_half_day,branch_code as branch,Employee_Category_Code as category, IsAutoShiftEligible as auto_checked, IsActive as is_active from Shift s, CompanyMaster c where c.CompanyCode = s.CompanyCode and s.Shift_Code = '" + shift_code + "' ";
shifts_data_table = db_connection.ReturnDataTable(query);
return_object.status = "success";
return_object.return_data = JsonConvert.SerializeObject(shifts_data_table, Formatting.Indented);
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_SHIFT_DETAILS");
return_object.status = "error";
return_object.return_data = "An error occurred while loading Shift data. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
