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); } }