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 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"; }
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 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 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 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); }
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; }
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; }
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!"; }