public async Task <ActionResult> DeleteConfirmed(long id)
{
t_category t_category = await db.t_category.FindAsync(id);
db.t_category.Remove(t_category);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "categoryId,categoryDisplayPriority,categoryName")] t_category t_category)
{
if (ModelState.IsValid)
{
db.Entry(t_category).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(t_category));
}
public async Task <ActionResult> Create([Bind(Include = "categoryId,categoryDisplayPriority,categoryName")] t_category t_category)
{
if (ModelState.IsValid)
{
db.t_category.Add(t_category);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(t_category));
}
public ActionResult AddCategory(t_category addCategory)
{
if (ModelState.IsValid)
{
t_category category = new t_category();
obj.t_category.Add(addCategory);
obj.SaveChanges();
return(RedirectToAction("Category"));
}
return(View());
}
// GET: Category/Delete/5
public async Task <ActionResult> Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
t_category t_category = await db.t_category.FindAsync(id);
if (t_category == null)
{
return(HttpNotFound());
}
return(View(t_category));
}
public static ResponseResult Delete(CategoryViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_category cat = db.t_category.Where(o => o.id == entity.id).FirstOrDefault();
if (cat != null)
{
var json = new JavaScriptSerializer().Serialize(cat);
t_audit_log log = new t_audit_log();
log.type = "Modify";
log.json_before = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
cat.is_delete = true;
cat.deleted_by = entity.UserId;
cat.deleted_on = DateTime.Now;
db.SaveChanges();
var json2 = new JavaScriptSerializer().Serialize(cat);
log.json_after = json2;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Category Not Found!";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
//Post Update for Create and Edit
public static ResponseResult Update(CategoryViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
entity.code = GetNewCode();
using (var db = new XBC_Context())
{
//create
if (entity.id == 0)
{
t_category cat = new t_category();
cat.code = entity.code;
cat.name = entity.name;
cat.description = entity.description;
cat.created_by = entity.UserId;
cat.created_on = DateTime.Now;
db.t_category.Add(cat);
db.SaveChanges();
var json = new JavaScriptSerializer().Serialize(cat);
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 = cat.id;
result.Entity = entity;
}
else //edit
{
t_category cat = db.t_category.Where(o => o.id == entity.id).FirstOrDefault();
if (cat != null)
{
var json = new JavaScriptSerializer().Serialize(cat);
t_audit_log log = new t_audit_log();
log.type = "Modify";
log.json_before = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
cat.name = entity.name;
cat.description = entity.description;
cat.modified_by = entity.UserId;
cat.modified_on = DateTime.Now;
var json2 = new JavaScriptSerializer().Serialize(cat);
log.json_after = json2;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Category Not Found";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
