public static bool thanhToanDDH(string maNCC, string ngay, string maNS, DataTable bangDH)
{
try
{
DDH_DTO DDH = new DDH_DTO(maNCC, ngay, maNS);
NhapHangDAO.themDDH(DDH);
int sohd = NhapHangDAO.laySoDDH();
for (int i = 0; i < bangDH.Rows.Count; i++)
{
ChiTietDDH_DTO ctDDH = new ChiTietDDH_DTO(sohd, bangDH.Rows[i][0].ToString(), Convert.ToInt32(bangDH.Rows[i][3]), Convert.ToInt32(bangDH.Rows[i][4]));
NhapHangDAO.themCTDDH(ctDDH);
}
return(true);
}
catch
{
return(false);
}
}
public static void themCTDDH(ChiTietDDH_DTO ctddh)
{
SqlConnection conn = DataAccess.ketNoi();
string sqlInsertCTHD = "SET DATEFORMAT DMY; INSERT INTO CTDONDATHANG VALUES(@SODDH, @MAMH, @SLDH, @DONGIA) ; UPDATE MATHANG SET SLT = SLT + @SLDH WHERE MAMH = @MAMH";
SqlCommand cmd = new SqlCommand(sqlInsertCTHD, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@SODDH", SqlDbType.Int).Value = ctddh.SoDDH;
cmd.Parameters.Add("@MAMH", SqlDbType.Char, 5).Value = ctddh.MaMH;
cmd.Parameters.Add("@SLDH", SqlDbType.Int).Value = ctddh.SlDat;
cmd.Parameters.Add("@DONGIA", SqlDbType.Int).Value = ctddh.DonGia;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
}
