public Regency Add(Regency regency)
{
_context.RegencyItems.Add(regency);
_context.SaveChanges();
return(regency);
}
public Regency Update(Regency regencyChanges)
{
_context.Entry(regencyChanges).State = EntityState.Modified;
_context.SaveChanges();
return(regencyChanges);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Regency regency = await db.Regencies.FindAsync(id);
db.Regencies.Remove(regency);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public bool Insert(RegencyVM regencyVM)
{
var push = new Regency(regencyVM);
//ini nih foreign key
var getProvince = applicationContext.Provinces.SingleOrDefault(x => x.IsDelete == false && x.Id == regencyVM.ProvinceId);
push.Province = getProvince;
applicationContext.Regencies.Add(push);
var result = applicationContext.SaveChanges();
return(result > 0);
}
public Regency Delete(int id)
{
Regency regency = _context.RegencyItems.Find(id);
if (regency != null)
{
_context.RegencyItems.Remove(regency);
_context.SaveChanges();
}
return(regency);
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,ProvinceId,CreateDate,UpdateDate,DeleteDate,IsDelete")] Regency regency)
{
if (ModelState.IsValid)
{
db.Entry(regency).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.ProvinceId = new SelectList(db.Provinces, "Id", "Name", regency.ProvinceId);
return(View(regency));
}
public async Task <IActionResult> CreateRegency(RegencyNewModel model)
{
if (ModelState.IsValid)
{
var regency = new Regency {
Name = model.Name,
Description = model.Description
};
await _regencyService.Add(regency);
}
return(RedirectToActionPermanent(nameof(Index)));
}
public RegencyParam(Regency regency)
{
this.Id = regency.Id;
this.Name = regency.Name;
this.Districts = regency.Districts;
this.CreateDate = regency.CreateDate;
this.UpdateDate = regency.UpdateDate;
this.DeleteDate = regency.DeleteDate;
this.IsDelete = regency.IsDelete;
this.CreateBy = ""; //isi
this.UpdateBy = ""; //isi
this.DeleteBy = ""; //isi
}
public async Task <ActionResult> Create([Bind(Include = "Id,Province_Id,Name")] Regency regency)
{
if (ModelState.IsValid)
{
db.Regencies.Add(regency);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.Province_Id = new SelectList(db.Provinces, "Id", "Name", regency.Provinces_Id);
return(View(regency));
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Regency regency = await db.Regencies.FindAsync(id);
if (regency == null)
{
return(HttpNotFound());
}
return(View(regency));
}
public bool Delete(int?Id)
{
var result = 0;
Regency regency = Get(Id);
regency.IsDelete = true;
regency.DeleteDate = DateTimeOffset.Now.ToLocalTime();
result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
return(status);
}
// GET: Regencies/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Regency regency = await db.Regencies.FindAsync(id);
if (regency == null)
{
return(HttpNotFound());
}
ViewBag.ProvinceId = new SelectList(db.Provinces, "Id", "Name", regency.ProvinceId);
return(View(regency));
}
public bool Update(int?Id, RegencyParam regencyParam)
{
var result = 0;
Regency getRegency = Get(Id);
getRegency.Name = regencyParam.Name;
getRegency.Provinces = myContext.Provinces.Find(regencyParam.Provinces_Id);
getRegency.UpdateDate = DateTimeOffset.Now.LocalDateTime;
result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
return(status);
}
[Authorize(Roles = "QL,Regency,RegencyD")] //Delete
public int DeleteConfirmed(string[] inputCheck)
{
//System.Windows.Forms.DialogResult dialogResult = System.Windows.Forms.MessageBox.Show("Chắc chắn không?", "Thông báo", System.Windows.Forms.MessageBoxButtons.YesNo);
int rowFinish = 0;
if (inputCheck == null)
{
return(rowFinish);
}
//if (dialogResult == System.Windows.Forms.DialogResult.Yes)
//{
foreach (var s in inputCheck)
{
try
{
int idMenu = Convert.ToInt32(DefineFuntion.Decrypt(s));
Regency obj = db.Regencies.Find(idMenu);
//1-them, 2- sua, 3-xoa, 4- khac
shared.CreateHistory(new History()
{
Name = "Xóa Chức Vụ",
Contens = JsonConvert.SerializeObject(obj, Formatting.Indented, new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
}),
ItemId = obj.RegencyId,
Type = (int)DefineFuntion.TypeHistory.Career,
});
db.Regencies.Remove(obj);
db.SaveChanges();
rowFinish++;
}
catch (Exception)
{
int idMenu = Convert.ToInt32(DefineFuntion.Decrypt(s));
Regency obj = db.Regencies.Find(idMenu);
obj.Status = 3;
db.SaveChanges();
}
}
//}
// else if (dialogResult == System.Windows.Forms.DialogResult.No)
//{
// return rowFinish;
//}
return(rowFinish);
}
public bool Delete(int?Id)
{
var result = 0;
Regency regency = Get(Id);
regency.IsDelete = true;
regency.DeleteDate = DateTimeOffset.Now.LocalDateTime;
result = myContext.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert(RegencyVM regencyVM)
{
var push = new Regency(regencyVM);
var getProviceId = myContext.Provinces.Find(regencyVM.Province_Id);
push.Province = getProviceId;
myContext.Regencys.Add(push);
var result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
else
{
status = false;
}
return(status);
}
public bool Insert(RegencyParam regencyParam)
{
var result = 0;
var regency = new Regency();
regency.Name = regencyParam.Name;
regency.Provinces = myContext.Provinces.Find(regencyParam.Provinces);
regency.CreateDate = DateTimeOffset.Now.LocalDateTime;
myContext.Regencies.Add(regency);
result = myContext.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Create(Regency rengency, string typeName)
{
var shared = new SharedFuntionController();
int ms = 0;
try
{
if (ModelState.IsValid)
{
db.Regencies.Add(rengency);
db.SaveChanges();
ms = 1;
//1-them, 2- sua, 3-xoa, 4- khac
shared.CreateHistory(new History()
{
Name = "Thêm Chức Vụ",
Contens = "",
ItemId = rengency.RegencyId,
Type = (int)DefineFuntion.TypeHistory.Regency,
});
}
}
catch (Exception)
{
ms = 2;
}
if (ms != 2)
{
if (typeName == "savenew" || typeName == "")
{
return(RedirectToAction("Create", new { mess = ms }));
}
else
{
return(RedirectToAction("Edit", new { id = DefineFuntion.Encrypt(rengency.RegencyId), mess = ms }));
}
}
ViewBag.Status = new SelectList(DefineFuntion.ListStatus, "Value", "Text", rengency.Status);
return(View());
}
public ActionResult Edit(Regency regency, string codeSystem, string typeName)
{
regency.RegencyId = Convert.ToInt32(DefineFuntion.Decrypt(codeSystem));
int ms = 0;
var me = db.Regencies.Find(regency.RegencyId);
try
{
me.Name = regency.Name;
me.Status = regency.Status;
me.Note = regency.Note;
db.SaveChanges();
ms = 3;//Nếu cập nhật thành công
//1-them, 2- sua, 3-xoa, 4- khac
shared.CreateHistory(new History()
{
Name = "Xóa Chức Vụ",
Contens = JsonConvert.SerializeObject(me, Formatting.Indented, new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
}),
ItemId = me.RegencyId,
Type = (int)DefineFuntion.TypeHistory.Regency,
});
}
catch (Exception)
{
ms = 4;//Nếu cập nhật không thành công
}
if (typeName == "savenew" || typeName == "")
{
return(RedirectToAction("Create", new { mess = ms }));
}
else
{
return(RedirectToAction("Edit", new { id = codeSystem, mess = ms }));
}
}
public async Task Add(Regency regency)
{
_context.Add(regency);
await _context.SaveChangesAsync();
}
public Regency Get(int?Id)
{
Regency regency = myContext.Regencies.Where(x => x.Id == Id).SingleOrDefault();
return(regency);
}
