public int editCT_DonHang(CT_DonHang ct_DH)
{
int kq;
using (MySqlConnection connMySQL = new MySqlConnection(Conn.connString))
{
using (MySqlCommand cmd = connMySQL.CreateCommand())
{
cmd.CommandText = "UPDATE CHITIET_DH SET CTDH_CHA_ID=@CTDH_CHA_ID,DONHANG_ID=@DONHANG_ID,HANGHOA_ID=@HANGHOA_ID,DONGIA=@DONGIA,SOLUONG=@SOLUONG," +
"TONGTIEN=@TONGTIEN,THUCTHU=@THUCTHU,TIEN_CONGTHEM=@TIEN_CONGTHEM,GHICHU=@GHICHU WHERE CTDH_ID=@CTDH_ID";
cmd.Parameters.Add(new MySqlParameter("CTDH_CHA_ID", ct_DH.CTDH_CHA_ID));
cmd.Parameters.Add(new MySqlParameter("DONHANG_ID", ct_DH.DONHANG_ID));
cmd.Parameters.Add(new MySqlParameter("HANGHOA_ID", ct_DH.HANGHOA_ID));
cmd.Parameters.Add(new MySqlParameter("DONGIA", ct_DH.DONGIA));
cmd.Parameters.Add(new MySqlParameter("SOLUONG", ct_DH.SOLUONG));
cmd.Parameters.Add(new MySqlParameter("TONGTIEN", ct_DH.TONGTIEN));
cmd.Parameters.Add(new MySqlParameter("THUCTHU", ct_DH.THUCTHU));
cmd.Parameters.Add(new MySqlParameter("TIEN_CONGTHEM", ct_DH.TIEN_CONGTHEM));
cmd.Parameters.Add(new MySqlParameter("GHICHU", ct_DH.GHICHU));
cmd.Parameters.Add(new MySqlParameter("CTDH_ID", ct_DH.CTDH_ID));
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = connMySQL;
connMySQL.Open();
kq = cmd.ExecuteNonQuery();
}
connMySQL.Close();
}
return(kq);
}
public int addCT_DonHang(CT_DonHang ct_DH)
{
int kq;
using (MySqlConnection connMySQL = new MySqlConnection(Conn.connString))
{
using (MySqlCommand cmd = connMySQL.CreateCommand())
{
cmd.CommandText = "INSERT INTO CHITIET_DH(CTDH_CHA_ID, DONHANG_ID, HANGHOA_ID, DONGIA, SOLUONG, TONGTIEN, THUCTHU, TIEN_CONGTHEM, GHICHU) V" +
"ALUES (@CTDH_CHA_ID, @DONHANG_ID, @HANGHOA_ID, @DONGIA, @SOLUONG, @TONGTIEN, @THUCTHU, @TIEN_CONGTHEM, @GHICHU)";
cmd.Parameters.Add(new MySqlParameter("CTDH_CHA_ID", ct_DH.CTDH_CHA_ID));
cmd.Parameters.Add(new MySqlParameter("DONHANG_ID", ct_DH.DONHANG_ID));
cmd.Parameters.Add(new MySqlParameter("HANGHOA_ID", ct_DH.HANGHOA_ID));
cmd.Parameters.Add(new MySqlParameter("DONGIA", ct_DH.DONGIA));
cmd.Parameters.Add(new MySqlParameter("SOLUONG", ct_DH.SOLUONG));
cmd.Parameters.Add(new MySqlParameter("TONGTIEN", ct_DH.TONGTIEN));
cmd.Parameters.Add(new MySqlParameter("THUCTHU", ct_DH.THUCTHU));
cmd.Parameters.Add(new MySqlParameter("TIEN_CONGTHEM", ct_DH.TIEN_CONGTHEM));
cmd.Parameters.Add(new MySqlParameter("GHICHU", ct_DH.GHICHU));
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = connMySQL;
connMySQL.Open();
kq = cmd.ExecuteNonQuery();
}
connMySQL.Close();
}
return(kq);
}
public string Put(CT_DonHang ct_DH)
{
try
{
CT_DonHang_DTO mysqlGet = new CT_DonHang_DTO();
return(mysqlGet.editCT_DonHang(ct_DH) == 0 ? "Không thành công" : "Thành công");
}
catch (Exception ex)
{
return(ex.Message);
throw;
}
}
public IActionResult IndexPOST()
{
List <SLSP> lstGioHang = HttpContext.Session.Get <List <SLSP> >("ssGioHang");
GioHangVM.DonHang.NgayNhanHang = GioHangVM.DonHang.NgayNhanHang
.AddHours(GioHangVM.DonHang.GioNhanHang.Hour)
.AddMinutes(GioHangVM.DonHang.GioNhanHang.Minute);
GioHangVM.DonHang.NgayLapDH = DateTime.Now;
//Tính tổng tiền của đơn hàng
double tongTien = 0;
foreach (var item in lstGioHang)
{
var sanPham = _db.SanPhams.Where(s => s.MaSP == item.MaSP).FirstOrDefault();
tongTien += sanPham.Gia * item.SoLuong;
}
GioHangVM.DonHang.TongTien = tongTien;
DonHang donHang = GioHangVM.DonHang;
_db.DonHangs.Add(donHang);
_db.SaveChanges();
int maDH = donHang.MaDH;
foreach (var sanpham in lstGioHang)
{
CT_DonHang cT_Don = new CT_DonHang()
{
MaDH = maDH,
MaSP = sanpham.MaSP,
SoLuong = sanpham.SoLuong
};
_db.CT_DonHangs.Add(cT_Don);
}
_db.SaveChanges();
lstGioHang = new List <SLSP>();
HttpContext.Session.Set("ssGioHang", lstGioHang);
return(RedirectToAction("XacNhanDonHang", "GioHang", new { ma = maDH }));
}
public CT_DonHang getCT_DonHang(int id)
{
CT_DonHang lCT_DonHang = new CT_DonHang();
using (MySqlConnection connMySQL = new MySqlConnection(Conn.connString))
{
using (MySqlCommand cmd = connMySQL.CreateCommand())
{
cmd.CommandText = "SELECT CTDH_ID, CTDH_CHA_ID, DONHANG_ID, HANGHOA_ID, DONGIA, SOLUONG, TONGTIEN, THUCTHU, TIEN_CONGTHEM, GHICHU FROM CHITIET_DH where CTDH_ID=@CTDH_ID";
cmd.Parameters.Add(new MySqlParameter("CTDH_ID", id));
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = connMySQL;
connMySQL.Open();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
lCT_DonHang = (new CT_DonHang
{
CTDH_ID = reader.GetInt32(reader.GetOrdinal("CTDH_ID")),
CTDH_CHA_ID = reader.IsDBNull(reader.GetOrdinal("CTDH_CHA_ID")) ? 0 : reader.GetInt32(reader.GetOrdinal("CTDH_CHA_ID")),
DONHANG_ID = reader.GetInt32(reader.GetOrdinal("DONHANG_ID")),
HANGHOA_ID = reader.GetInt32(reader.GetOrdinal("HANGHOA_ID")),
DONGIA = reader.GetFloat(reader.GetOrdinal("DONGIA")),
SOLUONG = reader.GetFloat(reader.GetOrdinal("SOLUONG")),
TONGTIEN = reader.GetFloat(reader.GetOrdinal("TONGTIEN")),
THUCTHU = reader.GetFloat(reader.GetOrdinal("THUCTHU")),
TIEN_CONGTHEM = reader.GetFloat(reader.GetOrdinal("TIEN_CONGTHEM")),
GHICHU = reader.GetString(reader.GetOrdinal("GHICHU"))
});
}
}
}
connMySQL.Close();
}
return(lCT_DonHang);
}
