public static Event Select(int eventId)
{
using (var db = new Models.ModelContext())
{
return(db.Events.Where(e => e.Id.Equals(eventId)).FirstOrDefault());
}
}
public static string Update(int promotionId, int state)
{
using (var db = new Models.ModelContext())
{
if (0 <= state && state < 3)
{
var currPromotion = db.Promotions.FirstOrDefault(p => p.Id.Equals(promotionId));
if (currPromotion != null)
{
if (currPromotion.State == (OrderState)state)
{
return("Negalima pekeisti užsakymo būsenos į tokią pačia");
}
else
{
currPromotion.State = (OrderState)state;
db.Update(currPromotion);
db.SaveChanges();
return("Užsakymo būsena sėkmingai atnaujinta");
}
}
else
{
return("Šis užsakymas nerastas");
}
}
else
{
return("Neteisinga užsakymo būsena");
}
}
}
public static User getUser(int id)
{
using (var db = new Models.ModelContext())
{
return(db.Users.Where(u => u.Id == id).FirstOrDefault());
}
}
public static Tuple <string, bool> Insert(int eventId, int userId)
{
using (var db = new Models.ModelContext())
{
var currEvent = db.Events.Where(e => e.Id.Equals(eventId));
var currUser = db.Users.Where(u => u.Id.Equals(userId));
// If any of the elements are not present in db
if (!(currEvent.Any() && currUser.Any()))
{
return(new Tuple <string, bool>("Atleiskite, įvyko klaida", false));
}
var schedule = db.Schedules.Where(s => (s.Event_id == eventId) && (s.User_id == userId));
if (schedule.Any())
{
return(new Tuple <string, bool>("Šis renginys jau pridėtas į Jūsų tvarkaraštį", false));
}
else
{
var newSchedule = new Models.Schedule();
newSchedule.Event_id = eventId;
newSchedule.User_id = userId;
db.Schedules.Add(newSchedule);
db.SaveChanges();
return(new Tuple <string, bool>("Renginys sėkmingai pridėtas į Jūsų tvarkaraštį.", true));
}
}
}
public static List <User> getUserList()
{
using (var db = new Models.ModelContext())
{
return(db.Users.ToList());
}
}
public static User getUser(string username)
{
using (var db = new Models.ModelContext())
{
return(db.Users.Where(u => u.Username == username).FirstOrDefault());
}
}
public static Rating Select(int eventId, int userId)
{
using (var db = new Models.ModelContext())
{
return(db.Ratings.Where(s => (s.Event_id == eventId) && (s.User_id == userId)).FirstOrDefault());
}
}
public static string Update(int eventId, int state)
{
using (var db = new Models.ModelContext())
{
if (0 <= state && state < 3)
{
var currEvent = db.Events.FirstOrDefault(p => p.Id.Equals(eventId));
if (currEvent != null)
{
if (currEvent.State == (EventEnum)state)
{
return("Negalima pekeisti renginio būsenos į tokią pačia");
}
else
{
currEvent.State = (EventEnum)state;
db.Update(currEvent);
db.SaveChanges();
return("Užsakymo būsena sėkmingai atnaujinta");
}
}
else
{
return("Šis užsakymas nerastas");
}
}
else
{
return("Neteisinga užsakymo būsena");
}
}
}
public string TestDownload(int id)
{
var db = new Models.ModelContext();
var dlog = db.ImageDownloadLogSet.Find(id);
return(Helper.WechatHelper.DownloadImgFile(dlog.MediaNumber));
}
public Models.PayParms GetPayParm()
{
var prePayDic = new Dictionary <string, string>();
string openid = System.Configuration.ConfigurationManager.AppSettings["openId"];
prePayDic.Add("appid", "wx551c10a5e99a84e5");
prePayDic.Add("body", "test");
prePayDic.Add("mch_id", "10037082");
prePayDic.Add("nonce_str", "1add1a30ac87aa2db72f57a2375d8fec");
prePayDic.Add("notify_url", "http://www.baidu.com/");
prePayDic.Add("out_trade_no", "15" + DateTime.Now.Month.ToString().PadLeft(2, '0') + DateTime.Now.Day.ToString().PadLeft(2, '0') + DateTime.Now.Hour.ToString().PadLeft(2, '0') + DateTime.Now.Minute.ToString().PadLeft(2, '0') + DateTime.Now.Second.ToString().PadLeft(2, '0'));
prePayDic.Add("spbill_create_ip", "121.40.79.86");
prePayDic.Add("total_fee", "1");
prePayDic.Add("trade_type", "JSAPI");
prePayDic.Add("openid", openid);
// <appid>wx551c10a5e99a84e5</appid>
//<body>test</body>
//<mch_id>10037082</mch_id>
//<nonce_str>1add1a30ac87aa2db72f57a2375d8fec</nonce_str>
//<notify_url>http://www.baidu.com/</notify_url>
//<openid>oK7_ajtkA5qGiwrU2MNqa7vs3ttE</openid>
//<out_trade_no>out_trade_no</out_trade_no>
//<spbill_create_ip>121.40.79.86</spbill_create_ip>
//<total_fee>1</total_fee>
//<trade_type>JSAPI</trade_type>
//<sign>00492A884A794C6B3892D4406BA6DD8A</sign>
string sign = Helper.GetMD5(prePayDic);
prePayDic.Add("sign", sign);
string resStr = Helper.GerResponse(Helper.GetReqStr(prePayDic), "https://api.mch.weixin.qq.com/pay/unifiedorder");
int startIndex = resStr.IndexOf("<prepay_id><![CDATA[") + "<prepay_id><![CDATA[".Length;
int endIndex = resStr.IndexOf("]]></prepay_id>");
string prepayId = resStr.Substring(startIndex, endIndex - startIndex);
Models.PayParms pp = new Models.PayParms()
{
timeStamp = Helper.getTimestamp()
};
pp.SetPackage(prepayId);
Helper.GetMD5(ref pp);
var db = new Models.ModelContext();
var user = db.UserSet.FirstOrDefault(u => u.OpenId == openid);
if (user != null)
{
user.Balance += 0.01;
db.SaveChanges();
}
return(pp);
}
public static string Delete(int promotionId)
{
using (var db = new Models.ModelContext())
{
var currPromotion = db.Promotions.FirstOrDefault(p => p.Id.Equals(promotionId));
db.Promotions.Attach(currPromotion);
db.Promotions.Remove(currPromotion);
db.SaveChanges();
return("Sėkmingai pašalinta reklama");
}
}
public static string GetEventString(string toUser, string fromUser, string key)
{
var db = new Models.ModelContext();
var code = db.TwoDCodeSet.Include("Event").FirstOrDefault(c => c.EventNumber == key);
if (code != null)
{
//关注事件
if (code.Event.EeventType == Models.WechatEventType.Subscribe)
{
var msgList = db.ImgMsgListSet.FirstOrDefault(ml => ml.ImgMsgListId == code.Event.ImgMsgListId);
if (msgList != null)
{
return(msgList.GetWechatString(toUser, fromUser));
}
else
{
return("");
}
}
else if (code.Event.EeventType == Models.WechatEventType.BeSalesman)
{
var salesman = db.SalesmanSet.FirstOrDefault(s => s.EventId == code.EventId);
if (salesman != null)
{
var user = db.UserSet.FirstOrDefault(u => u.OpenId == toUser);
if (user != null)
{
salesman.UserId = user.UserId;
db.SaveChanges();
return(GetTextMsg("注册经销商成功！", toUser, fromUser));
}
else
{
return("");
}
}
else
{
return("");
}
}
else
{
return("");
}
}
else
{
return("");
}
}
public static double GetRating(int eventId)
{
using (var db = new Models.ModelContext())
{
int avgRating = 0;
var ratings = db.Ratings.Where(s => s.Event_id == eventId).ToList();
foreach (var rating in ratings)
{
avgRating += rating.Score;
}
return((double)avgRating / ratings.Count());
}
}
public static Tuple <Promotion, string, string> Select(int promotionId)
{
using (var db = new Models.ModelContext())
{
string eventName = "Nėra";
string organizerName = "Nėra";
Promotion promotion = db.Promotions.FirstOrDefault(p => p.Id.Equals(promotionId));
if (promotion != null)
{
organizerName = db.Users.FirstOrDefault(u => u.Id.Equals(promotion.User_id)).Username;
eventName = db.Events.FirstOrDefault(e => e.Id.Equals(promotion.Event_id)).Name;
}
return(new Tuple <Promotion, string, string>(promotion, organizerName, eventName));
}
}
public static Tuple <string, bool> Insert(int eventId, int userId, int ratingValue)
{
using (var db = new Models.ModelContext())
{
var currEvent = db.Events.Where(e => e.Id.Equals(eventId));
var currUser = db.Users.Where(u => u.Id.Equals(userId));
// If any of the elements are not present in db
if (!(currEvent.Any() && currUser.Any()))
{
return(new Tuple <string, bool>("Atleiskite, įvyko klaida", false));
}
var rating = db.Ratings.Where(s => (s.Event_id == eventId) && (s.User_id == userId));
if (!Validate(ratingValue))
{
return(new Tuple <string, bool>("Jūsų įvertinimas yra netinkamas", false));
}
else if (rating.Any())
{
foreach (var score in rating)
{
score.Score = ratingValue;
}
db.SaveChanges();
return(new Tuple <string, bool>("Jūsų įvertinimas pakeistas", false));
}
else
{
var newRating = new Models.Rating();
newRating.Event_id = eventId;
newRating.User_id = userId;
newRating.Score = ratingValue;
db.Ratings.Add(newRating);
db.SaveChanges();
return(new Tuple <string, bool>("Renginys sėkmingai įvertintas.", true));
}
}
}
public IActionResult Register(string email, string username, string password, string role)
{
//norint kreiptis i DB reikia sukurti konteksta sitaip
using (var db = new Models.ModelContext())
{
if (email != null && username != null && password != null && role != null)
{
Models.User user = new Models.User();
user.Username = username;
user.Password = password;
if (role == "admin")
{
user.Type = Models.UserType.admin;
}
else if (role == "organizer")
{
user.Type = Models.UserType.organizer;
}
else if (role == "participant")
{
user.Type = Models.UserType.participant;
}
else
{
return(View("~/Views/Shared/Register.cshtml"));
}
db.Add(user); //pridedam elementa i db
db.SaveChanges(); //pridejus reikia daryti saveChanges
}
else
{
return(View("~/Views/Shared/Register.cshtml"));
}
}
ViewData["Title"] = "Login page";
return(View("~/Views/Shared/Login.cshtml"));
}
public static List <Event> SelectList(string option)
{
using (var db = new Models.ModelContext())
{
if (option == null || option.Equals(""))
{
return(db.Events.ToList());
}
else if (option.Equals("ended"))
{
var currDate = DateTime.Today;
return(db.Events.Where(e => e.Date < currDate).ToList());
}
else if (option.Equals("upcoming"))
{
var currDate = DateTime.Today;
return(db.Events.Where(e => e.Date >= currDate).ToList());
}
else
{
return(new List <Event>());
}
}
}
public static List <Tuple <Promotion, string, string> > SelectList(int option, int option2)
{
using (var db = new Models.ModelContext())
{
if (option2 == (int)Models.UserType.admin)
{
if (0 <= option && option < 3)
{
var list = (from pr in db.Promotions
join usr in db.Users on pr.User_id equals usr.Id
join ev in db.Events on pr.Event_id equals ev.Id
where pr.State == (OrderState)option
select new Tuple <Promotion, string, string>
(
pr,
usr.Username,
ev.Name
)
).ToList();
return(list);
}
else
{
var list = (from pr in db.Promotions
join usr in db.Users on pr.User_id equals usr.Id
join ev in db.Events on pr.Event_id equals ev.Id
select new Tuple <Promotion, string, string>
(
pr,
usr.Username,
ev.Name
)
).ToList();
return(list);
}
}
else
{
if (0 <= option && option < 3)
{
var list = (from pr in db.Promotions
join usr in db.Users on pr.User_id equals usr.Id
join ev in db.Events on pr.Event_id equals ev.Id
where pr.State == (OrderState)option
where usr.Id == option2
select new Tuple <Promotion, string, string>
(
pr,
usr.Username,
ev.Name
)
).ToList();
return(list);
}
else
{
var list = (from pr in db.Promotions
join usr in db.Users on pr.User_id equals usr.Id
join ev in db.Events on pr.Event_id equals ev.Id
where usr.Id == option2
select new Tuple <Promotion, string, string>
(
pr,
usr.Username,
ev.Name
)
).ToList();
return(list);
}
}
}
}