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