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