public ActionResult LogBundyWeb(String time_period, String EIC, String schemeCode)
{
var logNow = DateTime.Now;
var logDate = logNow.Date;
var logTime = logNow.TimeOfDay;
// check for existing record entry
var rec = db.tAttDailyLogs.Where(r => r.EIC == EIC).SingleOrDefault(r => r.LogDate == logDate);
if (rec == null)
{
// create an entry if no existing record
var n = new tAttDailyLog
{
EIC = EIC,
LogDate = logDate,
SchemeCode = schemeCode,
nonRegDay = 0
};
db.tAttDailyLogs.Add(n);
db.SaveChanges();
}
// update the record
var l = db.tAttDailyLogs.Where(r => r.EIC == EIC).Single(r => r.LogDate == logDate);
if (time_period.Equals("IN1"))
{
l.In1 = logNow;
l.LastLog = time_period;
}
else if (time_period.Equals("OUT1"))
{
l.Out1 = logNow;
l.LastLog = time_period;
}
else if (time_period.Equals("IN2"))
{
l.In2 = logNow;
l.LastLog = time_period;
}
else if (time_period.Equals("OUT2"))
{
l.Out2 = logNow;
l.LastLog = time_period;
}
// save all changes
db.SaveChanges();
//BundyTransaction(EIC, time_period);
var log = db.tAttDailyLogs.Where(r => r.EIC == EIC).SingleOrDefault(r => r.LogDate == logDate);
ViewBag.log = log;
ViewBag.EIC = EIC;
return(Content("1"));
}
public JsonResult LogBundy(String time_period, String EIC, String schemeCode)
{
var logNow = DateTime.Now;
var logDate = logNow.Date;
var logTime = logNow.TimeOfDay;
// check for existing record entry
var rec = db.tAttDailyLogs.Where(r => r.EIC == EIC).SingleOrDefault(r => r.LogDate == logDate);
if (rec == null)
{
// create an entry if no existing record
var n = new tAttDailyLog
{
EIC = EIC,
LogDate = logDate,
SchemeCode = schemeCode
};
db.tAttDailyLogs.Add(n);
db.SaveChanges();
}
// update the record
var l = db.tAttDailyLogs.Where(r => r.EIC == EIC).Single(r => r.LogDate == logDate);
if (time_period.Equals("IN1"))
{
l.In1 = logNow;
l.LastLog = time_period;
}
else if (time_period.Equals("OUT1"))
{
l.Out1 = logNow;
l.LastLog = time_period;
}
else if (time_period.Equals("IN2"))
{
l.In2 = logNow;
l.LastLog = time_period;
}
else if (time_period.Equals("OUT2"))
{
l.Out2 = logNow;
l.LastLog = time_period;
}
// save all changes
db.SaveChanges();
// log bundy transaction
BundyTransaction(EIC, time_period);
var log = db.tAttDailyLogs.Where(r => r.EIC == EIC).Where(r => r.LogDate == logDate);
return(Json(new { log }, JsonRequestBehavior.AllowGet));
}
