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 SiteOptionShow Get()
{
s26webDataContext db = new s26webDataContext();
var data = db.WebConfig.FirstOrDefault();
db.Connection.Close();
if (data != null)
{
return new SiteOptionShow
{
Id = data.Id,
WebTitle = data.WebTitle,
WebIcon = data.WebIcon,
WebLogo = Method.RootPath + data.WebLogo,
WebSEO = data.WebSEO,
WebDescription = data.WebDescription,
SMTP_Server = data.SMTP_Server,
SMTP_Port = data.SMTP_Port,
SMTP_Login = data.SMTP_Login,
SMTP_SSL = data.SMTP_SSL,
SMTP_Account = data.SMTP_Account,
SMTP_Password = data.SMTP_Password,
Service_Mail = data.Service_Mail,
FromName = data.FromName,
ExportMail = data.Export_Mail,
OrdersMail = data.OrdersMail,
iOS_Version = data.iOS_Version,
Android_Version = data.Android_Version
};
}
return new SiteOptionShow();
}
public List<OnlineModelShow> Get_Data(int p = 1, int take = 10)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = Get().OrderByDescending(o => o.Id).Skip((p - 1) * take).Take(take);
foreach (var i in data)
{
string[] typestr = i.Type.Split(',');
string list = "";
foreach (var j in typestr)
{
if (j != "")
{
int typeint = int.Parse(j);
list += db.Category.FirstOrDefault(f => f.Id == typeint).Name + ",";
}
}
i.Type = list;
};
List<OnlineModelShow> item = Convert(data.ToList());
db.Connection.Close();
return item;
}
catch { return new List<OnlineModelShow>(); }
}
public static List<SelectListItem> Get_Area_Select(int city, int area, bool zip, bool all)
{
s26webDataContext db = new s26webDataContext();
List<SelectListItem> data = new List<SelectListItem>();
data.Add(new SelectListItem
{
Selected = area == 0,
Text = all ? "全部" : "請選擇",
Value = "0"
});
if (city == 0)
{
return data;
}
data.AddRange(db.Area.Where(w => w.City_Id == city).OrderBy(o => o.Id).ThenBy(t => t.ZipCode).Select(s =>
new SelectListItem
{
Selected = area == s.Id,
Text = (zip ? s.ZipCode : "") + s.Name,
Value = s.Id.ToString()
}));
db.Connection.Close();
return data;
}
public IQueryable<SalesPromotion> Get()
{
s26webDataContext db = new s26webDataContext();
IQueryable<SalesPromotion> data = db.SalesPromotion;
db.Connection.Close();
return data;
}
public IQueryable<Online> Get()
{
s26webDataContext db = new s26webDataContext();
IQueryable<Online> data = db.Online;
db.Connection.Close();
return data;
}
public List<GiftModelShow> Get_Data()
{
s26webDataContext db = new s26webDataContext();
var gift = Convert(db.Gift.OrderByDescending(o => o.Id).ToList());
foreach(var i in gift)
{
string[] typestr= i.MemberType.Split(',');
string list = "";
string item = "";
foreach(var j in typestr)
{
if (j != "")
{
int typeint = int.Parse(j);
if(typeint == 1)
{ item = "懷孕中"; }
else if (typeint == 2)
{ item = "使用S-26產品"; }
else if (typeint == 3)
{ item = "全母乳餵哺"; }
else if (typeint == 4)
{ item = "其他"; }
//list += db.Category.FirstOrDefault(f => f.Id == typeint).Name + ",";
}
list += item + ",";
}
i.MemberType = list;
};
db.Connection.Close();
return gift;
}
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<Category> Get_Category()
{
s26webDataContext db = new s26webDataContext();
PointModelShow data = new PointModelShow();
data.Point_Category = db.Category.Where(w => w.Fun_Id == 3).ToList();
db.Connection.Close();
return data.Point_Category;
}
public ActionResult CheckMobile(string Mobile)
{
s26webDataContext db = new s26webDataContext();
var result = db.Volunteers.FirstOrDefault(f => f.Mobile == Mobile);
db.Connection.Close();
if (result != null)
return Json(false, JsonRequestBehavior.AllowGet);
else
return Json(true, JsonRequestBehavior.AllowGet);
}
public static int getSMSPoint()
{
s26web.Models.s26webDataContext db = new s26web.Models.s26webDataContext();
int point = 0;
var result = db.SMS.Where(w=>w.sms_id.Equals("000")).OrderByDescending(o => o.CreateTime).FirstOrDefault();
List<string> sms_content = new List<string>();
if(result != null)
sms_content = result.content.Split('|').ToList();
point = Convert.ToInt32(sms_content.LastOrDefault());
return point;
}
public ActionResult Delivery_Order(string Osid, int Id)
{
string Session_name = Method.SessionUserId_Home;
int memberid = int.Parse(Method.Get_Session(Session, Session_name));
s26webDataContext db = new s26webDataContext();
Osid = db.Orders.FirstOrDefault(f => f.Id == Id).Osid;
db.Connection.Close();
OrdersModel orders = new OrdersModel();
var orderdetail = orders.Get_Detail(Osid);
return View(orderdetail);
}
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 List<SalesPromotionModelShow> Get_Data(int p = 1, int take = 10)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = Get().OrderByDescending(o=>o.Id).Skip((p - 1) * take).Take(take);
List<SalesPromotionModelShow> item = Convert(data.ToList());
db.Connection.Close();
return item;
}
catch { return new List<SalesPromotionModelShow>(); }
}
public ActionResult Index()//HttpSessionStateBase Session
{
s26webDataContext db = new s26webDataContext();
string Session_name = Method.SessionUserId_Home;
string account = Method.Get_Session(Session, Session_name);
var vol = db.Volunteers.FirstOrDefault(w => w.Id == int.Parse(account));
ViewData["Bir_year"] = vol.BabyBirthday.ToString("yyyy");
ViewData["Bir_month"] = vol.BabyBirthday.ToString("MM");
ViewData["Bir_date"] = vol.BabyBirthday.ToString("dd");
return View();
}
public ActionResult Edit(SalesPromotionModel.SalesPromotionModelShow item, int p = 1)
{
{
s26webDataContext db = new s26webDataContext();
var old = db.SalesPromotion.FirstOrDefault(f => f.Id == item.Id);
db.Connection.Close();
if (data.Update(item) <= 0)
{
TempData["err"] = "SalesPromotion_5";
return RedirectToAction("Index");
}
}
return RedirectToAction("Index", new { p = p });
}
public static string Get_Title(int id)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.Introduction.FirstOrDefault(f => f.Id == id);
db.Connection.Close();
if (data != null)
{
return data.Title;
}
}
catch { }
return "";
}
public LoginRecordModelShow Get_One(int id)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.LoginRecord.FirstOrDefault(f => f.Id == id);
if (data != null)
{
return Convert(data);
}
db.Connection.Close();
}
catch { }
return null;
}
public ActionResult Index(int year, int month, int date)
{
s26webDataContext db = new s26webDataContext();
DeliveryModel data = new DeliveryModel();
string Session_name = Method.SessionUserId_Home;
string account = Method.Get_Session(Session, Session_name);
DateTime New_BabyBirthday = new DateTime(year, month, date);
//string New_BabyBirthday = year+"/"+month+"/"+date;
DateTime vol_BabyBirthday = db.Volunteers.FirstOrDefault(w => w.Id == int.Parse(account)).BabyBirthday;
if (vol_BabyBirthday != New_BabyBirthday)
{
data.Update_BabyBirthday(account, New_BabyBirthday);
}
return RedirectToAction("article");
}
public List<CRMMemberInfo> Get_Data()
{
s26webDataContext db = new s26webDataContext();
var data = db.eCRM;
List<CRMMemberInfo> mm = new List<CRMMemberInfo>();
foreach (var i in data)
{
mm.Add(new CRMMemberInfo
{
Id = i.Id,
CategoryName = i.CategoryName,
FBUrl = i.FBUrl,
UserName = i.UserName
});
}
db.Connection.Close();
return mm;
}
public static List<SelectListItem> Get_City_Select(int city, bool all)
{
s26webDataContext db = new s26webDataContext();
List<SelectListItem> data = new List<SelectListItem>();
data.Add(new SelectListItem
{
Selected = city == 0,
Text = all ? "全部" : "請選擇",
Value = "0"
});
data.AddRange(db.City.OrderBy(o => o.Id).Select(s =>
new SelectListItem
{
Selected = city == s.Id,
Text = s.Name,
Value = s.Id.ToString()
}));
db.Connection.Close();
return data;
}
public ActionResult Edit(GiftModel.GiftModelShow item, int p = 1, string[] MemberTypelist = null)
{
{
s26webDataContext db = new s26webDataContext();
var old = db.Gift.FirstOrDefault(f => f.Id == item.Id);
db.Connection.Close();
foreach (var i in MemberTypelist)
{ item.MemberType += i + ","; }
//刪除最後一個逗號
item.MemberType = item.MemberType.Remove(item.MemberType.LastIndexOf(","), 1);
if (data.Update(item) <= 0)
{
TempData["err"] = "Gift_5";
return RedirectToAction("Index");
}
}
return RedirectToAction("Index", new { p = p });
}
public ActionResult Create(PointModel.PointModelShow item, string phone)
{
s26webDataContext db = new s26webDataContext();
List<string> mobile_list = new List<string>();
mobile_list = phone.Split(',').ToList();
int user_id = Method.Get_UserId_Admin(Request.Cookies, Session);
item.UId = user_id;
item.Category = 2;
item.Result = true;
foreach (var i in mobile_list)
{
item.Mobile = i;
if (data.Insert(item) <= 0)
{
TempData["err"] = "";
return RedirectToAction("Index");
}
}
return RedirectToAction("Index");
}
public IntroductionModelShow Get_One(int id)
{
try
{
s26webDataContext db = new s26webDataContext();
var data = db.Introduction.FirstOrDefault(f => f.Id == id);
if (data != null)
{
return new IntroductionModelShow
{
Id = data.Id,
Title = data.Title,
Content = HttpUtility.HtmlDecode(data.Content),
CreateTime = data.CreateTime.AddHours(8),
UpdateTime = data.UpdateTime.AddHours(8)
};
}
return null;
}
catch { return null; }
}
public ActionResult Count(SalesCodeModel.SalesCodeModelShow item)
{
SalesCodeModel data = new SalesCodeModel();
int Num = data.Check_Code_Front(item);
//促銷碼已經兌換過
if (Num == -1)
{
return RedirectToAction("Count", new { Code_Error = -1, Code = item.Code });
}
//促銷碼輸入錯誤
else if (Num == -2)
{
return RedirectToAction("Count", new { Code_Error = -2, Code = item.Code });
}
//兌換成功
else
{
s26webDataContext db = new s26webDataContext();
int Point = db.SalesCode.FirstOrDefault(w => w.Code == item.Code).SalesPromotionPoint;
return RedirectToAction("Premiums_complete", new { Point = Point });
}
}
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; }
}
public List<Category> Get_Type()
{
s26webDataContext db = new s26webDataContext();
OnlineModelShow data = new OnlineModelShow();
data.type_list = db.Category.Where(w => w.Fun_Id == 10).ToList();
db.Connection.Close();
return data.type_list;
}
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();
}
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 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;
}
}