public IHttpActionResult ExcelGetDataFomEmployee(string strorderby)
{
try
{
SalaryStatementModel salary = new SalaryStatementModel();
SqlDataReader SqlDtr = null;
string sql;
sql = "select emp_id,emp_name, salary, ot_compensation from employee where status='1' order by " + strorderby + "";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
controlempid.Add(SqlDtr.GetValue(0).ToString());
controlempname.Add(SqlDtr.GetValue(1).ToString());
controlbasicsalary.Add(SqlDtr.GetValue(2).ToString());
controlextradays.Add(SqlDtr.GetValue(3).ToString());
}
SqlDtr.Close();
salary.empid = controlempid;
salary.empname = controlempname;
salary.basicsalary = controlbasicsalary;
salary.extradays = controlextradays;
return(Ok(salary));
}
catch (Exception)
{
return(Content(HttpStatusCode.NotFound, "Data Not Found"));
}
}
public IHttpActionResult SelectSSRincentive()
{
try
{
SqlDataReader SqlDtr = null;
SalaryStatementModel salary = new SalaryStatementModel();
string sql;
sql = "select SSRincentiveStatus,SSRincentive from setDis";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
salary.SSRincentiveStatus = SqlDtr.GetValue(0).ToString();
salary.SSRincentive = SqlDtr.GetValue(1).ToString();
}
SqlDtr.Close();
return(Ok(salary));
}
catch (Exception)
{
return(Content(HttpStatusCode.NotFound, "Data Not Found"));
}
}
public IHttpActionResult PrintSelectSumAndTime(string str2, string str3, string Emp_id)
{
try
{
SalaryStatementModel salary = new SalaryStatementModel();
SqlDataReader SqlDtr;
string sql;
sql = "select sum(datepart(hour,Ot_To)-datepart(hour,Ot_From)) OT_Hour,sum(datepart(minute,Ot_To)-datepart(minute,Ot_From)) OT_Minute from OverTime_Register where cast(floor(cast(OT_Date as float)) as datetime) >= '" + str2 + "' and cast(floor(cast(OT_Date as float)) as datetime) <= '" + str3 + "' and emp_id='" + Emp_id + "'";
SqlDtr = obj.GetRecordSet(sql);
while (SqlDtr.Read())
{
salary.hour = SqlDtr.GetValue(0).ToString();
salary.min = SqlDtr.GetValue(1).ToString();
}
SqlDtr.Close();
return(Ok(salary));
}
catch (Exception)
{
return(Content(HttpStatusCode.NotFound, "Data Not Found"));
}
}
