public void ThemDonvi(Donvi dv)
{
StreamWriter fwrite = File.AppendText(txtfile);
fwrite.WriteLine();
fwrite.WriteLine(dv.MaDV + "#" + dv.TenDV);
fwrite.Close();
}
public int Update(Donvi obj)
{
SqlParameter[] para =
{
new SqlParameter("IDDonvi", obj.IDDonvi),
new SqlParameter("TenDonvi", obj.TenDonvi),
new SqlParameter("Soluong", obj.Soluong),
};
return(db.ExecuteSQL("Donvi_Update", para));
}
public async Task <IActionResult> Create([FromBody] Donvi model)
{
if (model == null)
{
return(BadRequest());
}
await donViRepository.Create(model);
return(Ok(model));
}
public void ThemDonvi(Donvi dv)
{
if (!string.IsNullOrEmpty(dv.TenDV))
{
//Tiến hành chuẩn hóa dữ liệu nếu cần
dvd.ThemDonvi(dv);
}
else
{
throw new Exception("Du lieu sai");
}
}
public void Nhap()
{
Console.Clear();
Console.SetCursorPosition(25, 5); Console.WriteLine("-----------------------------------------------------------------------------");
Console.SetCursorPosition(25, 6); Console.WriteLine("| Them thong tin don vi |");
Console.SetCursorPosition(25, 7); Console.WriteLine("|----------------------------------------------------------------------------|");
Console.SetCursorPosition(25, 19); Console.WriteLine("----------------------------------------------------------------------------");
Donvi dv = new Donvi();
Console.SetCursorPosition(27, 8); Console.Write("Nhap ma don vi:"); dv.MaDV = Console.ReadLine();
Console.SetCursorPosition(27, 10); Console.Write("Nhap ten don vi:"); dv.TenDV = Console.ReadLine();
DV.ThemDonvi(dv);
}
public ThemSuaDonVi(Donvi dv)
{
InitializeComponent();
lbTitle.Content = "Thay đổi đơn vị";
loadCombobox(dv.SttLoai);
txtChucnang.Text = dv.Chucnang;
txtDiachi.Text = dv.Diachi;
txtDienthoai.Text = dv.Dienthoai;
txtMadonvi.Text = dv.Madonvi;
txtNamthanhlap.Text = dv.Namthanhlap.ToString();
txtTendonvi.Text = dv.Ten;
them = false;
}
public async Task <IActionResult> Update(int id, [FromBody] Donvi model)
{
if (id != model.Id)
{
return(BadRequest());
}
model.Id = id;
await donViRepository.Update(model);
return(Ok(model));
}
private Donvi LayDonVi()
{
Donvi objkh = new Donvi();
objkh.DienThoai = txtdienthoai.Text.Trim();
objkh.Diachi = txtdiachi.Text.Trim();
objkh.TenDonVi = txttendonvi.Text.Trim();
objkh.AGENTID = txtagentid.Text.Trim();
objkh.HoatDong = CheckBox1.Checked;
objkh.APIPASS = txtapipass.Text.Trim();
objkh.APIUSER = txtapiuser.Text.Trim();
objkh.UserName = txtusername.Text.Trim();
return(objkh);
}
public int Edit(Donvi dv)
{
Donvi dvi = tb.Donvi.Find(dv.Iddonvi);
dvi.Madonvi = dvi.Madonvi;
dvi.Tendonvi = dv.Tendonvi;
try
{
tb.Entry(dvi).State = EntityState.Modified;
tb.SaveChanges();
return(1);
}
catch
{
throw;
}
}
public int Create([FromBody] Donvi dv)
{
dv.Madonvi = Auto_id();
tb.Donvi.Add(dv);
try
{
if (ModelState.IsValid)
{
tb.SaveChanges();
}
return(1);
}
catch (DbUpdateException)
{
throw;
}
}
public void Sua()
{
Console.Clear();
Console.SetCursorPosition(25, 5); Console.WriteLine("-----------------------------------------------------------------------------");
Console.SetCursorPosition(25, 6); Console.WriteLine("| Sua thong tin don vi |");
Console.SetCursorPosition(25, 7); Console.WriteLine("|---------------------------------------------------------------------------|");
Console.SetCursorPosition(25, 20); Console.WriteLine("-----------------------------------------------------------------------------");
List <Donvi> list = DV.GetAllDonvi();
string Tensua;
Console.Write("NHAP TEN DON VI CAN SUA:");
Tensua = Console.ReadLine();
int i = 0;
for (i = 0; i < list.Count; ++i)
{
if (list[i].TenDV == Tensua)
{
if (i < list.Count)
{
Donvi dv = new Donvi(list[i]);
Console.SetCursorPosition(27, 17);; Console.Write("Nhap ten moi :");
string ten = Console.ReadLine();
if (!string.IsNullOrEmpty(ten))
{
dv.TenDV = ten;
}
Console.SetCursorPosition(27, 17); Console.Write("Nhap ma moi:");
string ma = Console.ReadLine();
if (!string.IsNullOrEmpty(ten))
{
dv.MaDV = ma;
}
DV.SuaDonVi(dv);
}
}
else
{
Console.SetCursorPosition(27, 17); Console.WriteLine("khong ton tai ten don vi nay");
}
}
}
public int Delete(int id)
{
try
{
Donvi dv = tb.Donvi.Find(id);
if (dv != null)
{
tb.Donvi.Remove(dv);
tb.SaveChanges();
return(1);
}
else
{
return(0);
}
}
catch
{
throw;
}
}
public void SuaDonvi(Donvi dv)
{
int i;
List <Donvi> list = GetAllDonvi();
for (i = 0; i < list.Count; ++i)
{
if (list[i].MaDV == dv.MaDV)
{
break;
}
}
if (i < list.Count)
{
list.RemoveAt(i);
list.Add(dv);
dvd.Update(list);
}
else
{
throw new Exception("Khong ton tai hs nay");
}
}
public List <Donvi> TimDonvi(Donvi dv)
{
List <Donvi> list = GetAllDonvi();
List <Donvi> kq = new List <Donvi>();
if (string.IsNullOrEmpty(dv.MaDV) &&
string.IsNullOrEmpty(dv.TenDV))
{
kq = list;
}
//Tim theo ten nv
if (!string.IsNullOrEmpty(dv.TenDV))
{
for (int i = 0; i < list.Count; ++i)
{
if (list[i].TenDV.IndexOf(dv.TenDV) >= 0)
{
kq.Add(new Donvi(list[i]));
}
}
}
return(kq);
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
if(check())
{
Donvi dv = new Donvi();
dv.Madonvi = txtMadonvi.Text;
dv.Ten = txtTendonvi.Text;
Loaidonvi l = cmbLoaidonvi.SelectedItem as Loaidonvi;
dv.SttLoai = l.Stt;
dv.Diachi = txtDiachi.Text;
dv.Namthanhlap = int.Parse(txtNamthanhlap.Text);
dv.Dienthoai = txtDienthoai.Text;
dv.Chucnang = txtChucnang.Text;
if (them) ql.ThemDonvi(dv);
else ql.SuaDonvi(dv);
//LoaidonviUC a = (this.Parent as StackPanel).FindName("ldvUC") as LoaidonviUC;
foreach(FrameworkElement child in (this.Parent as StackPanel).Children)
{
if (child.Name=="UC")
{
DonviUC b = child as DonviUC;
b.loadDonvi();
break;
}
}
(this.Parent as StackPanel).Children.Remove(this);
//a.loadDanhsachloai();
}
}
public List <Donvi> TimDonVi(Donvi dv)
{
throw new NotImplementedException();
}
public void SuaDonVi(Donvi dv)
{
throw new NotImplementedException();
}
public int Update(Donvi obj)
{
return(dao.Update(obj));
}
public int Insert(Donvi obj)
{
return(dao.Insert(obj));
}
