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