public bool ChiTietDonThuocInsert(ChiTietDonThuocEntites obj)
{
var dt = new ChiTietDonThuocDAL();
if (dt.ChiTietDonThuocInsert(obj))
{
return(true);
}
return(false);
}
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);
}
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);
}
