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;
}
partial void UpdateSMS_eMoney(SMS_eMoney instance);
partial void DeleteSMS_eMoney(SMS_eMoney instance);
partial void InsertSMS_eMoney(SMS_eMoney instance);