public ActionResult InsertRequestType(RequestTypeListModel model)
{
HttpSessionStateBase session = HttpContext.Session;
try
{
// update process
Tbl_RequestType tg = new Tbl_RequestType();
tg.Description = model.Description;
tg.RequestTypeName = model.RequestTypeName;
tg.RequestType_ID = model.RequestType_ID;
tg.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]);
tg.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
tg.LastUpdateTime = DateTime.Now.ToString("HH:mm");
if (_supportService.AddNewRequestType(tg))
{
var gridModel = new DataSourceResult
{
ExtraData = new RequestTypeListModel
{
Message = Message.OperationSuccessful,
MessageColor = "green",
},
Total = 1
};
return(Json(gridModel));
}
else
{
var gridModel = new DataSourceResult
{
ExtraData = new RequestTypeListModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red",
},
Total = 1
};
return(Json(gridModel));
}
}
catch (Exception ex)
{
var gridModel = new DataSourceResult
{
ExtraData = new RequestTypeListModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red",
},
Total = 1
};
return(Json(gridModel));
}
}
public bool AddNewRequestType(Tbl_RequestType reqtyp)
{
try
{
//check if user already exists
var res = from t in _context.Tbl_RequestType
where t.RequestType_ID == reqtyp.RequestType_ID
select t;
if (res.Count() == 0)
{
_context.Tbl_RequestType.Add(reqtyp);
}
else
{
Tbl_RequestType prod = _context.Tbl_RequestType.First(x => x.RequestType_ID == reqtyp.RequestType_ID);
prod.RequestTypeName = reqtyp.RequestTypeName;
prod.Description = reqtyp.Description;
prod.LastUpdateUser_ID = reqtyp.LastUpdateUser_ID;
prod.LastUpdateDate = reqtyp.LastUpdateDate;
prod.LastUpdateTime = reqtyp.LastUpdateTime;
}
if (_context.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
