public void Update(GroupNewMenuSanPhamDetail_Model model)
{
var data = Connect_Enttity.GroupNewMenuSanPhamDetails.FirstOrDefault(x => x.Id == model.Id);
if (data != null)
{
data.Name = model.Name;
data.NameEn = model.NameEn;
data.Tag = model.Tag;
data.IDthuonghieu = model.IDthuonghieu;
data.NguonSanPham = model.NguonSanPham;
data.Mausac = model.Mausac;
data.Kichthuoc = model.Kichthuoc;
data.SanphamCungloai = model.SanphamCungloai;
data.Donvi = model.Donvi;
data.Luotdanhgia = model.Luotdanhgia;
data.Video = model.Video;
data.Title = model.Title;
data.Description = model.Description;
data.Keyword = model.Keyword;
data.Priority = (int)(model.Priority);
data.Index = (int)(model.Index);
data.Order = (int)(model.Order);
data.Active = (int)(model.Active);
data.GroupNewsCatTag = model.GroupNewsCatTag;
data.Cateprolevel1 = model.Cateprolevel1;
data.Cateprolevel2 = model.Cateprolevel2;
data.Cateprolevel3 = model.Cateprolevel3;
data.Image = model.Image;
data.Image1 = model.Image1;
data.Image2 = model.Image2;
data.Image3 = model.Image3;
data.Image4 = model.Image4;
data.Image5 = model.Image5;
data.Content = model.Content;
data.ContentEn = model.ContentEn;
data.Detail = model.Detail;
data.DetailEn = model.DetailEn;
data.Khuyenmai = model.Khuyenmai;
data.KhuyenmaiEn = model.KhuyenmaiEn;
data.Baohanh = model.Baohanh;
data.BaohanhEn = model.BaohanhEn;
data.DacDiemNoiBat = model.DacDiemNoiBat;
data.DacDiemNoiBatEn = model.DacDiemNoiBatEn;
data.Thongdiep = model.Thongdiep;
data.ThongdiepEn = model.ThongdiepEn;
data.Seri = model.Seri;
data.Luotxem = (int)(model.Luotxem);
data.Soluongmua = (int)(model.Soluongmua);
data.DateCreate = Convert.ToDateTime(model.DateCreate);
if (model.DateView != null)
{
data.DateView = Convert.ToDateTime(model.DateView);
}
else
{
data.DateView = null;
}
//giá trị
data.Stock = (int)(model.Stock);
data.Number_Stock = (int)(model.Number_Stock);
data.Vat = (bool)(model.Vat);
data.Gianhaphang = (double)(model.Gianhaphang);
data.Giaban = (double)(model.Giaban);
data.Phantramkhuyenmai = (int)(model.Phantramkhuyenmai);
data.Giabankhuyenmai = (double)(model.Giabankhuyenmai);
//start event
if (model.DateStart_Event != null)
{
data.DateStart_Event = Convert.ToDateTime(model.DateStart_Event);
}
else
{
data.DateStart_Event = null;
}
//end event
if (model.DateEnd_Event != null)
{
data.DateEnd_Event = Convert.ToDateTime(model.DateEnd_Event);
}
else
{
data.DateEnd_Event = null;
}
data.Giaban_Event = (double)(model.Giaban_Event);
data.Content_Event = model.Content_Event;
data.Content_EventEn = model.Content_EventEn;
Connect_Enttity.SaveChanges();
Dispose();
}
}
public IList <GroupNewMenuSanPhamDetail_Model> GetId(GroupNewMenuSanPhamDetail_Model model)
{
IList <GroupNewMenuSanPhamDetail_Model> result = new List <GroupNewMenuSanPhamDetail_Model>();
result = Connect_Enttity.GroupNewMenuSanPhamDetails.Where(x => x.Id == model.Id).Select(x => new GroupNewMenuSanPhamDetail_Model
{
Id = x.Id,
Name = x.Name,
NameEn = x.NameEn,
Tag = x.Tag,
IDthuonghieu = x.IDthuonghieu,
NguonSanPham = x.NguonSanPham,
Mausac = x.Mausac,
Kichthuoc = x.Kichthuoc,
SanphamCungloai = x.SanphamCungloai,
Donvi = x.Donvi,
Luotdanhgia = x.Luotdanhgia,
Video = x.Video,
Title = x.Title,
Description = x.Description,
Keyword = x.Keyword,
Priority = (int)(x.Priority),
Index = (int)(x.Index),
Order = (int)(x.Order),
Active = (int)(x.Active),
GroupNewsCatTag = x.GroupNewsCatTag,
Cateprolevel1 = x.Cateprolevel1,
Cateprolevel2 = x.Cateprolevel2,
Cateprolevel3 = x.Cateprolevel3,
Image = x.Image,
Image1 = x.Image1,
Image2 = x.Image2,
Image3 = x.Image3,
Image4 = x.Image4,
Image5 = x.Image5,
Content = x.Content,
ContentEn = x.ContentEn,
Detail = x.Detail,
DetailEn = x.DetailEn,
Khuyenmai = x.Khuyenmai,
KhuyenmaiEn = x.KhuyenmaiEn,
Baohanh = x.Baohanh,
BaohanhEn = x.BaohanhEn,
DacDiemNoiBat = x.DacDiemNoiBat,
DacDiemNoiBatEn = x.DacDiemNoiBatEn,
Thongdiep = x.Thongdiep,
ThongdiepEn = x.ThongdiepEn,
Seri = x.Seri,
Luotxem = (int)(x.Luotxem),
Soluongmua = (int)(x.Soluongmua),
DateCreate = Convert.ToDateTime(x.DateCreate),
DateView = Convert.ToDateTime(x.DateView),
//giá trị
Stock = (int)(x.Stock),
Number_Stock = (int)(x.Number_Stock),
Vat = (bool)(x.Vat),
Gianhaphang = (double)(x.Gianhaphang),
Giaban = (double)(x.Giaban),
Phantramkhuyenmai = (int)(x.Phantramkhuyenmai),
Giabankhuyenmai = (double)(x.Giabankhuyenmai),
DateStart_Event = Convert.ToDateTime(x.DateStart_Event),
DateEnd_Event = Convert.ToDateTime(x.DateEnd_Event),
Giaban_Event = (double)(x.Giaban_Event),
Content_Event = x.Content_Event,
Content_EventEn = x.Content_EventEn
}).ToList();
return(result);
}
public IEnumerable <GroupNewMenuSanPhamDetail_Model> ReadID(GroupNewMenuSanPhamDetail_Model model)
{
return(GetId(model));
}
[Authorize(Roles = "Admin,Personnel")] //Personnel phan quyen
public JsonResult Update(string Id, string Name, string NameEn, string Tag, string IDthuonghieu, string NguonSanPham, string Mausac,
string Kichthuoc, string SanphamCungloai, string Donvi, string Luotdanhgia, string Video, string Title,
string Description, string Keyword, string Priority, string Index, string Order, string Active,
string GroupNewsCatTag, string Cateprolevel1, string Cateprolevel2, string Cateprolevel3, string Image, string Image1,
string Image2, string Image3, string Image4, string Image5, string Content, string ContentEn, string Detail,
string DetailEn, string Khuyenmai, string KhuyenmaiEn, string Baohanh, string BaohanhEn, string DacDiemNoiBat,
string DacDiemNoiBatEn, string Thongdiep, string ThongdiepEn, string Seri, string Luotxem, string Soluongmua,
string DateCreate, string DateView, string Stock, string Number_Stock, string Vat, string Gianhaphang,
string Giaban, string Phantramkhuyenmai, string Giabankhuyenmai, string DateStart_Event, string DateEnd_Event, string Giaban_Event,
string Content_Event, string Content_EventEn)
{
GroupNewMenuSanPhamDetail_Model data = new GroupNewMenuSanPhamDetail_Model();//gọi model data
data.Id = Convert.ToInt32(Id);
data.Name = Name;
data.NameEn = NameEn;
data.Tag = UrlRewrite.GenShortName(data.Name.Replace(":", "").Trim());
data.IDthuonghieu = IDthuonghieu;
data.NguonSanPham = NguonSanPham;
data.Mausac = Mausac;
data.Kichthuoc = Kichthuoc;
data.SanphamCungloai = SanphamCungloai;
data.Donvi = Donvi;
data.Luotdanhgia = Luotdanhgia;
data.Video = Video;
data.Title = Title;
data.Description = Description;
data.Keyword = Keyword;
data.Priority = Convert.ToInt32(Priority);
data.Index = Convert.ToInt32(Index);
data.Order = Convert.ToInt32(Order);
data.Active = Convert.ToInt32(Active);
data.GroupNewsCatTag = GroupNewsCatTag;
// Lever for catelog 1 and catelog 2 and catelog 3
Cateprolevel1 = Resurt_Cateprolevel1(Convert.ToInt32(GroupNewsCatTag));
Cateprolevel2 = Resurt_Cateprolevel2(Convert.ToInt32(GroupNewsCatTag));
Cateprolevel3 = Resurt_Cateprolevel3(Convert.ToInt32(GroupNewsCatTag));
//
data.Cateprolevel1 = Cateprolevel1;
data.Cateprolevel2 = Cateprolevel2;
data.Cateprolevel3 = Cateprolevel3;
data.Image = Image;
data.Image1 = Image1;
data.Image2 = Image2;
data.Image3 = Image3;
data.Image4 = Image4;
data.Image5 = Image5;
data.Content = Content;
data.ContentEn = ContentEn;
data.Detail = Detail;
data.DetailEn = DetailEn;
data.Khuyenmai = Khuyenmai;
data.KhuyenmaiEn = KhuyenmaiEn;
data.Baohanh = Baohanh;
data.BaohanhEn = BaohanhEn;
data.DacDiemNoiBat = DacDiemNoiBat;
data.DacDiemNoiBatEn = DacDiemNoiBatEn;
data.Thongdiep = Thongdiep;
data.ThongdiepEn = ThongdiepEn;
data.Seri = Seri;
data.Luotxem = Resurt_View(Convert.ToInt32(Id));
data.Soluongmua = Resurt_Soluongmua(Convert.ToInt32(Id));
data.DateCreate = Resurt_Date_Create(Convert.ToInt32(Id));
data.DateView = Resurt_Date_view(Convert.ToInt32(Id));
//giá trị
data.Stock = Convert.ToInt32(Stock);
data.Number_Stock = Convert.ToInt32(Number_Stock);
data.Vat = Convert.ToBoolean(Vat);
data.Gianhaphang = Convert.ToDouble(Gianhaphang.Replace(",", ""));
data.Giaban = Convert.ToDouble(Giaban.Replace(",", ""));
data.Phantramkhuyenmai = Convert.ToInt32(Phantramkhuyenmai);
data.Giabankhuyenmai = Convert.ToDouble(Giabankhuyenmai.Replace(",", ""));
if ((DateEnd_Event != null && DateStart_Event != null) || (DateEnd_Event != "" && DateStart_Event != ""))
{
try
{
DateTime DateStart_Event_ = DateTime.ParseExact(DateStart_Event, @"d/M/yyyy", System.Globalization.CultureInfo.InvariantCulture);
DateTime DateEnd_Event_ = DateTime.ParseExact(DateEnd_Event, @"d/M/yyyy", System.Globalization.CultureInfo.InvariantCulture);
data.DateStart_Event = DateStart_Event_;
data.DateEnd_Event = DateEnd_Event_;
}
catch
{
Resurt = 3;
}
}
else
{
data.DateStart_Event = null;
data.DateEnd_Event = null;
}
if (Giaban_Event == "" || DateEnd_Event == "" && DateStart_Event == "")
{
data.Giaban_Event = 0;
}
else
{
data.Giaban_Event = Convert.ToDouble(Giaban_Event.Replace(",", ""));
}
data.Content_Event = Content_Event;
data.Content_EventEn = Content_EventEn;
if (connect_entity.GroupNewMenuSanPhamDetails.FirstOrDefault
(x => x.Name == data.Name && x.Id != data.Id) == null) // kiểm tra không được trùng tên
{
Connect.Update(data); //gọi service lưu
Resurt = 1;
}
else
{
Resurt = 0;
}
return(Json(Resurt, JsonRequestBehavior.AllowGet));
}
