public static MobileModel Sale_SMS(int Id, String mobile, int collected, DateTime ExcTime, string detail = null)
{
s26webDataContext db = new s26webDataContext();
IntroductionModel intro = new IntroductionModel();
var msg = intro.Get_One(Id);
var data = db.Volunteers.FirstOrDefault(f => f.Mobile == mobile);
/////////////////////
msg.Content = msg.Content.Replace("<--end_time-->", ExcTime.AddHours(8).ToString("yyyy/MM/dd HH:mm"));
msg.Content = msg.Content.Replace("<--collected-->", collected.ToString());
/////////////////////
var mm = SMS_Send(msg, mobile);
SMS sms = new SMS
{
sms_id = mm.error_code,
content = mm.error_msg,
CreateTime = DateTime.UtcNow,
mobile = mobile,
detail = detail
};
db.SMS.InsertOnSubmit(sms);
db.SubmitChanges();
db.Connection.Close();
//return the response
return mm;
}
public void Update(string[] UserName, string[] FBUrl)
{
s26webDataContext db = new s26webDataContext();
for (int i = 0; i < UserName.Count(); i++)
{
var data = db.eCRM.FirstOrDefault(f => f.Id == (i + 1));
data.UserName = UserName[i];
data.FBUrl = FBUrl[i];
}
db.SubmitChanges();
db.Connection.Close();
}
public int Set(IntroductionModelShow item)
{
try
{
s26webDataContext db = new s26webDataContext();
if (item.Id > 0)
{
var data = db.Introduction.FirstOrDefault(f => f.Id == item.Id);
if (data != null)
{
data.Title = item.Title;
data.Content = item.Content;
data.UpdateTime = DateTime.UtcNow;
db.SubmitChanges();
db.Connection.Close();
return item.Id;
}
}
db.Connection.Close();
return -1;
}
catch { return -1; }
}
/// <summary>
/// Delete index[id] record of UserProfile
/// </summary>
/// <param name="id"></param>
private void Delete(int[] id)
{
if (id.Any())
{
s26webDataContext db = new s26webDataContext();
var data = db.UserProfile.Where(w => id.Contains(w.Id) && w.Id != 0);
if (data.Any())
{
db.UserProfile.DeleteAllOnSubmit(data);
db.SubmitChanges();
}
db.Connection.Close();
}
}
/// <summary>
/// Update [all-col] of CompetenceTable. If success finally, return [true], otherwise, return [false]
/// </summary>
/// <param name="FunctionChange"></param>
/// <param name="Id"></param>
/// <returns></returns>
private bool Update_FunctionCompetence(bool[] FunctionChange, int Id)
{
try
{
s26webDataContext db = new s26webDataContext();
var query = db.CompetenceTable.Where(w => w.UserLevelId == Id);
List<CompetenceTable> ct = new List<CompetenceTable>();
for (int i = 0; i < FunctionChange.Count(); i++)
{
var temp = db.CompetenceTable.FirstOrDefault(f => f.UserLevelId == Id && f.FunctionId == (i + 1));
if (temp == null)
{
ct.Add(new CompetenceTable
{
UserLevelId = Id,
FunctionId = (i + 1),
Enable = FunctionChange[i]
});
}
else
{
temp.Enable = FunctionChange[i];
}
}
db.CompetenceTable.InsertAllOnSubmit(ct);
db.SubmitChanges();
db.Connection.Close();
return true;
}
catch
{
return false;
}
}
/// <summary>
/// OrdersStates Update Function
/// </summary>
/// <param name="Osid"></param>
/// <param name="changeState"></param>
/// <param name="userId"></param>
private void OrdersStatesUpdate(string Osid, int changeState, int userId)
{
s26webDataContext db = new s26webDataContext();
var data = db.Orders.FirstOrDefault(w => w.Osid == Osid);
data.OrdersStates = changeState;
data.UpdateUserId = userId;
data.UpdateTime = DateTime.Now.AddHours(-8);
db.SubmitChanges();
}
public int Update(OnlineModelShow item)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.Online.FirstOrDefault(f => f.Id == item.Id);
if (data != null)
{
data.Type = item.Type;
data.Name = item.Name;
data.Content = item.Content;
if (item.Banner_PC != null)
{
data.Banner_PC = item.Banner_PC;
}
if (item.Banner_Mobile != null)
{
data.Banner_Mobile = item.Banner_Mobile;
}
data.Url = item.Url;
data.Display = item.Display;
data.StartTime = item.StartTime.AddHours(-8);
if (item.EndTime != DateTime.Parse("0001/1/1 上午 12:00:00"))
{
data.EndTime = item.EndTime.AddHours(-8);
}
else
{
data.EndTime = null;
}
data.UpdateTime = DateTime.UtcNow;
db.SubmitChanges();
db.Connection.Close();
return data.Id;
}
db.Connection.Close();
return -1;
}
catch { return -1; }
}
public int Update(ProductModelShow item, int LastUserId, HttpPostedFileBase file, string vid, HttpServerUtilityBase Server, HttpPostedFileBase ContentPic)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.Product.FirstOrDefault(f => f.Id == item.Id);
if (data != null)
{
data.Content = item.Content;
if (file != null)
if (file.ContentLength > 0 && file.ContentType.ToLower() == "image/jpeg" || file.ContentType == "image/png")
data.PictureLink = Method.Upload_File(file, vid, Server);
else
data.PictureLink = "";
if (ContentPic != null)
if (ContentPic.ContentLength > 0 && ContentPic.ContentType.ToLower() == "image/jpeg" || ContentPic.ContentType == "image/png")
data.ContentPic = Method.Upload_File(ContentPic, vid, Server);
else
data.ContentPic = "";
data.Price = item.Price;
data.Point = item.Point;
data.Limit = item.Limit;
data.Display = item.Display;
data.UpdateTime = DateTime.UtcNow;
data.LastUserId = LastUserId;
data.Link = item.Link;
data.Memo = item.Memo;
db.SubmitChanges();
db.Connection.Close();
return data.Id;
}
db.Connection.Close();
return -1;
}
catch { return -1; }
}
public void SaveImportData(IEnumerable<ImportClass> importSalesCodes, int SalesPromotionId = 0, string fileName = "")
{
s26webDataContext db = new s26webDataContext();
try
{
foreach (var item in importSalesCodes)
{
SalesCode new_item = new SalesCode
{
SalesPromotionId = SalesPromotionId,
SalesPromotionPoint = Get_SalesPromotionPoint(SalesPromotionId),
SalesPromotionDeadline = Get_SalesPromotionDeadline(SalesPromotionId),
Code = item.Code,
ExchangeStatus = false,
VolunteersId = 0,
CreateTime = DateTime.UtcNow
};
db.SalesCode.InsertOnSubmit(new_item);
db.SubmitChanges();
db.Connection.Close();
}
if (File.Exists(fileName))
{
File.Delete(fileName);
}
}
catch
{
throw;
}
}
/// <summary>
/// 資料筆數更新，提供多筆同時更新的功能
/// </summary>
/// <param name="EgidSource"></param>
/// <param name="StateSoucre"></param>
/// <param name="Updater"></param>
public void ScoreUpdate(string EgidSource, string StateSoucre, int Updater)
{
s26webDataContext db = new s26webDataContext();
string[] TempId = EgidSource.Split(',').ToArray();
string[] TempState = StateSoucre.Split(',').ToArray();
for (int i = 0; i < TempId.Length; i++)
{
ExchangeGift compareTemp = db.ExchangeGift.FirstOrDefault(w => w.Egid == TempId[i]);
if (compareTemp.Status != int.Parse(TempState[i]))
{
compareTemp.Status = int.Parse(TempState[i]);
compareTemp.UpdateUserId = Updater;
compareTemp.CreateTime = DateTime.Now.AddHours(-8);
db.SubmitChanges();
}
}
db.Connection.Close();
}
/// <summary>
/// Insert a new record to [UserProfile] database.If success return [Id],otherwise, return -1
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int Insert(MemberShow item)
{
s26webDataContext db = new s26webDataContext();
if (db.UserProfile.FirstOrDefault(f => f.Account_Phone.ToLower() == item.Account_Phone.ToLower()) == null)
{
UserProfile new_item = new UserProfile
{
Account_Phone = item.Account_Phone,
Password = Get_HashPassword(item.Password),
Name = item.Name,
Level = item.Level,
Enable = item.Enable,
CreateTime = DateTime.UtcNow
};
db.UserProfile.InsertOnSubmit(new_item);
db.SubmitChanges();
db.Connection.Close();
return new_item.Id;
}
else
{
db.Connection.Close();
return -1;
}
}
public int Insert(DeliveryModel.OrdersModel item)
{
s26webDataContext db = new s26webDataContext();
try
{
Orders orders = new Orders
{
VolunteersId = item.VolunteersId,
Osid = DateTime.UtcNow.AddHours(8).ToString("yyyyMMddHHmm"),
ProductId = item.ProductId,
Order_Quantity = item.Order_Quantity,
TotalPrice = item.TotalPrice,
Name = item.Name,
Mobile = item.Mobile,
CityId = item.CityId,
AreaId = item.AreaId,
Address = item.Address,
SharePoint= true,
Remarks = item.Remarks,
OrdersStates = 22,
OrdersTime = DateTime.UtcNow,
ReciveTimeChoice = 15,
OrdersFrom = 0,
};
db.Orders.InsertOnSubmit(orders);
db.SubmitChanges();
Invoice invoice = new Invoice
{
OrdersId = db.Orders.OrderByDescending(o => o.Id).FirstOrDefault(f => f.Id != null).Id,
InvoiceCategory = item.InvoiceCategory
};
if (item.InvoiceCategory == db.Category.FirstOrDefault(w => w.Fun_Id == 5 && w.Memo.Equals("Invoice")).Id)
{
invoice.InvoiceName = item.InvoiceName;
invoice.InvoiceNo = item.InvoiceNo;
}
db.Invoice.InsertOnSubmit(invoice);
db.SubmitChanges();
db.Connection.Close();
return orders.Id;
}
catch
{
return -1;
}
}
public int Update_BabyBirthday(string account, DateTime New_BabyBirthday)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.Volunteers.FirstOrDefault(w => w.Id == int.Parse(account));
if (data != null)
{
data.BabyBirthday = New_BabyBirthday;
data.UpdateTime = DateTime.UtcNow;
db.SubmitChanges();
db.Connection.Close();
return data.Id;
}
db.Connection.Close();
return -1;
}
catch { return -1; }
}
public void Delete(int[] id)
{
if (id != null)
{
if (id.Any())
{
s26webDataContext db = new s26webDataContext();
var data = db.LoginRecord.Where(w => id.Contains(w.Id));
if (data.Any())
{
db.LoginRecord.DeleteAllOnSubmit(data);
db.SubmitChanges();
}
db.Connection.Close();
}
}
}
public static int Login_Record(string account, HttpRequestBase Request, bool login)
{
try
{
s26webDataContext db = new s26webDataContext();
LoginRecord item = Convert(account, Request, login);
db.LoginRecord.InsertOnSubmit(item);
db.SubmitChanges();
db.Connection.Close();
return item.Id;
}
catch { return -1; }
}
/// <summary>
/// 若成功將資料寫入ExchangeGift資料表中後，進入Gift資料表扣除所選擇之Amount
/// </summary>
/// <param name="id"></param>
private void Reduce_Gift(int id)
{
s26webDataContext db = new s26webDataContext();
var temp = db.Gift.FirstOrDefault(w => w.Id == id);
temp.Amount -= 1;
db.SubmitChanges();
db.Connection.Close();
}
/// <summary>
/// Delete index[id] record of UserLevel
/// </summary>
/// <param name="id"></param>
public void Delete_UserLevel(int[] id)
{
if (id.Any())
{
s26webDataContext db = new s26webDataContext();
var data = db.UserLevel.Where(w => id.Contains(w.Id) && w.Id != 1);
if (data.Any())
{
db.UserLevel.DeleteAllOnSubmit(data);
db.SubmitChanges();
}
db.Connection.Close();
}
}
public int Insert(SalesCodeModelShow item)
{
s26webDataContext db = new s26webDataContext();
try
{
SalesCode new_item = new SalesCode
{
Code = item.Code,
SalesPromotionId = item.SalesPromotionId,
SalesPromotionPoint = Get_SalesPromotionPoint(item.SalesPromotionId),
SalesPromotionDeadline = Get_SalesPromotionDeadline(item.SalesPromotionId),
ExchangeStatus = false,
VolunteersId = 0,
CreateTime = DateTime.UtcNow
};
db.SalesCode.InsertOnSubmit(new_item);
db.SubmitChanges();
db.Connection.Close();
return new_item.Id;
}
catch
{
return -1;
}
}
/// <summary>
/// Insert a new record to [UserLevel] database.Finally, return the record [Id]
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int Insert_UserLevel(UserLevelShow item)
{
s26webDataContext db = new s26webDataContext();
var result = new UserLevel
{
Name = item.Name,
CreateTime = DateTime.UtcNow
};
db.UserLevel.InsertOnSubmit(result);
db.SubmitChanges();
Insert_CompetenceTable(item, result.Id);
return result.Id;
}
/// <summary>
/// 將資料筆數寫入資料表中
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int Insert_Score(InsertExchangeGift item)
{
s26webDataContext db = new s26webDataContext();
ExchangeGift result = new ExchangeGift
{
Egid = Get_TheDateScoreCount(DateTime.Now.AddDays(-8).ToString("yyyyMMdd")),
Vol_Id = Get_VolId(item.Vol_Mobile),
Name = item.Name,
Mobile = item.Mobile,
CityId = item.CityId,
AreaId = item.AreaId,
Address = item.Address,
GiftId = item.GiftId,
Remark = item.Remark,
Status = 29,
UpdateUserId = item.UpdateUserId,
CreateTime = DateTime.Now.AddHours(-8)
};
db.ExchangeGift.InsertOnSubmit(result);
db.SubmitChanges();
Reduce_Gift(result.GiftId);
return 1;
}
public int Set(SiteOptionShow item)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.WebConfig.FirstOrDefault();
if (data != null)
{
if (item.Android_Version != null)
{
data.Android_Version = item.Android_Version;
}
if (item.iOS_Version != null)
{
data.iOS_Version = item.iOS_Version;
}
data.WebTitle = item.WebTitle;
if (item.WebLogo != "")
{
data.WebLogo = item.WebLogo;
}
if (item.WebIcon != "")
{
data.WebIcon = item.WebIcon;
}
data.WebSEO = item.WebSEO;
data.WebDescription = item.WebDescription;
data.SMTP_Server = item.SMTP_Server;
data.SMTP_Port = item.SMTP_Port;
data.SMTP_Login = item.SMTP_Login;
data.SMTP_SSL = item.SMTP_SSL;
data.SMTP_Account = item.SMTP_Account;
data.SMTP_Password = item.SMTP_Password;
data.Service_Mail = item.Service_Mail;
data.FromName = item.FromName;
data.Export_Mail = item.ExportMail;
data.OrdersMail = item.OrdersMail;
db.SubmitChanges();
db.Connection.Close();
return data.Id;
}
else
{
WebConfig wc = new WebConfig
{
WebTitle = item.WebTitle,
WebLogo = item.WebLogo,
WebIcon = item.WebIcon,
WebSEO = item.WebSEO,
WebDescription = item.WebDescription,
SMTP_Server = item.SMTP_Server,
SMTP_Port = item.SMTP_Port,
SMTP_SSL= item.SMTP_SSL,
SMTP_Login = item.SMTP_Login,
SMTP_Account = item.SMTP_Account,
SMTP_Password = item.SMTP_Password,
Service_Mail = item.Service_Mail,
FromName = item.FromName,
Export_Mail = item.ExportMail
};
db.WebConfig.InsertOnSubmit(wc);
db.SubmitChanges();
db.Connection.Close();
return wc.Id;
}
}
catch { }
return 0;
}
/// <summary>
/// Insert an array of new record to [CompetenceTable] database.Finally
/// </summary>
/// <param name="item"></param>
/// <param name="Id"></param>
public void Insert_CompetenceTable(UserLevelShow item, int Id)
{
s26webDataContext db = new s26webDataContext();
List<CompetenceTable> ct = new List<CompetenceTable>();
for (int i = 0; i < item.Competence.Count(); i++)
{
ct.Add(new CompetenceTable
{
UserLevelId = Id,
FunctionId = (i + 1),
Enable = item.Competence[i]
});
} db.CompetenceTable.InsertAllOnSubmit(ct);
db.SubmitChanges();
db.Connection.Close();
}
public int Update(SalesCodeModelShow item)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.SalesCode.FirstOrDefault(f => f.Id == item.Id);
if (data != null)
{
data.Code = item.Code;
data.SalesPromotionId = item.SalesPromotionId;
data.SalesPromotionPoint = item.SalesPromotionPoint;
data.SalesPromotionDeadline = item.SalesPromotionDeadline;
db.SubmitChanges();
db.Connection.Close();
return data.Id;
}
db.Connection.Close();
return -1;
}
catch { return -1; }
}
/// <summary>
/// Using sql-insert the record.If success,return [Id], otherwise, return [-1]
/// </summary>
/// <param name="scs"></param>
/// <returns></returns>
private int Update(List<MemberShow> scs)
{
try
{
s26webDataContext db = new s26webDataContext();
int id = 0;
foreach (var i in scs)
{
var data = db.UserProfile.FirstOrDefault(f => f.Id == i.Id && f.Id != 0);
if (data != null)
{
data.Name = i.Name;
data.Level = i.Level;
if (i.Password != "" && i.Password != null)
{
data.Password = Get_HashPassword(i.Password);
}
data.Enable = i.Enable;
db.SubmitChanges();
id = data.Id;
}
}
db.Connection.Close();
return id;
}
catch { return -1; }
}
public int Check_Code_Front(SalesCodeModelShow item)
{
try
{
s26webDataContext db = new s26webDataContext();
//取得促銷碼資料
var Sale = db.SalesCode.FirstOrDefault(w => w.Code == item.Code);
//取得會員資料
var Vol = db.Volunteers.FirstOrDefault(f => f.Id == item.VolunteersId);
if (Sale != null && Vol != null)
{
if (Sale.ExchangeStatus == true)
{
return -1;
}
if (Vol.Point == null)
{
Vol.Point = 0;
}
Vol.Point += Sale.SalesPromotionPoint;
Sale.ExchangeStatus = true;
Sale.ExchangeTime = DateTime.UtcNow.AddHours(-8);
Sale.VolunteersId = item.VolunteersId;
Sale.VolunteersCreateTime = Vol.CreateTime;
db.SubmitChanges();
db.Connection.Close();
return Sale.Id;
}
db.Connection.Close();
return -2;
}
catch { return -2; }
}
/// <summary>
/// Update [Enable] of UserProfile,it's not using in the project
/// </summary>
/// <param name="id"></param>
/// <param name="en"></param>
/// <returns></returns>
private int Update_Enable(int[] id, bool en)
{
try
{
if (id != null)
{
if (id.Any())
{
s26webDataContext db = new s26webDataContext();
var data = db.UserProfile.Where(w => id.Contains(w.Id) && w.Id != 0);
if (data.Any())
{
foreach (var i in data)
{
i.Enable = en;
}
db.SubmitChanges();
}
db.Connection.Close();
return id.LastOrDefault();
}
}
return -1;
}
catch { return -1; }
}
public int Insert(OnlineModelShow item)
{
s26webDataContext db = new s26webDataContext();
try
{
//有輸入下線時間
if (item.EndTime != DateTime.Parse("0001/1/1 上午 12:00:00"))
{
Online new_item = new Online
{
Type = item.Type,
Name = item.Name,
Content = item.Content,
Banner_PC = item.Banner_PC,
Banner_Mobile = item.Banner_Mobile,
Url = item.Url,
Display = item.Display,
StartTime = item.StartTime.AddHours(-8),
EndTime = item.EndTime.AddHours(-8),
UpdateTime = DateTime.UtcNow
};
db.Online.InsertOnSubmit(new_item);
db.SubmitChanges();
db.Connection.Close();
return new_item.Id;
}
else
{
Online new_item = new Online
{
Type = item.Type,
Name = item.Name,
Content = item.Content,
Banner_PC = item.Banner_PC,
Banner_Mobile = item.Banner_Mobile,
Url = item.Url,
Display = item.Display,
StartTime = item.StartTime.AddHours(-8),
UpdateTime = DateTime.UtcNow
};
db.Online.InsertOnSubmit(new_item);
db.SubmitChanges();
db.Connection.Close();
return new_item.Id;
}
}
catch
{
return -1;
}
}
/// <summary>
/// Update [Level] of UserProfile,it's not using in the project
/// </summary>
/// <param name="id"></param>
/// <param name="level"></param>
/// <returns></returns>
private int Update_Level(int[] id, int level)
{
try
{
if (id != null)
{
if (id.Any())
{
s26webDataContext db = new s26webDataContext();
int result = -1;
var data = db.UserProfile.Where(w => id.Contains(w.Id) && w.Id != 0);
if (data.Any())
{
foreach (var i in data)
{
i.Level = level;
result = i.Id;
}
db.SubmitChanges();
}
db.Connection.Close();
return result;
}
}
return -1;
}
catch { return -1; }
}
public void Delete(int Id)
{
s26webDataContext db = new s26webDataContext();
var data = db.Online.Where(w => w.Id == Id);
if (data.Any())
{
db.Online.DeleteAllOnSubmit(data);
db.SubmitChanges();
}
db.Connection.Close();
}
/// <summary>
/// Update [Name] of UserLevel and the update function of competence.If success finally, return [1], otherwise, return [-1]
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int Update_UserLevel(UserLevelShow item)
{
s26webDataContext db = new s26webDataContext();
var data = db.UserLevel.FirstOrDefault(f => f.Id == item.Id);
if (data != null)
{
data.Name = item.Name;
db.SubmitChanges();
db.Connection.Close();
//Another function
if (Update_FunctionCompetence(item.Competence, item.Id))
{
return 1;
}
}
return -1;
}