public List<Category> Get_MemberType() { s26webDataContext db = new s26webDataContext(); GiftModelShow data = new GiftModelShow(); data.membertype_list = db.Category.Where(w => w.Fun_Id == 2).ToList(); db.Connection.Close(); return data.membertype_list; }
public List<GiftModelShow> Convert(List<Gift> item) { List<GiftModelShow> result = new List<GiftModelShow>(); foreach (var i in item) { var product = new GiftModelShow { Id = i.Id, MemberType = i.MemberType, Name = i.Name, Point = i.Point, Amount = i.Amount, Picture = i.Picture, Display = i.Display, CreateTime = i.CreateTime.AddHours(8), }; result.Add(product); } return result; }
public int Insert(GiftModelShow item, HttpPostedFileBase file, string vid, HttpServerUtilityBase Server) { var Picture = ""; s26webDataContext db = new s26webDataContext(); if (file != null) if (file.ContentLength > 0 && file.ContentType.ToLower() == "image/jpeg" || file.ContentType == "image/png") Picture = Method.Upload_File(file, vid, Server); else Picture = ""; try { Gift new_item = new Gift { MemberType = item.MemberType, Name = item.Name, Point = item.Point, Amount = item.Amount, Picture = Picture, Display = item.Display, CreateTime = DateTime.UtcNow }; db.Gift.InsertOnSubmit(new_item); db.SubmitChanges(); db.Connection.Close(); return new_item.Id; } catch { return -1; } }
public int Update(GiftModelShow item) { try { s26webDataContext db = new s26webDataContext(); var data = db.Gift.FirstOrDefault(f => f.Id == item.Id); if (data != null) { data.MemberType = item.MemberType; data.Name = item.Name; data.Point = item.Point; data.Amount = item.Amount; if(item.Picture!= null) { data.Picture = item.Picture; } data.Display = item.Display; db.SubmitChanges(); db.Connection.Close(); return data.Id; } db.Connection.Close(); return -1; } catch { return -1; } }
public GiftModelShow Get_One(int id) { s26webDataContext db = new s26webDataContext(); GiftModelShow data = new GiftModelShow(); var item = db.Gift.FirstOrDefault(f => f.Id == id); data.MemberType = item.MemberType; data.Name = item.Name; data.Point = item.Point; data.Amount = item.Amount; data.Picture = item.Picture; data.Display = item.Display; data.CreateTime = item.CreateTime.AddHours(8); db.Connection.Close(); return data; }