public static ResponResultViewModel Update(MenuAccessViewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
if (entity.id == 0)
{
t_menu_access ma = new t_menu_access();
ma.menu_id = entity.menu_id;
ma.role_id = entity.role_id;
ma.created_by = 1;
ma.created_on = DateTime.Now;
db.t_menu_access.Add(ma);
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponseResult Create(MenuAccessViewModel entity)
{
ResponseResult result = new ResponseResult();
using (var db = new XBC_Context())
{
t_menu_access ma = new t_menu_access();
ma.role_id = entity.role_id;
ma.menu_id = entity.menu_id;
ma.created_by = entity.UserId;
ma.created_on = DateTime.Now;
db.t_menu_access.Add(ma);
db.SaveChanges();
var json = new JavaScriptSerializer().Serialize(ma);
t_audit_log log = new t_audit_log();
log.type = "Insert";
log.json_insert = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
entity.id = ma.id;
result.Entity = entity;
}
return(result);
}
public static ResponResultViewModel Delete(long id)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_menu_access ma = db.t_menu_access.Where(o => o.id == id).FirstOrDefault();
if (ma == null)
{
result.Success = false;
result.Message = "Menu Access Not Found";
}
else
{
result.Entity = ma;
db.t_menu_access.Remove(ma);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponseResult Delete(MenuAccessViewModel entity)
{
ResponseResult result = new ResponseResult();
using (var db = new XBC_Context())
{
t_menu_access ma = db.t_menu_access.Where(o => o.id == entity.id).FirstOrDefault();
db.t_menu_access.Remove(ma);
if (ma != null)
{
object data = new
{
ma.id,
ma.menu_id,
ma.role_id
};
var json = new JavaScriptSerializer().Serialize(data);
t_audit_log log = new t_audit_log();
log.type = "DELETE";
log.json_before = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
var json2 = new JavaScriptSerializer().Serialize(ma);
log.json_after = json2;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = " not found! ";
}
}
return(result);
}