public ActionResult GetTimeSheetByStatus(UpdateTimeSheetStatusModels data)
{
TimeSheetModel TS = null;
List <TimeSheetModel> timeSheets = null;
try
{
using (var con = db.Gdb())
{
timeSheets = new List <TimeSheetModel>();
SqlCommand cmd = new SqlCommand("dbo.spGetTimeSheetByStatus", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", data.userId);
cmd.Parameters.AddWithValue("@status", data.status);
con.Open();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
TS = new TimeSheetModel();
TS.id = Convert.ToInt32(rd["id"]);
TS.timeSheetKey = Convert.ToString(rd["timeSheetKey"]);
TS.type = Convert.ToString(rd["type"]);
TS.startTime = Convert.ToString(rd["start_time"]);
TS.endTime = Convert.ToString(rd["end_time"]);
TS.breaks = Convert.ToString(rd["breaks"]);
TS.workTime = Convert.ToString(rd["work_time"]);
TS.notes = Convert.ToString(rd["notes"]);
TS.entryDate = Convert.ToDateTime(rd["entryDate"]);
TS.timeSheetStatus = Convert.ToString(rd["timeSheetStatus"]);
TS.m3 = Convert.ToInt32(rd["m3"]);
TS.kmStand = Convert.ToInt32(rd["km_stand"]);
TS.privat = Convert.ToInt32(rd["privat"]);
TS.fuel = Convert.ToInt32(rd["fuel"]);
TS.adblue = Convert.ToInt32(rd["adblue"]);
TS.UserId = Convert.ToInt32(rd["employeeId"]);
timeSheets.Add(TS);
}
con.Close();
}
}
catch (Exception)
{
throw;
}
return(Ok(timeSheets));
}
public ActionResult UpdateTimeSheetStatus(UpdateTimeSheetStatusModels model)
{
using (var con = db.Gdb())
{
SqlCommand cmd = new SqlCommand("dbo.spUpdateStatus", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userId", model.userId);
cmd.Parameters.AddWithValue("@monthStart", Convert.ToDateTime(model.monthStart));
cmd.Parameters.AddWithValue("@monthEnd", Convert.ToDateTime(model.monthEnd));
cmd.Parameters.AddWithValue("@status", model.status);
con.Open();
cmd.ExecuteNonQuery();
}
if (model.status == "approved by employee")
{
EmployeeModel EM = new EmployeeModel();
using (var con = db.Gdb())
{
SqlCommand cmdd = new SqlCommand($"SELECT * FROM Employee WHERE id = '{model.userId}'", con);
con.Open();
SqlDataReader rd = cmdd.ExecuteReader();
while (rd.Read())
{
EM = new EmployeeModel();
EM.id = Convert.ToInt32(rd["id"]);
EM.userName = Convert.ToString(rd["userName"]);
EM.level = Convert.ToString(rd["level_"]);
}
}
CreateTimeSheet(EM);
}
return(Ok());
}
