public List <OPS_ManageAssets> GetManageAssets() { using (opsdbEntities _dbContext = new opsdbEntities()) { return(_dbContext.OPS_ManageAssets.Where(x => x.IsDeleted == false || x.IsDeleted == null).ToList()); } }
public List <OPS_ManageDowntime> GetAllManageDowntime() { using (opsdbEntities _dbContext = new opsdbEntities()) { return(_dbContext.OPS_ManageDowntime.Where(x => x.IsDeleted == false || x.IsDeleted == null).OrderByDescending(x => x.CreatedDate).ToList()); } }
public string GetAssetType(int id) { using (opsdbEntities _dbContext = new opsdbEntities()) { var q = _dbContext.OPS_ManageAssets.FirstOrDefault(x => x.Assets_Id == id); return(q.AssetType != null ? q.AssetType : string.Empty); } }
public OPS_ManageShifts GetManageShifts(int shiftStartTime) { using (opsdbEntities _dbContext = new opsdbEntities()) { var query = _dbContext.OPS_ManageShifts.Where(x => x.Start_Time == shiftStartTime).FirstOrDefault(); return(query); } }
public bool ValidateDataEntry() { int id = GetManageShifts(checkShiftTime()).ManageShifts_Id; using (opsdbEntities _dbContext = new opsdbEntities()) { return(_dbContext.OPS_DataEntry.Where(x => x.CreatedDate.Value.Day == DateTime.Now.Day && x.CreatedBy == HttpContext.Current.User.Identity.Name && x.ManageShifts_Id == id).Any()); } }
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 List <OPS_DataEntry> SearchDataEntry(int id, string searchDate) { //int id = GetManageShifts(checkShiftTime()).ManageShifts_Id; var selectedDate = Convert.ToDateTime(DateTime.ParseExact(searchDate, "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)); using (opsdbEntities _dbContext = new opsdbEntities()) { return(_dbContext.OPS_DataEntry.Where(x => (x.CreatedDate.Value.Day == selectedDate.Day && x.CreatedDate.Value.Month == selectedDate.Month && x.CreatedDate.Value.Year == selectedDate.Year) && x.CreatedBy == HttpContext.Current.User.Identity.Name && x.ManageShifts_Id == id).ToList()); } }
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 List <OPS_ManageDowntime> GetManageDowntime_ExcelSearch(int Assets_id, string selectedDate) { var filteredDate = !string.IsNullOrWhiteSpace(selectedDate) ? Convert.ToDateTime(DateTime.ParseExact(selectedDate, "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)) : DateTime.Now; //string[] filteredDate = selectedDate.Split('/'); //int _day = Convert.ToInt32(filteredDate[0]); //int _month = Convert.ToInt32(filteredDate[1]); //int _Year = Convert.ToInt32(filteredDate[2]); using (opsdbEntities _dbContext = new opsdbEntities()) { return(_dbContext.OPS_ManageDowntime.Where(x => x.Assets_Id == Assets_id && (x.FromDate.Value.Day == filteredDate.Day && x.FromDate.Value.Month == filteredDate.Month && x.FromDate.Value.Year == filteredDate.Year) && (x.IsDeleted == false || x.IsDeleted == null)).OrderByDescending(x => x.CreatedDate).ToList()); } }
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 List <OPS_ManageDowntime> GetReporting_ManageDowntime(ReportDataEntryModels _reportDataEntryModels) { DateTime now = DateTime.Now; var lastHour = now.AddHours(-24); var lastWeek = now.AddDays(-7); var lastMonth = now.AddMonths(-1); var startDate = !string.IsNullOrWhiteSpace(_reportDataEntryModels.From) ? Convert.ToDateTime(DateTime.ParseExact(_reportDataEntryModels.From, "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)) : DateTime.Now; var endDate = !string.IsNullOrWhiteSpace(_reportDataEntryModels.To) ? Convert.ToDateTime(DateTime.ParseExact(_reportDataEntryModels.To, "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)) : DateTime.Now; using (opsdbEntities _dbContext = new opsdbEntities()) { dynamic result; int MH = Convert.ToInt32(ConfigurationManager.AppSettings["MorningShift"]); int EH = Convert.ToInt32(ConfigurationManager.AppSettings["EveningShift"]); if (_reportDataEntryModels.Hours == "on") { if (_reportDataEntryModels.SelectedShifts == "1") { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastHour && x.FromDate <= now) && (x.FromDate.Value.Hour < EH && x.FromDate.Value.Hour >= MH)).ToList(); } else if (_reportDataEntryModels.SelectedShifts == "2") { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastHour && x.FromDate <= now) && (x.FromDate.Value.Hour >= EH && x.FromDate.Value.Hour < MH)).ToList(); } else { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastHour && x.FromDate <= now)).ToList(); } } else if (_reportDataEntryModels.Weeks == "on") { if (_reportDataEntryModels.SelectedShifts == "1") { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastWeek && x.FromDate <= now) && (x.FromDate.Value.Hour < EH && x.FromDate.Value.Hour >= MH)).ToList(); } else if (_reportDataEntryModels.SelectedShifts == "2") { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastWeek && x.FromDate <= now) && (x.FromDate.Value.Hour >= EH && x.FromDate.Value.Hour < MH)).ToList(); } else { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastWeek && x.FromDate <= now)).ToList(); } } else if (_reportDataEntryModels.Monthly == "on") { if (_reportDataEntryModels.SelectedShifts == "1") { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastMonth && x.FromDate <= now) && (x.FromDate.Value.Hour < EH && x.FromDate.Value.Hour >= MH)).ToList(); } else if (_reportDataEntryModels.SelectedShifts == "2") { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastMonth && x.FromDate <= now) && (x.FromDate.Value.Hour >= EH && x.FromDate.Value.Hour < MH)).ToList(); } else { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate > lastMonth && x.FromDate <= now)).ToList(); } } else if (!string.IsNullOrEmpty(_reportDataEntryModels.From) && !string.IsNullOrEmpty(_reportDataEntryModels.To)) { if (_reportDataEntryModels.SelectedShifts == "1") { result = _dbContext.OPS_ManageDowntime.Where(x => ((x.FromDate.Value.Day >= startDate.Day && x.FromDate.Value.Month >= startDate.Month && x.FromDate.Value.Year >= startDate.Year) && (x.FromDate.Value.Hour < EH && x.FromDate.Value.Hour >= MH)) && ((x.ToDate.Value.Day <= endDate.Day && x.ToDate.Value.Month <= endDate.Month && x.ToDate.Value.Year <= endDate.Year) && (x.ToDate.Value.Hour < EH && x.ToDate.Value.Hour >= MH))).ToList(); } else if (_reportDataEntryModels.SelectedShifts == "2") { result = _dbContext.OPS_ManageDowntime.Where(x => ((x.FromDate.Value.Day >= startDate.Day && x.FromDate.Value.Month >= startDate.Month && x.FromDate.Value.Year >= startDate.Year) && (x.FromDate.Value.Hour >= EH && x.FromDate.Value.Hour < MH)) && ((x.ToDate.Value.Day <= endDate.Day && x.ToDate.Value.Month <= endDate.Month && x.ToDate.Value.Year <= endDate.Year) && (x.ToDate.Value.Hour >= EH && x.ToDate.Value.Hour < MH))).ToList(); } else { result = _dbContext.OPS_ManageDowntime.Where(x => (x.FromDate.Value.Day >= startDate.Day && x.FromDate.Value.Month >= startDate.Month && x.FromDate.Value.Year >= startDate.Year) && (x.ToDate.Value.Day <= endDate.Day && x.ToDate.Value.Month <= endDate.Month && x.ToDate.Value.Year <= endDate.Year)).ToList(); } } else { result = null; } 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); }
public List <OPS_DataEntry> GetDataEntryReport(ReportDataEntryModels _reportDataEntryModels) { DateTime now = DateTime.Now; var lastHour = now.AddHours(-24); var lastWeek = now.AddDays(-7); var lastMonth = now.AddMonths(-1); var startDate = !string.IsNullOrWhiteSpace(_reportDataEntryModels.From) ? Convert.ToDateTime(DateTime.ParseExact(_reportDataEntryModels.From, "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)) : DateTime.Now; //var startDate = Convert.ToDateTime(_reportDataEntryModels.From); var endDate = !string.IsNullOrWhiteSpace(_reportDataEntryModels.To) ? Convert.ToDateTime(DateTime.ParseExact(_reportDataEntryModels.To, "dd/MM/yyyy", CultureInfo.InvariantCulture) .ToString("MM/dd/yyyy", CultureInfo.InvariantCulture)) : DateTime.Now; //var endDate =Convert.ToDateTime(_reportDataEntryModels.To); dynamic result; using (opsdbEntities _dbContext = new opsdbEntities()) { if (_reportDataEntryModels.SelectedShifts != "0") { int id = Convert.ToInt32(_reportDataEntryModels.SelectedShifts); if (_reportDataEntryModels.SelectedShifts != "0" && _reportDataEntryModels.Hours == "on") { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate > lastHour && x.CreatedDate <= now) && x.ManageShifts_Id == id).ToList(); } else if (_reportDataEntryModels.SelectedShifts != "0" && _reportDataEntryModels.Weeks == "on") { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate > lastWeek && x.CreatedDate <= now) && x.ManageShifts_Id == id).ToList(); } else if (_reportDataEntryModels.SelectedShifts != "0" && _reportDataEntryModels.Monthly == "on") { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate > lastMonth && x.CreatedDate <= now) && x.ManageShifts_Id == id).ToList(); } else if (_reportDataEntryModels.SelectedShifts != "0" && _reportDataEntryModels.From != null && _reportDataEntryModels.To != null) { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate.Value.Day >= startDate.Day && x.CreatedDate.Value.Month >= startDate.Month && x.CreatedDate.Value.Year >= startDate.Year) && (x.CreatedDate.Value.Day <= endDate.Day && x.CreatedDate.Value.Month <= endDate.Month && x.CreatedDate.Value.Year <= endDate.Year) && x.ManageShifts_Id == id).ToList(); // result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate > startDate && x.CreatedDate <= endDate) && x.IsDeleted != true && x.ManageShifts_Id == id).ToList(); } else { result = _dbContext.OPS_DataEntry.Where(x => x.ManageShifts_Id == id).ToList(); } } else if (_reportDataEntryModels.Hours == "on") { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate > lastHour && x.CreatedDate <= now)).ToList(); } else if (_reportDataEntryModels.Weeks == "on") { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate > lastWeek && x.CreatedDate <= now)).ToList(); } else if (_reportDataEntryModels.Monthly == "on") { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate > lastMonth && x.CreatedDate <= now)).ToList(); } else if (_reportDataEntryModels.From != null && _reportDataEntryModels.To != null) { result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate.Value.Day >= startDate.Day && x.CreatedDate.Value.Month >= startDate.Month && x.CreatedDate.Value.Year >= startDate.Year) && (x.CreatedDate.Value.Day <= endDate.Day && x.CreatedDate.Value.Month <= endDate.Month && x.CreatedDate.Value.Year <= endDate.Year)).ToList(); //result = _dbContext.OPS_DataEntry.Where(x => (x.CreatedDate >= startDate && x.CreatedDate <= endDate) && x.IsDeleted != true).ToList(); } else { result = null; } return(result); } }