public ActionResult SubmitOtherRequest(OtherRequestListModel model)
{
HttpSessionStateBase session = HttpContext.Session;
try
{
Tbl_OtherRequest tu = new Tbl_OtherRequest();
tu.Description = model.Description;
tu.Customer_ID = model.Customer_ID;
tu.CustomerConnector = model.CustomerConnector;
tu.Request_ID = model.Request_ID;
tu.RequestType_ID = model.RequestType_ID;
tu.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]);
tu.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
tu.LastUpdateTime = DateTime.Now.ToString("HH:mm");
if (_supportService.AddNewOtherRequest(tu))
{
var gridModel = new DataSourceResult
{
ExtraData = new OtherRequestModel
{
Message = Message.OperationSuccessful,
MessageColor = "green"
},
Total = 1
};
return(Json(gridModel));
}
else
{
var gridModel = new DataSourceResult
{
ExtraData = new OtherRequestModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red"
},
Total = 1
};
return(Json(gridModel));
}
}
catch (Exception ex)
{
var gridModel = new DataSourceResult
{
ExtraData = new OtherRequestModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red"
},
Total = 1
};
return(Json(gridModel));
}
//return "";
}
public ActionResult Other_Req()
{
var model = new OtherRequestListModel();
//model.Active = _comm.GetActiveList();
//model.Fields = GetFields();
model.RequestType = GetOtherRequestsDropDown();
HttpSessionStateBase session = HttpContext.Session;
return(View(model));
}
public virtual ActionResult OtherRequestList(DataSourceRequest command, OtherRequestListModel model)
{
if (model.Customer_ID == 0 && string.IsNullOrEmpty(model.CustomerConnector) && model.RequestType_ID == 0 && string.IsNullOrEmpty(model.Description))
{
var Items = _supportService.GetAllOtherRequest();
var gridModel = new DataSourceResult
{
Data = Items.Select(x => new OtherRequestModel
{
CustomerConnector = x.CustomerConnector,
Description = x.Description,
CustomerName = _customerService.GetCustomerById(x.Customer_ID).CustomerName,
Customer_ID = x.Customer_ID,
RequestType = _supportService.GetRequestTypeById(x.RequestType_ID).RequestTypeName,
Request_ID = x.Request_ID,
RequestType_ID = x.RequestType_ID
}),
Total = Items.Count()
};
return(Json(gridModel));
}
else
{
//var UserItems = _groupService.SearchCustomer(model.GroupName, model.Description);
var UserItems = _supportService.SearchOtherRequest(model.Customer_ID, model.CustomerConnector, model.RequestType_ID, model.Description);
var gridModel = new DataSourceResult
{
Data = UserItems.Select(x => new OtherRequestModel
{
CustomerConnector = x.CustomerConnector,
Description = x.Description,
CustomerName = _customerService.GetCustomerById(x.Customer_ID).CustomerName,
Customer_ID = x.Customer_ID,
RequestType = _supportService.GetRequestTypeById(x.RequestType_ID).RequestTypeName,
Request_ID = x.Request_ID,
RequestType_ID = x.RequestType_ID
}),
Total = UserItems.Count()
};
return(Json(gridModel));
}
}
