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 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 void UpdateSql()
{
string sql1 = "";
string sql = "";
Get_ATT_HR();
var phep = (from l in _db.Tblleave
join tl in _db.Tbltypeleave on l.LeaId equals tl.LeaId
where l.EmpId == EMP_ID && l.StrDt.Value.CompareTo(DateTime.Parse(ATT_DT)) <= 0 &&
l.EndDt.Value.CompareTo(DateTime.Parse(ATT_DT)) >= 0
select new ExLeave()
{
leave = l, leave_name = tl.LeaNm
}).ToList();
GetPhep(phep);
//Round();
GetNote();
var roster = _db.Tblroster.Where(x => x.ShiId == SHI_ID).FirstOrDefault();
double ADD_H1 = T_String.IsNullTo00(roster.AddH1 + "");
double ADD_H2 = T_String.IsNullTo00(roster.AddH2 + "");
double CON_H1 = T_String.IsNullTo00(roster.ConH1 + "");
double CON_H2 = T_String.IsNullTo00(roster.ConH2 + "");
if (NOT_DD + "" != "")
{
NOT_DR = NOT_DD + "; " + NOT_DR;
}
var _tdt = DateTime.Parse(ATT_DT);
var att = _db.Tbldetailsattendance.Where(x => x.AttDt == _tdt && x.EmpId == EMP_ID).FirstOrDefault();
if (att == null)
{
return;
}
sql = "Update [" + tb + "] set ";
double WRK_HR = 0;
for (int i = 0; i < Name.Count; i++)
{
switch (Name[i] + "")
{
case "ATT_HR":
if (ATT_MAX > 0)
{
if (ADD_H1 > 0 && (Double)Data[i] > CON_H1)
{
ATT_MAX = T_String.CongTG(ATT_MAX, ADD_H1);
if ((Double)Data[i] > 0)
{
Data[i] = T_String.CongTG(ADD_H1, (Double)Data[i]);
}
}
WRK_HR = T_String.CongTG(WRK_HR, (Double)Data[i]); //T_String.IsNullTo00(Data[i]+""));
int tam = (int)T_String.CongTG(T_String.IsNullTo0(Data[i] + ""), OTR_HR);
if (sql1 != "")
{
sql1 += ",";
}
//var tmpa = T_String.DT_HourMinConvertToHour(tam);
//var tmpb = T_String.DT_HourMinConvertToHour((int)ATT_MAX);
sql1 += "ATT_DY=" + T_String.DT_HourMinConvertToHour(tam) / T_String.DT_HourMinConvertToHour((int)ATT_MAX);
T_String.SetPropValue(att, "AttDy", T_String.DT_HourMinConvertToHour(tam) / T_String.DT_HourMinConvertToHour((int)ATT_MAX));
}
else
{
if (sql1 != "")
{
sql1 += ",";
}
sql1 += "ATT_DY=0";
T_String.SetPropValue(att, "AttDy", 0);
}
break;
case "NIG_HR":
if ((Double)Data[i] > CON_H2)
{
if (NIG_MAX > 0)
{
if (ADD_H2 > 0)
{
NIG_MAX = T_String.CongTG(NIG_MAX, ADD_H2);
if ((Double)Data[i] > 0)
{
Data[i] = T_String.CongTG(ADD_H2, (Double)Data[i]);
}
}
WRK_HR = T_String.CongTG(WRK_HR, (Double)Data[i]);
int tam = (int)T_String.CongTG(T_String.IsNullTo0(Data[i] + ""), OTR_HR);
if (sql1 != "")
{
sql1 += ",";
}
sql1 += "NigDy=" + T_String.DT_HourMinConvertToHour(tam) / T_String.DT_HourMinConvertToHour((int)NIG_MAX);
T_String.SetPropValue(att, "NigDy", T_String.DT_HourMinConvertToHour(tam) / T_String.DT_HourMinConvertToHour((int)NIG_MAX));
}
else
{
if (sql1 != "")
{
sql1 += ",";
}
sql1 += "NIG_DY=0";
T_String.SetPropValue(att, "NigDy", 0);
}
}
break;
case "OTT_HR":
case "OVO_HR":
break;
}
if (sql1 != "")
{
sql1 += ",";
}
sql1 += Name[i] + "=" + Data[i];
var _name = Regex.Replace((Name[i] + "").ToLower(), @"([a-z0-9]+)_([a-z0-9]+)",
m => string.Format("{0}{1}",
Char.ToUpperInvariant(m.Groups[1].Value[0]) + m.Groups[1].Value.Substring(1),
Char.ToUpperInvariant(m.Groups[2].Value[0]) + m.Groups[2].Value.Substring(1))); /*(Name[i] + "").ToLower();*/
T_String.SetPropValue(att, _name + "", Data[i]);
}
sql = sql + sql1;
if (ABS_TM > 0)
{
double max = T_String.CongTG(ATT_MAX, NIG_MAX);
ABS_MN = T_String.TruTG(max, WRK_HR);
ABS_MN = T_String.TruTG(ABS_MN, LEA_H1);
ABS_MN = T_String.TruTG(ABS_MN, LEA_H2);
ABS_MN = T_String.TruTG(ABS_MN, LEA_H3);
ABS_MN = T_String.TruTG(ABS_MN, OTR_HR);
if (ABS_MN == 0)
{
ABS_TM = 0;
NOT_DR = NOT_DR.Replace("Absent;", "");
}
}
sql += ",NOT_DR=N'" + NOT_DR + "'";
T_String.SetPropValue(att, "NotDr", NOT_DR);
sql += ",NOT_D1=N'" + NOT_D1 + "'";
T_String.SetPropValue(att, "NotD1", NOT_D1);
sql += ",LAT_MN=N'" + LAT_MN + "'";
T_String.SetPropValue(att, "LatMn", LAT_MN);
sql += ",LAT_TM=N'" + LAT_TM + "'";
T_String.SetPropValue(att, "LatTm", LAT_TM);
sql += ",EAR_MN=N'" + EAR_MN + "'";
T_String.SetPropValue(att, "EarMn", EAR_MN);
sql += ",EAR_TM=N'" + EAR_TM + "'";
T_String.SetPropValue(att, "EarTm", EAR_TM);
sql += ",ABS_MN=N'" + ABS_MN + "'";
T_String.SetPropValue(att, "AbsMn", ABS_MN);
sql += ",ABS_TM=N'" + ABS_TM + "'";
T_String.SetPropValue(att, "AbsTm", ABS_TM);
sql += ",OTR_HR=" + OTR_HR.ToString("#0") + "";
T_String.SetPropValue(att, "OtrHr", OTR_HR.ToString("#0"));
sql += ",LEA_H1=" + LEA_H1.ToString("#0") + "";
T_String.SetPropValue(att, "LeaH1", LEA_H1.ToString("#0"));
sql += ",LEA_I1=N'" + LEA_I1 + "'";
T_String.SetPropValue(att, "LeaI1", LEA_I1);
sql += ",LEA_H2=" + LEA_H2.ToString("#0") + "";
T_String.SetPropValue(att, "LeaH2", LEA_H2.ToString("#0"));
sql += ",LEA_I2=N'" + LEA_I2 + "'";
T_String.SetPropValue(att, "LeaI2", LEA_I2);
sql += ",LEA_H3=" + LEA_H3.ToString("#0") + "";
T_String.SetPropValue(att, "LeaH3", LEA_H3.ToString("#0"));
sql += ",LEA_I3=N'" + LEA_I3 + "'";
T_String.SetPropValue(att, "LeaI3", LEA_I3);
_db.SaveChanges();
sql += " where EMP_ID=N'" + EMP_ID + "' and ATT_DT='" + ATT_DT + "'";
}