public CuDan TimCuDanTheoSoCMT(string soCMT)
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.SoCMT == soCMT);
if (cd != null)
{
cd.CanHos = null;
cd.HopDongs = null;
}
return(cd);
}
public CuDan ChiTietCuDan(string id)
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.MaCuDan == id);
if (cd != null)
{
cd.CanHos = null;
cd.HopDongs = null;
}
return(cd);
}
public bool LuuCuDan(CuDanModel cdm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = new CuDan {
MaCuDan = cdm.MaCuDan, TenCuDan = cdm.TenCuDan, GioiTinh = cdm.GioiTinh, NgaySinh = cdm.NgaySinh, SoDT = cdm.SoDT, SoCMT = cdm.SoCMT, QueQuan = cdm.QueQuan
};
context.CuDans.InsertOnSubmit(cd);
context.SubmitChanges();
return(true);
}
catch { }
return(false);
}
public bool XoaCuDan(string macd)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.MaCuDan == macd);
if (cd != null)
{
context.CuDans.DeleteOnSubmit(cd);
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public async Task <IActionResult> PostCuDan([FromBody] CuDan cudan)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = User.Identity.Name;
var userId = Utilities.GetUserId(this.User);
cudan.NgayNhap = DateTime.Now;
cudan.NguoiNhap = user;
_context.CuDans.Add(cudan);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCuDan", new { id = cudan.CuDanId }, cudan));
}
public bool SuaCuDan(CuDanModel cdm)
{
try
{
DB_QuanLyChungCuDataContext context = new DB_QuanLyChungCuDataContext();
CuDan cd = context.CuDans.FirstOrDefault(x => x.MaCuDan == cdm.MaCuDan);
if (cd != null)
{
cd.TenCuDan = cdm.TenCuDan;
cd.GioiTinh = cdm.GioiTinh;
cd.NgaySinh = cdm.NgaySinh;
cd.SoDT = cdm.SoDT;
cd.SoCMT = cdm.SoCMT;
cd.QueQuan = cdm.QueQuan;
context.SubmitChanges();
return(true);
}
}
catch { }
return(false);
}
public async Task <IActionResult> PutCuDan([FromRoute] int id, [FromBody] CuDan cudan)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != cudan.CuDanId)
{
return(BadRequest());
}
var user = User.Identity.Name;
var userId = Utilities.GetUserId(this.User);
cudan.NgaySua = DateTime.Now;
cudan.NguoiSua = user;
_context.Entry(cudan).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CuDanExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
