public bool ChiTietDonThuocInsert(ChiTietDonThuocEntites obj) { var dt = new ChiTietDonThuocDAL(); if (dt.ChiTietDonThuocInsert(obj)) return true; return false; }
public bool ChiTietDonThuocInsert(ChiTietDonThuocEntites obj) { try { SqlConnection conn = ConnectionDB.GetConnect(); conn.Open(); SqlCommand cmd = new SqlCommand("ChiTietDonThuocInsert", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaDonThuoc", obj.MaDonThuoc)); cmd.Parameters.Add(new SqlParameter("@MaThuoc", obj.MaThuoc)); cmd.Parameters.Add(new SqlParameter("@LieuDung", obj.LieuDung)); cmd.Parameters.Add(new SqlParameter("@SoLuongThuoc", obj.SoLuongThuoc)); cmd.ExecuteNonQuery(); conn.Close(); } catch { return false; } return true; }
ChiTietDonThuocEntites NewChiTiet() { ChiTietDonThuocEntites obj = new ChiTietDonThuocEntites(); obj.SoLuongThuoc = txtSoLuong.Text; obj.LieuDung = txtLieuDung.Text; obj.MaThuoc = t.ThuocSelectMaThuoc(txtTenThuoc.Text).Rows[0]["MaThuoc"].ToString(); obj.MaDonThuoc = txtMaDonThuoc.Text; return obj; }