public IList <CTdonhang_Model> GetId(CTdonhang_Model model)
{
IList <CTdonhang_Model> result = new List <CTdonhang_Model>();
result = Connect_Enttity.CTdonhangs.Where(x => x.IdCTHD == model.IdCTHD).Select(x => new CTdonhang_Model
{
IdCTHD = x.IdCTHD,
IDhd = (int)(x.IDhd),
IDsanpham = x.IDsanpham,
Tensanpham = x.Tensanpham,
Soluong = (int)(x.Soluong),
Giaban = Convert.ToDouble(x.Giaban),
Size = x.Size,
Mausac = x.Mausac,
Hinhanh = x.Hinhanh,
danhmucsanpham = x.danhmucsanpham,
chitietsanpham = x.chitietsanpham,
Giamthem = Convert.ToDouble(x.Giamthem),
phantramkm = Convert.ToInt32(x.phantramkm),
Baohanh = Convert.ToInt32(x.Baohanh),
Giacu = Convert.ToDouble(x.Giacu),
tinhtrang = x.tinhtrang
}).ToList();
return(result);
}
public void Create(CTdonhang_Model model)
{
var data = Connect_Enttity.CTdonhangs.FirstOrDefault(x => x.IdCTHD == model.IdCTHD);
var entity = new CTdonhang();
entity.IDhd = (int)(model.IDhd);
entity.IDsanpham = model.IDsanpham;
entity.Tensanpham = model.Tensanpham;
entity.Soluong = (int)(model.Soluong);
entity.Giaban = Convert.ToDouble(model.Giaban);
entity.Size = model.Size;
entity.Mausac = model.Mausac;
entity.Dungluong = model.Dungluong;
entity.Hinhanh = model.Hinhanh;
entity.danhmucsanpham = model.danhmucsanpham;
entity.chitietsanpham = model.chitietsanpham;
entity.Giamthem = Convert.ToDouble(model.Giamthem);
entity.phantramkm = model.phantramkm;
entity.Baohanh = model.Baohanh;
entity.Giacu = model.Giacu;
entity.tinhtrang = model.tinhtrang;
Connect_Enttity.CTdonhangs.Add(entity);
Connect_Enttity.SaveChanges();
//Dispose();
}
public void Update(CTdonhang_Model model)
{
var data = Connect_Enttity.CTdonhangs.FirstOrDefault(x => x.IdCTHD == model.IdCTHD);
if (data != null)
{
data.IDhd = (int)(model.IDhd);
data.IDsanpham = model.IDsanpham;
data.Tensanpham = model.Tensanpham;
data.Soluong = (int)(model.Soluong);
data.Giaban = Convert.ToDouble(model.Giaban);
data.Size = model.Size;
data.Mausac = model.Mausac;
data.Dungluong = model.Dungluong;
data.Hinhanh = model.Hinhanh;
data.danhmucsanpham = model.danhmucsanpham;
data.chitietsanpham = model.chitietsanpham;
data.Giamthem = Convert.ToDouble(model.Giamthem);
data.phantramkm = model.phantramkm;
data.Baohanh = model.Baohanh;
data.Giacu = model.Giacu;
data.tinhtrang = model.tinhtrang;
Connect_Enttity.SaveChanges();
Dispose();
}
}
public IEnumerable <CTdonhang_Model> ReadID(CTdonhang_Model model)
{
return(GetId(model));
}
public JsonResult CreateDonhang(string Hoten, string Mail, string Diachi, string GhiChuKhac,
string SDT, string ngaydathang, string Duyet, string Xungho,
string Tongtienhang, string Hinhthucgiaohang, string Tiengiamgia)
{
try
{
if (MySession.TongTien != 0)
{
CTdonhang_Model modelCTDonhang = new CTdonhang_Model();
Donhang_Model modelDonhang = new Donhang_Model();//gọi model data
//xử lý Đơn hàng
modelDonhang.IDuser = 0;
modelDonhang.SDT = SDT;
modelDonhang.Hoten = Hoten;
modelDonhang.Mail = Mail;
modelDonhang.Diachi = Diachi;
modelDonhang.Tinh = "";
modelDonhang.Huyen = "";
modelDonhang.Xungho = Xungho;
modelDonhang.Hinhthucthanhtoan = "";
modelDonhang.Goidichvu = "";
modelDonhang.Tongtienhang = Convert.ToDouble(MySession.TongTien);
modelDonhang.Thanhtoan = 0;
modelDonhang.ngaydathang = DateTime.Now;
modelDonhang.KH = "";
modelDonhang.Duyet = "0";
modelDonhang.Khuyenmai = "";
modelDonhang.Hinhthucgiaohang = "";
modelDonhang.GhiChuKhac = GhiChuKhac;
modelDonhang.Tiengiamgia = 0;
///Xử lý chi tiết đơn hàng
/////////////////////////////
ConnectDonhang.Create(modelDonhang);
var donhangmax = connect_entity.Donhang_Max().FirstOrDefault();
int id = Convert.ToInt32(donhangmax);
foreach (var s in MySession.GioHang)
{
modelCTDonhang.IDhd = id;
modelCTDonhang.IDsanpham = Convert.ToString(s.IDsanpham);
modelCTDonhang.Tensanpham = s.TenSanPham;
modelCTDonhang.Soluong = Convert.ToInt32(s.SoLuong);
modelCTDonhang.Giacu = Convert.ToDouble(s.Giacu);
modelCTDonhang.Giaban = Convert.ToDouble(s.Giaban);
modelCTDonhang.Size = s.Size;
modelCTDonhang.Mausac = _resurtTenmau(Convert.ToInt32(s.Mausac));
modelCTDonhang.Dungluong = s.Dungluong;
modelCTDonhang.Hinhanh = s.Hinhanh;
modelCTDonhang.Giamthem = s.Giamthem;
modelCTDonhang.danhmucsanpham = s.danhmucsanpham;
modelCTDonhang.chitietsanpham = s.chitietsanpham;
modelCTDonhang.Giamthem = s.Giamthem;
modelCTDonhang.phantramkm = s.phantramkm;
modelCTDonhang.Baohanh = Convert.ToInt32(s.Baohanh);
modelCTDonhang.tinhtrang = s.tinhtrang;
ConnectCTDonhang.Create(modelCTDonhang);
}
//sendmail(modelDonhang.Mail, modelDonhang.Hoten, modelDonhang.Xungho, modelDonhang.SDT, Convert.ToInt32(modelDonhang.Hinhthucgiaohang), modelDonhang.Diachi, 0 );
MySession.GioHang.Clear();
MySession.TongTien = 0;
}
resurt = 1;
return(Json(resurt, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
