public string plusMinus(string emp, string start, string end)
{
CultureInfo th = new CultureInfo("th-TH");
emp_minusSalaryModel ms = new emp_minusSalaryModel();
info_minusModel minus = new info_minusModel();
List <string> id = new List <string>();
id = ms.check_id_minus_emp_select(emp, start, end);
return(Convert.ToDateTime(start).ToString("dd/MM/yyyy") + "^" + Convert.ToDateTime(end).ToString("dd/MM/yyyy") + "^" + minus.select_minus_emp(id));
}
public void del_Minus(string id)
{
emp_minusSalaryModel ms = new emp_minusSalaryModel();
ms.dataForUpdate(id);
ms.insertMinusSqlaryLOG();
ms.ms_id = id;
ms.ms_end_date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ms.ms_status = "N";
ms.event_status = "D";
ms.insertMinusSqlary_edit();
}
public void minusSalary(string emp)
{
emp_minusSalaryModel ms = new emp_minusSalaryModel();
string check_minus = ms.checkMinus(emp);
ViewData["check_minus"] = check_minus;
// if (check_minus != "0") {
// ViewData["data_minus"] = ms.dataMinus(emp);
ViewData["data_minus"] = ms.emp_minus(emp);
ms.Daymax_minus(emp);
ViewData["max_minus"] = ms.max;
// }
}
public void cancel_minus(string emp, string start, string end)
{
emp_minusSalaryModel ms = new emp_minusSalaryModel();
List <string> mid = ms.cancel_minus(emp, start, end);
foreach (string id in mid)
{
ms.dataForUpdate(id);
ms.insertMinusSqlaryLOG();;
ms.ms_status = "N";
ms.event_status = "U";
ms.insertMinusSqlary_edit();
}
}
public IActionResult edit_minus(string emp_id, string minusId, string minus_edit, string amountMinus)
{
emp_minusSalaryModel emp = new emp_minusSalaryModel();
emp.dataForUpdate(minusId);
emp.insertMinusSqlaryLOG();
emp.ms_ref_emp_id = emp_id;
emp.ms_ref_minus_id = minus_edit;
emp.ms_id = minusId;
emp.ms_amount = amountMinus;
emp.insertMinusSqlary_edit();
return(RedirectToAction("emp", "Employee", new { code = emp_id }));
}
public IActionResult insertMS(string emp_id, IEnumerable <string> txtms_amount, IEnumerable <string> minus_id, string minus_start, string minus_end)
{
var minusAndamount = minus_id.Zip(txtms_amount, (n, a) => new { minus = n, amount = a });
emp_minusSalaryModel ms = new emp_minusSalaryModel();
string str = "";
foreach (var na in minusAndamount)
{
ms.ms_ref_minus_id = na.minus;
ms.ms_amount = na.amount;
ms.ms_ref_emp_id = emp_id;
ms.ms_start_date = minus_start;
ms.ms_end_date = minus_end;
str += na.minus;
ms.insertMinusSqlary();
}
return(RedirectToAction("emp", "Employee", new { code = emp_id }));
}
public string getdata(string start, string end, string emp)
{
emp_minusSalaryModel pay = new emp_minusSalaryModel();
return(pay.getMinus(start, end, emp));
}
public string data_update(string minus)
{
emp_minusSalaryModel ms = new emp_minusSalaryModel();
return(ms.dataForUpdate(minus));
}
