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); }