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