public static void themDDH(DDH_DTO ddh)
{
SqlConnection conn = DataAccess.ketNoi();
string sqlInsert = "SET DATEFORMAT DMY; INSERT INTO DONDATHANG(MANCC, NGAYLAPDON, MANS) VALUES(@MANCC,@NGAY,@MANS)";
SqlCommand cmd = new SqlCommand(sqlInsert, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@MANCC", SqlDbType.Char, 5).Value = ddh.MaNCC;
cmd.Parameters.Add("@NGAY", SqlDbType.DateTime).Value = ddh.NgayLap;
cmd.Parameters.Add("@MANS", SqlDbType.Char, 5).Value = ddh.MaNS;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
}
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);
}
}
