public static void Attendance_Calc(string EMP_ID, string ATT_DT, SqlConnection con, string table)
{
QLNhaHangContext _db = new QLNhaHangContext();
var _dt = DateTime.Parse(ATT_DT);
var rs = _db.Tbldetailsattendance.Where(x => x.EmpId == EMP_ID && x.AttDt == _dt).FirstOrDefault();
if (rs == null || rs.LocB1 == true)
{
return;
}
var rsca = _db.Tbldetailsroster.Where(x => x.ShiId == rs.ShiId).OrderBy(x => x.SeqNo).ToList();
var rsTypeShift = _db.Tbltypeshift.ToList();
ArrayList Ca = new ArrayList();
ArrayList ATT = new ArrayList();
for (int j = 0; j < rsca.Count(); j++)
{
Ca.Add(rsca[j].OnnTm);
Ca.Add(rsca[j].OffTm);
}
Ca.Add(0);
Ca.Add(0);
Ca.Add(0);
Ca.Add(0);
for (int j = 1; j <= 5; j++)
{
ATT.Add(T_String.IsNullTo00(T_String.GetPropValue(rs, "Onn" + j.ToString("00")) + ""));
ATT.Add(T_String.IsNullTo00(T_String.GetPropValue(rs, "Off" + j.ToString("00")) + ""));
}
string NOT_DR = rs.NotDr + "";
int pos = NOT_DR.IndexOf("Sign");
if (pos >= 0)
{
int pos1 = PublicFunction.S_Left(NOT_DR, pos + 4).LastIndexOf(";");
if (pos1 > 0)
{
NOT_DR = NOT_DR.Substring(pos1 + 1, pos - pos1 + 3);
}
else
{
NOT_DR = NOT_DR.Substring(0, pos + 4);
}
}
else
{
NOT_DR = "";
}
Attendance_Calc(EMP_ID, ATT_DT, con, Ca, ATT, rs.ShiId + "", rsca, null, rsTypeShift, table, NOT_DR);
}
public TbldeparmentsController(QLNhaHangContext context)
{
_context = context;
}
public IActionResult CalDailyAttendancePost()
{
//var r = Request;
QLNhaHangContext _db = new QLNhaHangContext();
List <Tbldetailsattendance> l = new List <Tbldetailsattendance>();
using (var reader = new StreamReader(Request.Body))
{
var body = reader.ReadToEnd();
var _obj = (Newtonsoft.Json.Linq.JArray)JsonConvert.DeserializeObject(body);
foreach (var x in _obj)
{
var datt = _db.Tbldetailsattendance.Where(z => z.EmpId == x.Value <string>("EmpId") && z.AttDt == x.Value <DateTime>("AttDt")).FirstOrDefault();
string st = x.Value <string>("NotDr") + "";
if (st.IndexOf("Sign") < 0)
{
datt.NotOr = x.Value <string>("NotDr");
}
datt.NotDr = "{UserLogin}" + " Sign";
datt.NotD1 = "";
//datt.EmpId = x.Value<string>("EmpId");
//datt.AttDt = x.Value<DateTime>("AttDt");
for (int j = 1; j <= 5; j++)
{
T_String.SetPropValue(datt, "Onn" + j.ToString("00"), x.Value <int>("Onn" + j.ToString("00")));
T_String.SetPropValue(datt, "Off" + j.ToString("00"), x.Value <int>("Off" + j.ToString("00")));
}
_db.SaveChanges();
l.Add(datt);
}
// Do something
}
ArrayList a = new ArrayList();
var rsTypeShift = _db.Tbltypeshift.ToList();
int dem = 0 /*, i = 0;*/;
for (int i = 0; i < l.Count; i++)
{
string EMP_ID = l[i].EmpId + "";
DateTime d1 = DateTime.Parse(l[i].AttDt + "");
string SHI_ID = l[i].ShiId + "";
var rsca = _db.Tbldetailsroster.Where(x => x.ShiId == SHI_ID).OrderBy(x => x.SeqNo).ToList();
ArrayList Ca = new ArrayList();
ArrayList ATT = new ArrayList();
for (int j = 0; j < rsca.Count(); j++)
{
Ca.Add(rsca[j].OnnTm);
Ca.Add(rsca[j].OffTm);
}
Ca.Add(0);
Ca.Add(0);
Ca.Add(0);
Ca.Add(0);
for (int j = 1; j <= 5; j++)
{
ATT.Add(T_String.IsNullTo00(T_String.GetPropValue(l[i], "Onn" + j.ToString("00")) + ""));
ATT.Add(T_String.IsNullTo00(T_String.GetPropValue(l[i], "Off" + j.ToString("00")) + ""));
}
AttendanceHelper.Attendance_Calc(EMP_ID, d1.ToString("yyyy/MM/dd"), null, Ca, ATT, SHI_ID, rsca, null, rsTypeShift, "TBLDETAILSATTENDANCE", l[i].NotDr + "");
dem++;
}
return(View());
}
public AttendanceController(QLNhaHangContext db)
{
_db = db;
}
public IActionResult CalDailyAttendance(DailyAttendanceEditViewModel model)
{
//var r = Request;
var err = "";
try {
QLNhaHangContext _db = new QLNhaHangContext();
List <Tbldetailsattendance> l = new List <Tbldetailsattendance>();
//using (var reader = new StreamReader(Request.Body))
//{
//var body = reader.ReadToEnd();
//var _obj = (Newtonsoft.Json.Linq.JArray)JsonConvert.DeserializeObject(body);
//foreach (var x in _obj)
//{
var datt = _db.Tbldetailsattendance.Where(z => z.EmpId == model.EMP_ID && z.AttDt == model.ATT_DT).FirstOrDefault();
string st = model.NOT_DR + "";
if (st.IndexOf("Sign") < 0)
{
datt.NotOr = model.NOT_DR;
}
datt.NotDr = "{UserLogin}" + " Sign";
datt.NotD1 = "";
//datt.EmpId = x.Value<string>("EmpId");
//datt.AttDt = x.Value<DateTime>("AttDt");
for (int j = 1; j <= 5; j++)
{
var _onn = (T_String.GetPropValue(model, "ONN_" + j.ToString("00")) + "").Replace(":", "");
var _off = (T_String.GetPropValue(model, "OFF_" + j.ToString("00")) + "").Replace(":", "");
T_String.SetPropValue(datt, "Onn" + j.ToString("00"), _onn == "" ? "0" : _onn);
T_String.SetPropValue(datt, "Off" + j.ToString("00"), _off == "" ? "0" : _off);
}
_db.SaveChanges();
l.Add(datt);
//}
// Do something
//}
ArrayList a = new ArrayList();
var rsTypeShift = _db.Tbltypeshift.ToList();
int dem = 0 /*, i = 0;*/;
for (int i = 0; i < l.Count; i++)
{
string EMP_ID = l[i].EmpId + "";
DateTime d1 = DateTime.Parse(l[i].AttDt + "");
string SHI_ID = l[i].ShiId + "";
var rsca = _db.Tbldetailsroster.Where(x => x.ShiId == SHI_ID).OrderBy(x => x.SeqNo).ToList();
ArrayList Ca = new ArrayList();
ArrayList ATT = new ArrayList();
for (int j = 0; j < rsca.Count(); j++)
{
Ca.Add(rsca[j].OnnTm);
Ca.Add(rsca[j].OffTm);
}
Ca.Add(0);
Ca.Add(0);
Ca.Add(0);
Ca.Add(0);
for (int j = 1; j <= 5; j++)
{
ATT.Add(T_String.IsNullTo00(T_String.GetPropValue(l[i], "Onn" + j.ToString("00")) + ""));
ATT.Add(T_String.IsNullTo00(T_String.GetPropValue(l[i], "Off" + j.ToString("00")) + ""));
}
AttendanceHelper.Attendance_Calc(EMP_ID, d1.ToString("yyyy/MM/dd"), null, Ca, ATT, SHI_ID, rsca, null, rsTypeShift, "TBLDETAILSATTENDANCE", l[i].NotDr + "");
dem++;
}
} catch (Exception ex) {
err += ex.Message + " - " + ex.StackTrace;
}
return(Json(err));
}
public TblsalariesController(QLNhaHangContext context)
{
_context = context;
}
public TbldetailsrostersController(QLNhaHangContext context)
{
_context = context;
}
public TblleavesController(QLNhaHangContext context)
{
_context = context;
}
public TblfoodsController(QLNhaHangContext context)
{
_context = context;
}
public TblemployeesController(QLNhaHangContext context)
{
_context = context;
}
public TbltablecategoriesController(QLNhaHangContext context)
{
_context = context;
}
