public JsonResult EditManageDataEntry(OPS_DataEntry _obj)
{
dynamic result;
try
{
result = _IManageDataEntry.EditManageDataEntry(_obj);
}
catch (Exception ex)
{
Common.LogError(ex);
result = -1;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public int AddNewDataEntry()
{
string[] shiftEndTime = ConfigurationManager.AppSettings["shiftEndTime"].Split(':');
var shiftStartTime = checkShiftTime();
var times = new List <string>();
DateTime today = DateTime.Today.AddHours(shiftStartTime);
DateTime tomorrow = today.AddHours(Convert.ToInt32(shiftEndTime[0])).AddMinutes(Convert.ToInt32(shiftEndTime[1])).AddSeconds(Convert.ToInt32(shiftEndTime[2]));
for (var i = today; i < tomorrow; i = i.AddHours(1))
{
times.Add(i.ToString("hh:mm tt"));
//times.Add(i.ToString("HH:mm:ss"));
}
//TimeSpan start = new TimeSpan(today.Hour, today.Minute, today.Second);
//TimeSpan end = new TimeSpan(tomorrow.Hour, tomorrow.Minute, tomorrow.Second);
//TimeSpan now = DateTime.Now.TimeOfDay;
//if ((now > start) && (now < end))
//{
// //match found
//}
if (times.Count > 0)
{
using (opsdbEntities _dbContext = new opsdbEntities())
{
foreach (var item in times)
{
Guid id = Guid.NewGuid();
OPS_DataEntry _obj = new OPS_DataEntry();
_obj.ShiftTime = item;
_obj.CreatedBy = HttpContext.Current.User.Identity.Name;
_obj.CreatedDate = DateTime.Now;
_obj.ManageShifts_Id = GetManageShifts(shiftStartTime).ManageShifts_Id;
_obj.Unique_ID = id.ToString();
_dbContext.OPS_DataEntry.Add(_obj);
}
_dbContext.SaveChanges();
}
}
return(1);
}
public JsonResult ExcelSearchTotal(ReportDataEntryModels _reportDataEntryModels)
{
var data = _IManageDataEntry.GetDataEntryReport(_reportDataEntryModels);
if (data.Count() > 0)
{
OPS_DataEntry _objTotal = new OPS_DataEntry();
_objTotal.CV01 = data.Sum(x => Convert.ToDecimal(x.CV01)).ToString();
_objTotal.Rougher = data.Sum(x => Convert.ToDecimal(x.Rougher)).ToString();
_objTotal.HMC = data.Sum(x => Convert.ToDecimal(x.HMC)).ToString();
_objTotal.FlocUse = data.Sum(x => Convert.ToDecimal(x.FlocUse)).ToString();
_objTotal.FlocBatch = string.Empty;
_objTotal.Slime = data.Sum(x => Convert.ToDecimal(x.Slime)).ToString();
_objTotal.SlimePer = data.Sum(x => Convert.ToDecimal(x.SlimePer)).ToString();
_objTotal.Tails1 = data.Sum(x => Convert.ToDecimal(x.Tails1)).ToString();
_objTotal.Tails2 = data.Sum(x => Convert.ToDecimal(x.Tails2)).ToString();
return(Json(_objTotal, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public int EditManageDataEntry(OPS_DataEntry _obj)
{
int result = 0;
using (opsdbEntities _dbContext = new opsdbEntities())
{
var query = _dbContext.OPS_DataEntry.FirstOrDefault(x => x.Unique_ID == _obj.Unique_ID);
if (_obj.IsDeleted == true)
{
var q = _dbContext.OPS_DeletedDataEntry.FirstOrDefault(x => x.Unique_ID == _obj.Unique_ID);
if (q != null)
{
_dbContext.OPS_DeletedDataEntry.Remove(q);
_dbContext.SaveChanges();
}
OPS_DeletedDataEntry obj = new OPS_DeletedDataEntry();
obj.DataEntry_Id = query.DataEntry_Id;
obj.CV01 = query.CV01;
obj.Rougher = query.Rougher;
obj.HMC = query.HMC;
obj.FlocUse = query.FlocUse;
obj.FlocBatch = query.FlocBatch;
obj.Slime = query.Slime;
obj.SlimePer = query.SlimePer;
obj.Tails1 = query.Tails1;
obj.Tails2 = query.Tails2;
obj.Reason = query.Reason;
obj.IsDeleted = _obj.IsDeleted;
obj.CreatedBy = query.CreatedBy;
obj.CreatedDate = query.CreatedDate;
obj.ModifiedBy = HttpContext.Current.User.Identity.Name;
obj.ModifiedDate = DateTime.Now;
obj.ManageShifts_Id = query.ManageShifts_Id;
obj.AD_Id = query.AD_Id;
obj.Unique_ID = _obj.Unique_ID;
obj.ShiftTime = query.ShiftTime;
_dbContext.OPS_DeletedDataEntry.Add(obj);
_dbContext.SaveChanges();
}
if (query != null)
{
query.CV01 = _obj.CV01;
query.Rougher = _obj.Rougher;
query.HMC = _obj.HMC;
query.FlocUse = _obj.FlocUse;
query.FlocBatch = _obj.FlocBatch;
query.Slime = _obj.Slime;
query.SlimePer = _obj.SlimePer;
query.Tails1 = _obj.Tails1;
query.Tails2 = _obj.Tails2;
query.Reason = _obj.Reason;
query.IsDeleted = _obj.IsDeleted;
query.ModifiedBy = HttpContext.Current.User.Identity.Name;
query.ModifiedDate = DateTime.Now;
result = 1;
_dbContext.SaveChanges();
}
}
return(result);
}
