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