public List<SalesPromotionModelShow> Convert(List<SalesPromotion> item)
{
List<SalesPromotionModelShow> result = new List<SalesPromotionModelShow>();
foreach (var i in item)
{
var Sales = new SalesPromotionModelShow
{
Id = i.Id,
Code = i.Code,
Name = i.Name,
Deadline = i.Deadline,
Point = i.Point,
CreateTime = i.CreateTime.AddHours(8),
};
result.Add(Sales);
}
return result;
}
public SalesPromotionModelShow Get_One(int id)
{
s26webDataContext db = new s26webDataContext();
SalesPromotionModelShow data = new SalesPromotionModelShow();
var item = db.SalesPromotion.FirstOrDefault(f => f.Id == id);
data.Code = item.Code;
data.Name = item.Name;
data.Point = item.Point;
data.Deadline = item.Deadline.AddHours(8);
data.CreateTime = item.CreateTime.AddHours(8);
db.Connection.Close();
return data;
}
public int Update(SalesPromotionModelShow item)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.SalesPromotion.FirstOrDefault(f => f.Id == item.Id);
if (data != null)
{
data.Code = item.Code;
data.Name = item.Name;
data.Point = item.Point;
data.Deadline = item.Deadline;
db.SubmitChanges();
db.Connection.Close();
return data.Id;
}
db.Connection.Close();
return -1;
}
catch { return -1; }
}
public int Insert(SalesPromotionModelShow item)
{
s26webDataContext db = new s26webDataContext();
try
{
SalesPromotion new_item = new SalesPromotion
{
Code = item.Code,
Name = item.Name,
Point = item.Point,
Deadline = item.Deadline,
CreateTime = DateTime.UtcNow
};
db.SalesPromotion.InsertOnSubmit(new_item);
db.SubmitChanges();
db.Connection.Close();
return new_item.Id;
}
catch
{
return -1;
}
}
