public JsonResult AddNewManageDowntime(ManageDowntimeModels _manageDowntimeModels) { dynamic result; try { result = _IManageDowntime.AddNewManageDowntime(_manageDowntimeModels); } catch (Exception ex) { Common.LogError(ex); result = -1; } return(Json(result, JsonRequestBehavior.AllowGet)); }
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); }