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