public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Description")] LoaiDichVu loaiDichVu)
{
if (id != loaiDichVu.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(loaiDichVu);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LoaiDichVuExists(loaiDichVu.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(loaiDichVu));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,LoaiDichVuName,Description")] LoaiDichVu loaiDichVu)
{
if (id != loaiDichVu.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var loaidvuid = new SqlParameter("@id", loaiDichVu.Id);
var loaidichvuName = new SqlParameter("@Ten", loaiDichVu.LoaiDichVuName);
var mota = new SqlParameter("@mota", loaiDichVu.Description);
_context.Database.ExecuteSqlRaw("EXEC dbo.spEditLoaiDichVu @id,@Ten,@mota", loaidvuid, loaidichvuName, mota);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LoaiDichVuExists(loaiDichVu.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(loaiDichVu));
}
private void CommandBinding_Executed_Them(object sender, ExecutedRoutedEventArgs e)
{
LoaiDichVu t = xl.tim(txtMa.Text);
if (t != null)
{
MessageBox.Show("Đã có loại dịch vụ này trong CSDL!");
return;
}
LoaiDichVu a = new LoaiDichVu();
a.MaLoaiDV = txtMa.Text;
a.TenLoaiDV = txtTen.Text;
var message = validate(a);
if (message != string.Empty)
{
MessageBox.Show(message,
"Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
xl.them(a);
getDS();
}
public async Task <IActionResult> PostLoaiDichVu([FromBody] LoaiDichVu loaidichvu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = this.User.Identity.Name;
var userId = Utilities.GetUserId(this.User);
loaidichvu.NgayNhap = DateTime.Now;
loaidichvu.NguoiNhap = user;
var checkten = await _context.LoaiDichVus.SingleOrDefaultAsync(r => r.MaLoaiDichVuCha == loaidichvu.MaLoaiDichVuCha && r.TenLoaiDichVu == loaidichvu.TenLoaiDichVu);
if (checkten == null)
{
_context.LoaiDichVus.Add(loaidichvu);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetLoaiDichVu", new { id = loaidichvu.LoaiDichVuId }, loaidichvu));
}
else
{
var ldv = new LoaiDichVu();
if (checkten != null)
{
ldv.TenLoaiDichVu = "Exist";
}
return(Ok(ldv));
}
}
public void themLoaiDV(string tenloai)
{
LoaiDichVu ldv = new LoaiDichVu();
ldv.TenLoaiDV = tenloai;
datacontext.LoaiDichVus.InsertOnSubmit(ldv);
datacontext.SubmitChanges();
}
public void xoa(string Ma)
{
LoaiDichVu a = tim(Ma);
if (a != null)
{
xoa(a);
}
}
public void xoaLoaiDV(int id)
{
LoaiDichVu ldv = (from lp in datacontext.LoaiDichVus where lp.ID == id select lp).FirstOrDefault();
if (ldv != null)
{
datacontext.LoaiDichVus.DeleteOnSubmit(ldv);
datacontext.SubmitChanges();
}
}
public void suaLoaiDV(int id, string tenloai)
{
LoaiDichVu ldv = (from lp in datacontext.LoaiDichVus where lp.ID == id select lp).FirstOrDefault();
ldv.TenLoaiDV = tenloai;
if (ldv != null)
{
datacontext.SubmitChanges();
}
}
public string GetTenLoaiDichVu_byIdLoaiDichVu(int idLoaiDV)
{
LoaiDichVu ldv = db.LoaiDichVus.Where(n => n.id_LoaiDichVu == idLoaiDV).SingleOrDefault();
if (ldv != null)
{
return(ldv.ten_loai_dich_vu.Trim());
}
return("");
}
public async Task <IActionResult> Create([Bind("Id,Name,Description")] LoaiDichVu loaiDichVu)
{
if (ModelState.IsValid)
{
_context.Add(loaiDichVu);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(loaiDichVu));
}
public int GetIDLoaiDV_byTenLoai(string TenLoaiDV)
{
LoaiDichVu ldv = db.LoaiDichVus.Where(n => n.ten_loai_dich_vu.Equals(TenLoaiDV)).SingleOrDefault();
if (ldv == null)
{
return(-1);
}
return(ldv.id_LoaiDichVu);
}
public IActionResult Create([Bind("Id,LoaiDichVuName,Description")] LoaiDichVu loaiDichVu)
{
if (ModelState.IsValid)
{
var ten = new Microsoft.Data.SqlClient.SqlParameter("@Ten", loaiDichVu.LoaiDichVuName);
var mota = new Microsoft.Data.SqlClient.SqlParameter("@mota", loaiDichVu.Description);
_context.Database.ExecuteSqlRaw("EXEC dbo.spAddLoaiDichVu @Ten,@mota", ten, mota);
return(RedirectToAction(nameof(Index)));
}
return(View(loaiDichVu));
}
public void Sua(LoaiDichVu a)
{
LoaiDichVu b = tim(a.MaLoaiDV);
if (b != null)
{
b.MaLoaiDV = a.MaLoaiDV;
b.TenLoaiDV = a.TenLoaiDV;
//b.MoTa = a.MoTa;
tc.capnhat();
}
}
public List <LoaiDichVu> getDSLoaiDichVuFirstNull()
{
List <LoaiDichVu> ds = new List <LoaiDichVu>();
LoaiDichVu a = new LoaiDichVu();
a.IDLoaiDV = -1;
a.MaLoaiDV = "null";
a.TenLoaiDV = "Chọn loại dịch vụ";
ds.Add(a);
ds.AddRange(getDSLoaiDichVu());
return(ds);
}
private string validate(LoaiDichVu ldv)
{
var message = string.Empty;
if (string.IsNullOrEmpty(ldv.MaLoaiDV))
{
return(message = "Vui lòng nhập Mã loại dịch vụ.");
}
if (string.IsNullOrEmpty(ldv.TenLoaiDV))
{
return(message = "Vui lòng nhập Tên loại dịch vụ.");
}
return(message);
}
void DeQuyListDVCB(List <LoaiDichVu> list, int parentid, string st)
{
List <LoaiDichVu> ldv = new List <LoaiDichVu>();
ldv = _context.LoaiDichVus.Where(r => r.TrangThai != 2 && r.MaLoaiDichVuCha == parentid).OrderBy(m => m.TenLoaiDichVu).ToList <LoaiDichVu>();
for (int i = 0; i < ldv.Count; i++)
{
LoaiDichVu obj = new LoaiDichVu();
obj = ldv[i];
obj.TenLoaiDichVu = st + obj.TenLoaiDichVu;
list.Add(obj);
DeQuyListDVCB(list, obj.LoaiDichVuId, st + "|=> ");
}
}
public bool ThemDichVu(DichVu_Ent dv_ent)
{
DichVu dichVu = db.DichVus.Where(n => n.ten_dich_vu.Equals(dv_ent.TenDichVu)).SingleOrDefault();
LoaiDichVu loaiDV = db.LoaiDichVus.Where(n => n.ten_loai_dich_vu.Equals(dv_ent.TenLoaiDichVu)).SingleOrDefault();
if (dichVu != null)
{
return(false);
}
if (loaiDV == null)
{
try
{
LoaiDichVu ldv = new LoaiDichVu();
ldv.ten_loai_dich_vu = dv_ent.TenLoaiDichVu;
db.LoaiDichVus.InsertOnSubmit(ldv);
db.SubmitChanges();
}
catch
{
return(false);
}
}
db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.LoaiDichVus);
try
{
DichVu dv = new DichVu();
dv.ten_dich_vu = dv_ent.TenDichVu;
dv.gia_dich_vu = dv_ent.DonGia;
dv.id_loai_dich_vu = db.LoaiDichVus.Where(n => n.ten_loai_dich_vu.Equals(dv_ent.TenLoaiDichVu)).SingleOrDefault().id_LoaiDichVu;
db.DichVus.InsertOnSubmit(dv);
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
private void CommandBinding_Executed_Sua(object sender, ExecutedRoutedEventArgs e)
{
LoaiDichVu a = new LoaiDichVu();
a.MaLoaiDV = txtMa.Text;
a.TenLoaiDV = txtTen.Text;
//a.MoTa = txtMoTa.Text;
var message = validate(a);
if (message != string.Empty)
{
MessageBox.Show(message,
"Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
xl.Sua(a);
getDS();
}
public async Task <IActionResult> PutLoaiDichVu([FromRoute] int id, [FromBody] LoaiDichVu loaidichvu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != loaidichvu.LoaiDichVuId)
{
return(BadRequest());
}
var user = this.User.Identity.Name;
var userId = Utilities.GetUserId(this.User);
loaidichvu.NgaySua = DateTime.Now;
loaidichvu.NguoiSua = user;
var checkten = await _context.LoaiDichVus.SingleOrDefaultAsync(r => r.MaLoaiDichVuCha == loaidichvu.MaLoaiDichVuCha && r.TenLoaiDichVu == loaidichvu.TenLoaiDichVu && r.LoaiDichVuId != id);
if (checkten == null)
{
_context.Entry(loaidichvu).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(NoContent());
}
else
{
var ldv = "";
if (checkten != null)
{
ldv = "Exist";
}
return(Ok(ldv));
}
}
private void buttonItemLoaiDVu_Click(object sender, EventArgs e)
{
LoaiDichVu ldvu = new LoaiDichVu();
ldvu.ShowDialog();
}
public void New(LoaiDichVu LoaiDv)
{
throw new NotImplementedException();
}
public void them(LoaiDichVu a)
{
tc.getDSLoaiDichVu().InsertOnSubmit(a);
tc.capnhat();
}
public void xoa(LoaiDichVu a)
{
tc.getDSLoaiDichVu().DeleteOnSubmit(a);
tc.capnhat();
}
