public List <emp_minusSalaryModel> emp_minus(string emp)
{
dbFile db = new dbFile();
List <emp_minusSalaryModel> obj = new List <emp_minusSalaryModel>();
CultureInfo en = new CultureInfo("EN");
List <string> ls = new List <string>();
List <string> le = new List <string>();
try
{
using (SqlConnection conn = new SqlConnection(db.sqlConnection))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT ms_start_date, ms_end_date FROM tab_emp_minusSalary WHERE ms_ref_emp_id = '" + emp + "' AND ms_status = 'Y' AND event_status != 'D' GROUP BY ms_start_date , ms_end_date", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
emp_minusSalaryModel pay = new emp_minusSalaryModel();
pay.ms_start_date = Convert.ToDateTime(rdr["ms_start_date"]).ToString("dd MMMM yyyy", th);
pay.ms_end_date = Convert.ToDateTime(rdr["ms_end_date"]).ToString("dd MMMM yyyy", th);
pay.start = Convert.ToDateTime(rdr["ms_start_date"]).ToString("yyyy-MM-dd", en);
pay.end = Convert.ToDateTime(rdr["ms_end_date"]).ToString("yyyy-MM-dd", en);
obj.Add(pay);
}
}
}
catch {
}
return(obj);
}
public List <emp_minusSalaryModel> dataMinus(string emp)
{
List <emp_minusSalaryModel> obj = new List <emp_minusSalaryModel>();
using (SqlConnection conn = new SqlConnection(connectionString())) {
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tab_emp_minusSalary INNER JOIN tab_info_minus ON tab_info_minus.minus_id = ms_ref_minus_id WHERE ms_ref_emp_id = '" + emp + "'", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
emp_minusSalaryModel ms = new emp_minusSalaryModel();
ms.ms_id = rdr["ms_id"].ToString();
ms.ms_ref_minus_id = rdr["ms_ref_minus_id"].ToString();
ms.ms_minus_name = rdr["minus_name"].ToString();
ms.ms_amount = rdr["ms_amount"].ToString();
ms.ms_ref_emp_id = rdr["ms_ref_emp_id"].ToString();
ms.ms_admin_id = rdr["ms_admin_id"].ToString();
ms.ms_submit_date = rdr["ms_submit_date"].ToString();
ms.event_status = rdr["event_status"].ToString();
obj.Add(ms);
}
conn.Close();
}
return(obj);
}
