public static List <ResortManagerDTO.DTO.CTPhieuTra> LayCTPTtheoMaCTGD(out ResortManagerDTO.DTO.DbAck ack, int MaCTGD)
{
Provider provider = new Provider();
ack = provider.Connect();
if (ack == ResortManagerDTO.DTO.DbAck.NetworkError)
{
return(null);
}
DataTable dt = new DataTable();
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTGD", MaCTGD)
};
dt = provider.Select(CommandType.StoredProcedure, "usp_LayCTPTtheoMaCTGD", out ack, para);
List <ResortManagerDTO.DTO.CTPhieuTra> lstItem = new List <ResortManagerDTO.DTO.CTPhieuTra>();
if (dt == null)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
ResortManagerDTO.DTO.CTPhieuTra item = new ResortManagerDTO.DTO.CTPhieuTra();
item.MACHITIET = int.Parse(row["MACHITIET"].ToString());
item.MABOITHUONG = row["MABOITHUONG"].ToString();
item.SOLUONG = int.Parse(row["SOLUONG"].ToString());
item.MAPHIEUTRA = int.Parse(row["MAPHIEUTRA"].ToString());
lstItem.Add(item);
}
provider.Disconnect();
return(lstItem);
}
private void btnAdd_Click(object sender, EventArgs e)
{
foreach (ResortManagerDTO.DTO.BoiThuong item in this.lstItem)
{
if (item.MOTA == cmbItem.SelectedItem.ToString())
{
ResortManagerDTO.DTO.DbAck ack = new ResortManagerDTO.DTO.DbAck();
dgvLst.Rows.Add(new String[4] {
item.MABOITHUONG.Trim(), item.MOTA.Trim(), item.SOTIEN.ToString(), txtNum.Text.Trim()
});
ResortManagerDTO.DTO.CTPhieuTra ctpt = new ResortManagerDTO.DTO.CTPhieuTra();
ctpt.MABOITHUONG = item.MABOITHUONG;
ctpt.SOLUONG = int.Parse(txtNum.Text);
ctpt.MAPHIEUTRA = ResortManagerBUS.BUS.CTPhieuTra.LayMaPhieuTraTheoMaCTGD(out ack, this.MaCTGD);
this.lstCTPT.Add(ctpt);
this.PhiBoiThuong += (item.SOTIEN * int.Parse(txtNum.Text.Trim()));
break;
}
}
}
public static ResortManagerDTO.DTO.DbAck ThemCTPT(ResortManagerDTO.DTO.CTPhieuTra ctpt, int maCTGD)
{
Provider provider = new Provider();
ResortManagerDTO.DTO.DbAck result = provider.Connect();
if (result == ResortManagerDTO.DTO.DbAck.NetworkError)
{
goto Network; // net nhu la networkerror thi nhay den lable network
}
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maCTGD", maCTGD),
new SqlParameter("@maBT", ctpt.MABOITHUONG),
new SqlParameter("@soluong", ctpt.SOLUONG)
};
result = provider.ExcuteNonQuery(CommandType.StoredProcedure, "usp_ThemCTPT", para);
provider.Disconnect();
//lable network
Network:
return(result);
}
public static ResortManagerDTO.DTO.DbAck ThemCTPT(ResortManagerDTO.DTO.CTPhieuTra ctpt, int maCTGD)
{
return(ResortManagerDAO.DAO.CTPhieuTra.ThemCTPT(ctpt, maCTGD));
}
