public static string Registration(string number, string input)
{
db = new SMSDataClassesDataContext();
string returnMessage = replyMessage("NREG", "NOK0");
if (checkNumber(number))
{
return "Oop, Your number already exist to our record!Pleas try a new number";
}
if (checkCode(populate(input)))
{
string refCode = "CIA" + config.generateReferenceNo(4) + "-" + DateTime.Now.Year;
SMS_Member m = new SMS_Member();
m.ReferenceNo = refCode;
m.Group_Name = "BAYANIHAN";
m.Account_Number = number;
m.Family_Name = Lastname;
m.First_Name = Firstname;
m.Town = Town;
m.Sponsor_ID = Sponsor;
m.CP_Number = number;
m.DateReg = config.receivedDateTime();
m.Status = true;
m.monthOf = DateTime.Now.Month;
m.yearOf = DateTime.Now.Year;
SMS_eMoney e = new SMS_eMoney();
e.Account = number;
e.Amount = 100;
e.Status = true;
if (!checkRef(refCode))
{
try
{
db.SMS_Members.InsertOnSubmit(m);
db.SMS_eMoneys.InsertOnSubmit(e);
db.SubmitChanges();
returnMessage = replyMessage("NREG", "OK", Firstname);
}
catch (Exception ex)
{
return "Sorry, our system has encountered an error, please try again later. thank you!";
}
}
else
{
returnMessage = replyMessage("NREG", "NOK1");
}
}
return returnMessage;
}
public static double current_amount(string account)
{
db = new SMSDataClassesDataContext();
var acnt = (from i in db.SMS_eMoneys.Where(i => i.ID == id(account)) select i).Take(1).FirstOrDefault();
if (acnt != null)
{
isNotExist = true;
return (double)acnt.Amount;
}
isNotExist = false;
return 0;
}
public static bool now()
{
db = new SMSDataClassesDataContext();
var que = (from i in db.SMS_QueuedBoxes.Where(i => i.Status == false) select i).Take(1).FirstOrDefault();
if (que != null)
{
if (config.getLastDigit(que.Number, config.outBound))
{
Id = que.ID;
Number = que.Number;
Message = config.decrypt(que.Message);
return true;
}
}
return false;
}
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.generateReferenceNo(6);
if (balance.current_amount(number) >= d)
{
if (!IsRef_Exist(ReferenceNo))
{
balance.update(Sender, balance.deduct(Sender, d));
if (save("sender", (decimal)d, ReferenceNo))
{
report("sender", d.ToString());
}
balance.update(Receiver, balance.increase(Receiver, d));
if (save("receiver", (decimal)d, ReferenceNo))
{
report("receiver", ReferenceNo);
}
}
}
else
{
save("insufficient");
}
}
else
{
save("receiver_notExist");
}
}
else
{
save("Sender_notExist");
}
return "OK";
}
static string check_If_open(DateTime value)
{
db = new SMSDataClassesDataContext();
try
{
var x = (from i in db.SMS_BayanihanSums.Where(i => i.open_started >= value && value <= i.closing_time)
select i).Take(1).FirstOrDefault();
if (x != null)
{
return x.bayanihan_ref;
}
return "Closed";
}
catch (Exception ex)
{}
return "not available at this time!";
}
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();
config.log("Successful deleted in inbox");
return true;
}
catch (Exception ex)
{
config.log(ex.Message);
return false;
}
}
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)
{
config.log(ex.Message);
}
}
return false;
}
public static bool save(string number, string message)
{
db = new SMSDataClassesDataContext();
SMS_Inbox inbox = new SMS_Inbox();
SMS_ReceivedMsg receivedMsg = new SMS_ReceivedMsg();
inbox.Sender = number;
inbox.Message = message;
inbox.DateReceived = config.receivedDateTime();
inbox.MonthOf = DateTime.Now.Month;
inbox.YearOf = DateTime.Now.Year;
inbox.Status = false;
receivedMsg.Sender = number;
receivedMsg.Message = message;
receivedMsg.DateReceived = config.receivedDateTime();
receivedMsg.MonthOf = DateTime.Now.Month;
receivedMsg.YearOf = DateTime.Now.Year;
receivedMsg.Status = false;
validatorMessage.save(number, "Sorry, your message cannot be processed at this time, " +
"but your message is on queue. and it will process later. thank you!");
try
{
db.SMS_Inboxes.InsertOnSubmit(inbox);
db.SMS_ReceivedMsgs.InsertOnSubmit(receivedMsg);
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
config.log(ex.Message);
return false;
}
}
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";
}
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.receivedDateTime();
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();
config.log("Successful updated in inbox");
return true;
}
catch (Exception ex)
{
config.log(ex.Message);
}
}
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;
}
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;
}
static bool checkNumber(string number)
{
db = new SMSDataClassesDataContext();
var member = (from i in db.SMS_Members.Where(i => i.CP_Number == number) select i).Take(1).FirstOrDefault();
var money = (from i in db.SMS_eMoneys.Where(i => i.Account == number) select i).Take(1).FirstOrDefault();
if (member != null || money != null)
{
return true;
}
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 IsRef_Exist(string input)
{
db = new SMSDataClassesDataContext();
var refNo = (from i in db.SMS_TransferFundReports.Where(i => i.ReferenceNo == input) select i).Take(1).FirstOrDefault();
if (refNo != null)
{
return true;
}
return false;
}
