public int AddNewManageAsset(ManageAssetsModels _manageAssetsModels) { int result = 0; if (_manageAssetsModels.Assets_Id > 0) { using (opsdbEntities _dbContext = new opsdbEntities()) { var q = _dbContext.OPS_ManageAssets.FirstOrDefault(x => x.AssetType == _manageAssetsModels.AssetType); if (q == null) { var query = _dbContext.OPS_ManageAssets.Find(_manageAssetsModels.Assets_Id); if (query != null) { query.AssetType = _manageAssetsModels.AssetType; query.ModifiedBy = HttpContext.Current.User.Identity.Name; query.ModifiedDate = DateTime.Now; _dbContext.SaveChanges(); result = 1; } } else { result = -2; } } } else { using (opsdbEntities _dbContext = new opsdbEntities()) { var q = _dbContext.OPS_ManageAssets.FirstOrDefault(x => x.AssetType == _manageAssetsModels.AssetType); if (q == null) { OPS_ManageAssets _obj = new OPS_ManageAssets(); _obj.AssetType = _manageAssetsModels.AssetType; _obj.CreatedBy = HttpContext.Current.User.Identity.Name; _obj.CreatedDate = DateTime.Now; _dbContext.OPS_ManageAssets.Add(_obj); _dbContext.SaveChanges(); result = 1; } else { result = -2; } } } return(result); }
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 int DeleteManageDowntime(int id) { int result = 0; using (opsdbEntities _dbContext = new opsdbEntities()) { var query = _dbContext.OPS_ManageDowntime.Find(id); if (query != null) { query.IsDeleted = true; query.ModifiedBy = HttpContext.Current.User.Identity.Name; query.ModifiedDate = DateTime.Now; _dbContext.SaveChanges(); result = 1; } } return(result); }
public int DeleteManageAssets(int id, string name) { int result = 0; using (opsdbEntities _dbContext = new opsdbEntities()) { var q = _dbContext.OPS_ManageDowntime.FirstOrDefault(x => x.Assets_Id == id); if (q == null) { var query = _dbContext.OPS_ManageAssets.Find(id); if (query != null) { query.IsDeleted = true; query.ModifiedBy = HttpContext.Current.User.Identity.Name; query.ModifiedDate = DateTime.Now; _dbContext.SaveChanges(); result = 1; } } } return(result); }
public int AddNewManageDowntime(ManageDowntimeModels _manageDowntimeModels) { int result = 0; var ToDate = !string.IsNullOrWhiteSpace(_manageDowntimeModels.To) ? Convert.ToDateTime(DateTime.ParseExact(_manageDowntimeModels.To, "dd/MM/yyyy hh:mm tt", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy hh:mm tt", CultureInfo.InvariantCulture)) : DateTime.Now; var FromDate = !string.IsNullOrWhiteSpace(_manageDowntimeModels.From) ? Convert.ToDateTime(DateTime.ParseExact(_manageDowntimeModels.From, "dd/MM/yyyy hh:mm tt", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy hh:mm tt", CultureInfo.InvariantCulture)) : DateTime.Now; var assetss = GetAssetType(Convert.ToInt32(_manageDowntimeModels.Assets)); if (_manageDowntimeModels.ManageDowntime_Id > 0) { using (opsdbEntities _dbContext = new opsdbEntities()) { var query = _dbContext.OPS_ManageDowntime.Find(_manageDowntimeModels.ManageDowntime_Id); if (query != null) { //TimeSpan duration = DateTime.Parse(_manageDowntimeModels.To).Subtract(DateTime.Parse(_manageDowntimeModels.From)); TimeSpan duration = ToDate.Subtract(FromDate); query.Assets = assetss; query.Assets_Id = Convert.ToInt32(_manageDowntimeModels.Assets); query.Status = _manageDowntimeModels.Status; query.From = _manageDowntimeModels.From; query.To = _manageDowntimeModels.To; query.Reason = _manageDowntimeModels.Reason; query.Time_Diff = Convert.ToInt32(duration.TotalSeconds); query.ModifiedBy = HttpContext.Current.User.Identity.Name; query.ModifiedDate = DateTime.Now; query.FromDate = FromDate; query.ToDate = ToDate; _dbContext.SaveChanges(); result = 1; } } } else { using (opsdbEntities _dbContext = new opsdbEntities()) { OPS_ManageDowntime _obj = new OPS_ManageDowntime(); TimeSpan duration = ToDate.Subtract(FromDate); //TimeSpan duration = DateTime.Parse(_manageDowntimeModels.To).Subtract(DateTime.Parse(_manageDowntimeModels.From)); //var ts = TimeSpan.FromSeconds(duration.TotalSeconds); //string dtf = string.Format("{0:D2} : {1:D2}",ts.Hours, ts.Minutes); _obj.Assets = assetss; _obj.Assets_Id = Convert.ToInt32(_manageDowntimeModels.Assets); _obj.Status = _manageDowntimeModels.Status; _obj.From = _manageDowntimeModels.From; _obj.To = _manageDowntimeModels.To; _obj.Reason = _manageDowntimeModels.Reason; _obj.Time_Diff = Convert.ToInt32(duration.TotalSeconds); _obj.CreatedBy = HttpContext.Current.User.Identity.Name; _obj.CreatedDate = DateTime.Now; _obj.FromDate = FromDate; _obj.ToDate = ToDate; _dbContext.OPS_ManageDowntime.Add(_obj); _dbContext.SaveChanges(); result = 1; } } return(result); }
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); }