public virtual ActionResult SoftwareChangeList(DataSourceRequest command, ChangeSoftwareListModel model)
{
HttpSessionStateBase session = HttpContext.Session;
Tbl_User user = _userService.GetUserById(Convert.ToInt32(session["UserID"]));
if (model.Amount == 0 && string.IsNullOrEmpty(model.CustomerConnector) && model.Customer_ID == 0 && string.IsNullOrEmpty(model.RequestDate) && string.IsNullOrEmpty(model.DeliveryDate) && string.IsNullOrEmpty(model.Description) && string.IsNullOrEmpty(model.RequiredChanges))
{
var SoftwareItems = _softwareService.GetAllSoftwareChange();
var gridModel = new DataSourceResult
{
Data = SoftwareItems.Select(x => new ChangeSoftwareModel
{
Amount = x.Amount,
CustomerName = _customerService.GetCustomerById(x.Customer_ID).CustomerName,
CustomerConnector = x.CustomerConnector,
RequestDate = x.RequestDate,
Description = x.Description,
DeliveryDate = x.DeliveryDate,
Customer_ID = x.Customer_ID,
RowColor = user.Section_ID == 1 && string.IsNullOrEmpty(x.DeliveryDate) ? 1 : user.Section_ID == 3 && !string.IsNullOrEmpty(x.DeliveryDate) && x.Amount == 0 ? 1 : 0,
Request_ID = x.Request_ID,
RequiredChanges = x.RequiredChanges
}),
Total = SoftwareItems.Count()
};
return(Json(gridModel));
}
else
{
var SoftwareItems = _softwareService.SearchSoftwareChange(model.Amount, model.CustomerConnector, model.Customer_ID, model.RequestDate, model.DeliveryDate, model.Description, model.RequiredChanges);
var gridModel = new DataSourceResult
{
Data = SoftwareItems.Select(x => new ChangeSoftwareModel
{
Amount = x.Amount,
CustomerName = _customerService.GetCustomerById(x.Customer_ID).CustomerName,
CustomerConnector = x.CustomerConnector,
RequestDate = x.RequestDate,
Description = x.Description,
DeliveryDate = x.DeliveryDate,
Customer_ID = x.Customer_ID,
RowColor = user.Section_ID == 1 && string.IsNullOrEmpty(x.DeliveryDate) ? 1 : user.Section_ID == 3 && !string.IsNullOrEmpty(x.DeliveryDate) && x.Amount == 0 ? 1 : 0,
Request_ID = x.Request_ID,
RequiredChanges = x.RequiredChanges
}),
Total = SoftwareItems.Count()
};
return(Json(gridModel));
}
}
public ActionResult SubmitSoftwareChange(DataSourceRequest command, ChangeSoftwareListModel model)
{
HttpSessionStateBase session = HttpContext.Session;
try
{
if (false) // field validation
{
var gridModel = new DataSourceResult
{
ExtraData = new SoftwareListModel
{
Message = Message.InvalidCharacter,
},
Total = 1
};
return(Json(gridModel));
}
Tbl_ChangeSoftware tu = new Tbl_ChangeSoftware();
tu.Request_ID = model.Request_ID;
tu.CustomerConnector = model.CustomerConnector;
tu.Customer_ID = model.Customer_ID;
tu.Description = model.Description;
tu.RequestDate = model.RequestDate;
tu.RequiredChanges = model.RequiredChanges;
tu.DeliveryDate = model.DeliveryDate;
tu.Description = model.Description;
tu.Amount = model.Amount;
tu.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]);
tu.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
tu.LastUpdateTime = DateTime.Now.ToString("HH:mm");
if (_softwareService.AddNewSoftwareChange(tu))
{
var gridModel = new DataSourceResult
{
ExtraData = new ChangeSoftwareListModel
{
Message = Message.OperationSuccessful,
MessageColor = "green",
},
Total = 1
};
return(Json(gridModel));
}
else
{
var gridModel = new DataSourceResult
{
ExtraData = new ChangeSoftwareListModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red",
},
Total = 1
};
return(Json(gridModel));
}
}
catch (Exception ex)
{
var gridModel = new DataSourceResult
{
ExtraData = new ChangeSoftwareListModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red",
},
Total = 1
};
return(Json(gridModel));
}
//return "";
}
