/// <summary> /// 根据用户名获取一个用户实体对象 /// </summary> /// <param name="username">用户名</param> /// <returns>用户实体</returns> public static tb_User GetOneUserEntity(string username) { using (SMSDataClassesDataContext dc = new SMSDataClassesDataContext(_dbConnString)) { var user = dc.tb_Users.Where(u => u.UserName.Trim().ToLower().Equals(username.Trim().ToLower())).FirstOrDefault(); return(user); } }
protected void Page_Load(object sender, EventArgs e) { db = new SMSDataClassesDataContext(); gvbayanihan.DataSource = dataGridContoller.populate(dataGridContoller.Damayan); gvbayanihan.DataBind(); var _totaldon = (from i in db.SMS_BayanihanSums.Where(i => i.status == "Closed" || i.status == "Open") select i.donation).Sum(); var _totalwin = (from i in db.SMS_BayanihanSums.Where(i => i.status == "Closed" || i.status == "Open") select i.total_win_amount).Sum(); if (totaldon != null && totalwin != null) { totaldon = (decimal)_totaldon; totalwin = (decimal)_totalwin; txtTotalDon.Text = config.format_currency(totaldon) + "Php"; lblTotalWin.Text = config.format_currency(totalwin) + "Php"; } else { txtTotalDon.Text = "0.00Php"; lblTotalWin.Text = "0.00Php"; } decimal xtotal = totaldon - totalwin; if (xtotal < 0) { lblTotalRem.Text = "<span style='color: #f61f33;'>" + xtotal + "Php</span>"; } else { lblTotalRem.Text = xtotal + "Php"; } }
public static bool Transaction(string account, string referenceNo, decimal amount, bool IsDeposit, int status) { db = new SMSDataClassesDataContext(); SMS_VirtualMoney vMoney = new SMS_VirtualMoney(); vMoney.refno = referenceNo; vMoney.account = account; if (IsDeposit){ vMoney.type = 21; } else{ vMoney.type = 22; } vMoney.amount = amount; vMoney.status = status; vMoney.datetime = config.current_DateTime(); try{ db.SMS_VirtualMoneys.InsertOnSubmit(vMoney); db.SubmitChanges(); return true; } catch (Exception ex){ } return false; }
public static bool now(string launcher_id) { db = new SMSDataClassesDataContext(); try { var receivedMsg = (from i in db.SMS_ReceivedMsgs.Where(i => i.Status == false) select i).Take(1).FirstOrDefault(); if (receivedMsg != null) { switch (config.prefixes(receivedMsg.Sender)) { case 5: delete(receivedMsg.Id); break; case 4: delete(receivedMsg.Id); break; default: keyword.check(receivedMsg.Sender, receivedMsg.Message, launcher_id); delete(receivedMsg.Id); break; } return true; } } catch (Exception ex) { } return false; }
static void populate(int month, string type) { db = new SMSDataClassesDataContext(); var get = (from i in db.SMS_Members.Where(i => i.monthOf == month && i.yearOf == DateTime.Now.Year) select i).Count(); switch (type) { case "inbox" : get = (from i in db.SMS_Inboxes.Where(i => i.MonthOf == month && i.YearOf == DateTime.Now.Year) select i).Count(); break; case "sentItem": get = (from i in db.SMS_SentItems.Where(i => i.MonthOf == month && i.YearOf == DateTime.Now.Year) select i).Count(); break; case "registered": get = (from i in db.SMS_Members.Where(i => i.monthOf == month && i.yearOf == DateTime.Now.Year) select i).Count(); break; } switch (month) { case 1: Memory = get.ToString() + ", "; break; case 2: Memory += get.ToString() + ", "; break; case 3: Memory += get.ToString() + ", "; break; case 4: Memory += get.ToString() + ", "; break; case 5: Memory += get.ToString() + ", "; break; case 6: Memory += get.ToString() + ", "; break; case 7: Memory += get.ToString() + ", "; break; case 8: Memory += get.ToString() + ", "; break; case 9: Memory += get.ToString() + ", "; break; case 10: Memory += get.ToString() + ", "; break; case 11: Memory += get.ToString() + ", "; break; case 12: Memory += get.ToString(); break; } }
public static string Registration(string number, string input, string launcher_id) { db = new SMSDataClassesDataContext(); if (checkNumber(number)) { process.save(number, "Oop, Your number already exist to our record!PleasE try a new number"); return "OK"; } if (checkCode(populate(input, launcher_id))) { string MemberName = string.Empty; string refCode = "CIA" + number.Substring(1, 10) + "-" + DateTime.Now.Year + "-" + DateTime.Now.Month; SMS_Member m = new SMS_Member(); m.ReferenceNo = refCode; foreach (var l in objList) { MemberName = l.Firstname; m.Group_Name = l.Group; m.Account_Number = number; m.Family_Name = l.Lastname.ToUpper(); m.First_Name = l.Firstname.ToUpper(); m.Town = l.Town.ToUpper(); m.Province = l.Province.ToUpper(); m.Sponsor_ID = l.Sponsor; m.CP_Number = number; m.Section_A = (short)l.Section_a; m.Section_B = (short)l.Section_b; m.Pin_Code = l.Pin; } m.DateReg = config.current_DateTime(); m.Status = true; m.monthOf = DateTime.Now.Month; m.yearOf = DateTime.Now.Year; try { db.SMS_Members.InsertOnSubmit(m); db.SubmitChanges(); balance.Transaction(number, "CIA00001", 100, true, 25); process.save(number, replyMessage("NREG", "OK", MemberName)); return "OK"; } catch (Exception ex) { process.save(number, "Sorry, our system has encountered an error, please try again later. thank you!"); return "OK"; } } process.save(number, replyMessage("NREG", "NOK0")); return "OK"; }
static string city_selected() { db = new SMSDataClassesDataContext(); var g = (from i in db.SMS_WeatherForecasts.Where(i => i.selected == true) select i).Take(1).FirstOrDefault(); if (g != null) { return g.weather_code; } return "NULL"; }
protected void Page_Load(object sender, EventArgs e) { db = new SMSDataClassesDataContext(); string view = "all"; if (Request.QueryString["ref"] != null) { if (Request.QueryString["l"] != null) { view = Request.QueryString["l"]; } gvbayanihan_list.DataSource = dataGridContoller.populate(dataGridContoller.Damayan_List(Request.QueryString["ref"], view)); gvbayanihan_list.DataBind(); var total = (from i in db.SMS_BayanihanSums.Where(i => i.bayanihan_ref == Request.QueryString["ref"]) select i).Take(1).FirstOrDefault(); if (total != null) { totaldon = (decimal)total.donation; totalwin = (decimal)total.total_win_amount; txtTotalDon.Text = config.format_currency(totaldon) + "Php"; lblTotalWin.Text = config.format_currency(totalwin) + "Php"; if (total.donation != 0) { lbUpdate.Visible = true; } if (total.status == "Closed") { tbl_total.Visible = true; lbUpdate.Visible = false; links_id.Visible = true; } } decimal xtotal = totaldon - totalwin; if (xtotal < 0) { lblTotalRem.Text = "<span style='color: #f61f33;'>" + xtotal + "Php</span>"; } else { lblTotalRem.Text = xtotal + "Php"; } string refUrl = Request.QueryString["ref"]; _all.Attributes.Add("href", "bayanihan_damayan_list.aspx?ref=" + refUrl); _winners.Attributes.Add("href", "bayanihan_damayan_list.aspx?ref=" + refUrl + "&l=Winner"); } else { Response.Redirect("bayanihan_damayan.aspx"); } }
public void populate(string id) { db = new SMSDataClassesDataContext(); var x = (from i in db.SMS_Users.Where(i => i.ID == Convert.ToInt32(id)) select i).Take(1).FirstOrDefault(); if (x != null) { txtUsername.Text = x.admin; txtEmail.Text = x.email; ddlRole.Text = x.role; } }
public static string now(string number, string message) { db = new SMSDataClassesDataContext(); string bayanihan = check_If_open(config.current_DateTime()); if (IsSender_Exist(number)) { if (bayanihan == "Closed" || bayanihan == "NULL") { process.save(number, "U hav reached the cut offtime to donate. ur entry isn't valid. try donating after 11pm 4 da nxt draw. Thank you!"); return "OK"; } string[] x = message.Split(' '); string[] y = x[1].Split('/'); Donation = Convert.ToDouble(y[0]); Combination = y[1]; string refCode = config.current_DateTime().ToString("MMdd") + config.generateReferenceNo(4); if (balance.current_amount(number) >= Donation) { SMS_Bayanihan b = new SMS_Bayanihan(); b.refNo = refCode; b.bayanihan_ref = bayanihan; b.donator = number; b.combination = Combination; b.donation = (decimal)Donation; b.date_danated = config.current_DateTime(); b.status = "-"; try { db.SMS_Bayanihans.InsertOnSubmit(b); db.SubmitChanges(); sqlServer.Update("UPDATE SMS_BayanihanSum SET played = '" + count_donators(bayanihan) + "', " + "donation = '" + total_donation(bayanihan) + "' " + "WHERE bayanihan_ref = '" + bayanihan + "' AND status = 'Open';"); balance.Transaction(number, refCode, (decimal)Donation, false, 24); process.save(number, reply("OK").Replace("[AMOUNT]", Donation.ToString()).Replace("[COMBINATION]", Combination).Replace("[BALANCE]", config.format_currency((decimal)balance.current_amount(number))).Replace("[REFNO]", refCode)); return "OK"; } catch (Exception ex) { process.save(number, "The system is not available at this time, please try again later"); return "OK"; } } process.save(number, "Transaction cannot be processed because do to insufficient funds, to donate please reload now."); return "OK"; } process.save(number, "You are not registerd in our record, please register first! thank you..."); return "OK"; }
public static bool check_role(string role) { db = new SMSDataClassesDataContext(); var x = (from i in db.SMS_Accessibilities.Where(i => i.role == role) select i).ToList(); foreach (var l in x) { if (l.access == "users") { return true; } } return false; }
public static string Get_Access_Token(string email, string password) { db = new SMSDataClassesDataContext(); var result = (from i in db.SMS_DevelopersAccounts.Where(i => i.email == email) select i).ToList(); foreach (var m in result) { if (config.decrypt(m.password) == password) { Secret_Access_ID = m.secret_id; return m.access_token; } } return "Invalid developers account"; }
public static bool delete(long id) { db = new SMSDataClassesDataContext(); var x = (from i in db.SMS_ReceivedMsgs.Where(i => i.Id == id) select i).Take(1).FirstOrDefault(); try { db.SMS_ReceivedMsgs.DeleteOnSubmit(x); db.SubmitChanges(); return true; } catch (Exception ex) {} return false; }
public static double current_amount(string account) { db = new SMSDataClassesDataContext(); var acnt = ( from d in db.SMS_VirtualMoneys.Where(d => d.type == 21 && d.account == account) select d.amount ).Sum() - ( from d in db.SMS_VirtualMoneys.Where(d => d.type == 22 && d.account == account) select d.amount ).Sum(); return (double)acnt; }
protected void Page_Load(object sender, EventArgs e) { db = new SMSDataClassesDataContext(); gvtransferfundsreport.DataSource = dataGridContoller.populate(dataGridContoller.Tfreports); gvtransferfundsreport.DataBind(); var total = (from i in db.SMS_TransferFundReports.Select(i => i.Amount) select i).Sum(); if (total != null) { decimal x = (decimal)total; txtTotal.Text = config.format_currency(x) + "Php"; } else { txtTotal.Text = "0.00Php"; } }
public objectList GetAllMessage() { db = new SMSDataClassesDataContext(); objectList l = new objectList(); var que = (from i in db.SMS_QueuedBoxes.Where(i => i.Status == false) select i).ToList(); if (que != null) { foreach (var q in que) { objectName c = new objectName(); c.Id = q.ID; c.Number = q.Number; c.Message = config.decrypt(q.Message); l.Add(c); } return l; } return null; }
public static string now(string number, string input) { db = new SMSDataClassesDataContext(); Sender = number; if (IsSender_Exist(Sender)) { string[] split = input.Split(' '); Receiver = split[1]; if (IsSender_Exist(Receiver)) { double d = Convert.ToDouble(split[2]); ReferenceNo = config.current_DateTime().ToString("MMdd") + config.generateReferenceNo(4); if (balance.current_amount(number) >= d) { if (!IsRef_Exist(ReferenceNo)) { // Widthraw from sender balance.Transaction(Sender, ReferenceNo, (decimal)d, false, 23); save("sender", (decimal)d, ReferenceNo); // Deposit to receiver balance.Transaction(Receiver, ReferenceNo, (decimal)d, true, 23); save("receiver", (decimal)d, ReferenceNo); } } else { save("insufficient"); } } else { save("receiver_notExist"); } } else { save("Sender_notExist"); } return "OK"; }
public static bool toQueuedbox(string number, string message, short net) { db = new SMSDataClassesDataContext(); SMS_QueuedBox que = new SMS_QueuedBox(); que.Number = number; que.Message = config.encrypt(message); que.Network = net; que.Status = false; try { db.SMS_QueuedBoxes.InsertOnSubmit(que); db.SubmitChanges(); return true; } catch (Exception ex) { return false; } }
public void save(string newCode) { try { SMSDataClassesDataContext db = new SMSDataClassesDataContext(); SMS_ActivationCode sm; var chk = (from c in db.SMS_ActivationCodes.Where(c => c.PINCode == newCode) select c.PINCode).FirstOrDefault(); if (chk == null) { sm = new SMS_ActivationCode(); sm.PINCode = newCode; sm.Status = true; db.SMS_ActivationCodes.InsertOnSubmit(sm); db.SubmitChanges(); Console.Write("<br />" + newCode); } } catch (Exception ex) { } }
public static bool save(string number, string message, string launcher_id, bool process_now = false) { db = new SMSDataClassesDataContext(); SMS_Inbox inbox = new SMS_Inbox(); SMS_ReceivedMsg receivedMsg = new SMS_ReceivedMsg(); inbox.Sender = number; inbox.Message = message; inbox.DateReceived = config.current_DateTime(); inbox.MonthOf = DateTime.Now.Month; inbox.YearOf = DateTime.Now.Year; inbox.Status = false; receivedMsg.Sender = number; receivedMsg.Message = message; receivedMsg.DateReceived = config.current_DateTime(); receivedMsg.MonthOf = DateTime.Now.Month; receivedMsg.YearOf = DateTime.Now.Year; receivedMsg.Status = false; try { db.SMS_Inboxes.InsertOnSubmit(inbox); db.SMS_ReceivedMsgs.InsertOnSubmit(receivedMsg); db.SubmitChanges(); if (process_now) { process.now(launcher_id); } return true; } catch (Exception ex) { return false; } }
protected void btnSearchAccount_Click(object sender, EventArgs e) { if (txtSeachAccount.Text != "Enter Act#, Ref# or Num") { if (txtSeachAccount.Text != string.Empty) { db = new SMSDataClassesDataContext(); var getId = (from u in db.SMS_Members.Where(u => u.CP_Number == txtSeachAccount.Text || u.Account_Number == txtSeachAccount.Text || u.ReferenceNo == txtSeachAccount.Text) select u.ID).Take(1).FirstOrDefault(); if (getId != 0) { Response.Redirect("members.aspx?id=" + getId.ToString()); } } else { Response.Redirect("members.aspx?e=null"); } } else { Response.Redirect("members.aspx?e=no_given_value"); } }
protected void btnProceed_Click(object sender, EventArgs e) { db = new SMSDataClassesDataContext(); string refNo = Request.QueryString["ref"].Trim(); string winCode = txtWinCode.Text.Trim(); SMS_BayanihanSum d = new SMS_BayanihanSum(); d.bayanihan_ref = "BD" + DateTime.Now.AddDays(1).ToString("Mddyyyy"); d.played = 0; d.donation = 0; d.combination_no_win = "-"; d.total_win = 0; d.total_win_amount = 0; d.open_started = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " 01:00:00.000"); d.closing_time = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " 18:00:00.000"); d.status = "Open"; sqlServer.Update("UPDATE SMS_Bayanihan SET " + "status = 'Winner'" + "WHERE bayanihan_ref = '" + refNo + "' AND combination = '" + winCode + "'"); sqlServer.Update("UPDATE SMS_BayanihanSum SET " + "combination_no_win = '" + winCode + "', " + "total_win = '" + totalWon(refNo, winCode) + "', " + "total_win_amount = '" + wonAllTotalAmount(refNo, winCode) + "', " + "status = 'Closed' " + "WHERE bayanihan_ref = '" + refNo + "'"); try { db.SMS_BayanihanSums.InsertOnSubmit(d); db.SubmitChanges(); } catch (Exception ex) { } Response.Redirect(HelpController.Refresh); }
private string add_user() { db = new SMSDataClassesDataContext(); SMS_User u = new SMS_User(); u.admin = txtUsername.Text; u.password = config.encrypt(txtPassword.Text); u.email = txtEmail.Text; u.role = ddlRole.SelectedValue; u.date_added = config.current_DateTime(); u.added_by = Session["user"].ToString(); try { db.SMS_Users.InsertOnSubmit(u); db.SubmitChanges(); config.send_email("User Account", config.email_UsernameAndPassword("User Account", txtUsername.Text, txtPassword.Text), txtEmail.Text); return txtUsername .Text + " was successfully added!"; } catch (Exception ex) { } return txtUsername.Text + " wasn't successfully added!"; }
static bool checkNumber(string number) { db = new SMSDataClassesDataContext(); var member = (from i in db.SMS_Members join e in db.SMS_eMoneys on i.CP_Number equals e.Account where i.CP_Number == number || e.Account == number select i).Take(1).FirstOrDefault(); if (member != null) { return true; } return false; }
static string check_If_open(DateTime value) { db = new SMSDataClassesDataContext(); try { string query = "SELECT " + "bayanihan_ref, " + "CONVERT(DATE, open_started) AS 'OPEN DATE', " + "CONVERT(TIME, open_started) AS 'OPEN TIME', " + "CONVERT(TIME, closing_time) AS 'CLOSING TIME', " + "CONVERT(DATE, GETDATE()) AS 'GET DATE', " + "CONVERT(TIME, GETDATE() ) AS 'GET TIME' " + "FROM SMS_BayanihanSum " + "WHERE CONVERT(DATE, open_started) = CONVERT(DATE, GETDATE()) " + "AND CONVERT(TIME, open_started) <= CONVERT(TIME, GETDATE()) " + "AND CONVERT(TIME, closing_time) >= CONVERT(TIME, GETDATE());"; string stat = sqlServer.DateTime(query); if (stat != "NULL") { return stat; } return "Closed"; } catch (Exception ex) { } return "not available at this time!"; }
public static bool save(string number, string message) { if (message != "OK") { db = new SMSDataClassesDataContext(); SMS_QueuedBox que = new SMS_QueuedBox(); que.Message = config.encrypt(message); que.Number = number; que.Network = (short)config.prefixes(number); que.Status = false; try { db.SMS_QueuedBoxes.InsertOnSubmit(que); db.SubmitChanges(); return true; } catch (Exception ex) { } } return false; }
static string replyMessage(string tag, string status, string optional = "") { string reply = "Sorry, our system has encountered an error, please try again later. thank you!"; db = new SMSDataClassesDataContext(); var rep = (from i in db.SMS_Replies.Where(i => i.Tagged_ID == tag && i.Status == status) select i).Take(1).FirstOrDefault(); if (rep != null) { if (status == "OK") { reply = rep.Message.Replace("[Firstname]", optional); } else { reply = rep.Message; } } return reply; }
protected void Page_Load(object sender, EventArgs e) { db = new SMSDataClassesDataContext(); Response.Cache.SetCacheability(HttpCacheability.NoCache); if (Session["user"] != null) { Response.Redirect("../dashboard.aspx"); } if (Session["send-password"] != null) { lblerr.Text = Session["send-password"].ToString(); Session["send-password"] = null; } lblerr.Text = Guid.NewGuid().ToString(); }
public static bool saveToSentItemThenDelete(long id, bool status) { db = new SMSDataClassesDataContext(); SMS_SentItem sentItems = new SMS_SentItem(); var x = (from i in db.SMS_QueuedBoxes.Where(i => i.ID == id) select i).Take(1).FirstOrDefault(); if (x != null) { sentItems.Number = x.Number; sentItems.Message = x.Message; sentItems.DateTime = config.current_DateTime(); sentItems.Status = status; sentItems.MonthOf = DateTime.Now.Month; sentItems.YearOf = DateTime.Now.Year; try { db.SMS_SentItems.InsertOnSubmit(sentItems); db.SMS_QueuedBoxes.DeleteOnSubmit(x); db.SubmitChanges(); return true; } catch (Exception ex) {} } return false; }
static bool checkCode(string input) { db = new SMSDataClassesDataContext(); var code = (from i in db.SMS_ActivationCodes.Where(i => i.PINCode == input && i.Status == true) select i).Take(1).FirstOrDefault(); if (code != null) { return code.Status; } return false; }
static bool checkRef(string input) { db = new SMSDataClassesDataContext(); var refNo = (from i in db.SMS_Members.Where(i => i.ReferenceNo == input) select i).Take(1).FirstOrDefault(); if (refNo != null) { return true; } return false; }