public static ReturnObject DoReprocess(string employees, string from_date, string to_date)
{
attendance_reprocess page_object = new attendance_reprocess();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
Hashtable reprocessing_data = new Hashtable();
DataTable process_flags = new DataTable();
if (HttpContext.Current.Session["username"] == null)
{
// HttpContext.Current.Response.Redirect("~/logout.aspx", true);
return_object = page_object.DoLogout();
}
else
{
List <string> employees_list = JsonConvert.DeserializeObject <List <string> >(employees);
StringBuilder employee_id_string = new StringBuilder();
DateTime
from_date_time, to_date_time;
string
query = string.Empty;
int
i = 0, process_flag_1 = 0, process_flag_2 = 0;
try
{
query = "select p.pflag, r.re_flag from ProcessingStatus p, ReprocessFlag r";
process_flags = db_connection.ReturnDataTable(query);
if (process_flags.Rows.Count > 0)
{
process_flag_1 = Convert.ToInt32(process_flags.Rows[0]["pflag"]);
process_flag_2 = Convert.ToInt32(process_flags.Rows[0]["re_flag"]);
}
if (process_flag_1 == 1 || process_flag_2 == 1)
{
return_object.status = "error";
return_object.return_data = "Processing is in progress, please wait.";
}
else
{
for (i = 0; i < employees_list.Count; i++)
{
employee_id_string.Append(employees_list[i]);
employee_id_string.Append(",");
}
if (employee_id_string.ToString() == "")
{
return_object.status = "error";
return_object.return_data = "Please select at least one employee.";
}
else
{
employee_id_string.Remove(employee_id_string.Length - 1, 1);
from_date_time = DateTime.ParseExact(from_date, "dd-MM-yyyy", CultureInfo.InvariantCulture);
to_date_time = DateTime.ParseExact(to_date, "dd-MM-yyyy", CultureInfo.InvariantCulture);
reprocessing_data.Add("fromdate", from_date_time.ToString("yyyy-MM-dd"));
reprocessing_data.Add("todate", to_date_time.ToString("yyyy-MM-dd"));
reprocessing_data.Add("empid", employee_id_string.ToString());
db_connection.ExecuteStoredProcedureWithHashtable_WithoutReturn("securtimereprocess_Empid", reprocessing_data);
return_object.status = "success";
return_object.return_data = "Processing completed successfully!";
}
}
}
catch (Exception ex)
{
Logger.LogException(ex, page, "REPROCESS_DATA");
return_object.status = "error";
return_object.return_data = "An error occurred while reprocessing the data. Please try again. If the error persists, please contact Support.";
throw;
}
}
return(return_object);
}
public static ReturnObject GetReprocessData(int page_number, string filters)
{
attendance_reprocess page_object = new attendance_reprocess();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
DataTable reprocess_data = new DataTable();
DataTable coManager_data = new DataTable();
string query = string.Empty,
comanager_id = string.Empty,
branch_list = string.Empty,
employee_code = string.Empty;
int
start_row = (page_number - 1) * 30,
number_of_rows = page_number * 30 + 1,
access, count = 0;
try
{
query = page_object.GetBaseQuery();
query = page_object.GetFilterQuery(filters, query);
access = Convert.ToInt32(HttpContext.Current.Session["access_level"]);
employee_code = HttpContext.Current.Session["username"].ToString();
if (access == 1 || access == 3)
{
//If logged in manager is a delegation manager for any manager, Get the ManagerID to fetch details of related employee
comanager_id = null;
count = db_connection.ExecuteQuery_WithReturnValueInteger("select COUNT(DelidationManagerID) from TbAsignDelegation where DelidationManagerID = '" + employee_code + "' and DeliationStatus = 1 and Convert(date,Getdate()) >= Convert(date,Fromdate) and Convert(date,Getdate()) <= Convert(date,Todate)");
if (count > 0)
{
coManager_data = db_connection.ReturnDataTable("select ManagerId from TbAsignDelegation where DelidationManagerID = '" + employee_code + "' And DeliationStatus = 1");
if (coManager_data.Rows.Count > 0)
{
foreach (DataRow dr in coManager_data.Rows)
{
comanager_id += "'" + dr["ManagerId"] + "',";
}
comanager_id = comanager_id.TrimEnd(',');
}
}
if (string.IsNullOrEmpty(comanager_id))
{
comanager_id = "'Empty'";
}
//get list of branches assigned to logged in manager hr
branch_list = "'Empty',";
DataTable branch_data = db_connection.ReturnDataTable("select BranchCode from TbManagerHrBranchMapping where ManagerID = '" + employee_code + "' ");
if (branch_data.Rows.Count > 0)
{
foreach (DataRow branch in branch_data.Rows)
{
branch_list += "'" + branch["BranchCode"] + "',";
}
}
branch_list = branch_list.TrimEnd(',');
query += " and (Emp_Branch In (" + branch_list + ") Or ManagerID In('" + employee_code + "'," + comanager_id + ") ) ";
}
query += " ) a where row > " + start_row + " and row < " + number_of_rows;
reprocess_data = db_connection.ReturnDataTable(query);
return_object.status = "success";
return_object.return_data = JsonConvert.SerializeObject(reprocess_data, Formatting.Indented);
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_REPROCESS_DATA");
return_object.status = "error";
return_object.return_data = "An error occurred while loading the data. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
return(return_object);
}