public APIResult UpdateClient(TblUserPermission data)
{
APIResult res = new APIResult();
using (Sonartez_server db = new Sonartez_server(connectionString))
{
var matchedObj = (from c in db.TblUserPermission
where c.ID == data.ID
select c).SingleOrDefault();
if (matchedObj == null)
{
try
{
// does not exist
Table<TblUserPermission> TblObj = db.TblUserPermission;
data.ServerUpdate = DateTime.Now;
TblObj.InsertOnSubmit(data);
TblObj.Context.SubmitChanges();
res.UpdateDate = data.ServerUpdate.Value;
res.Success = true;
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Success = false;
}
}
else
{
try
{
matchedObj.PermissionID = data.PermissionID;
matchedObj.PermissionName = data.PermissionName;
matchedObj.UserID = data.UserID;
matchedObj.ServerUpdate = DateTime.Now;
matchedObj.UpdateTime = data.UpdateTime;
db.SubmitChanges();
res.UpdateDate = data.UpdateTime.Value;
res.Success = true;
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Success = false;
}
}
}
return res;
}
partial void UpdateTblUserPermission(TblUserPermission instance);
partial void DeleteTblUserPermission(TblUserPermission instance);
partial void InsertTblUserPermission(TblUserPermission instance);
