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 bool saveNew(string refno, string group, string account, string lname, string fname,
string city, string province, int sec1, int sec2, string sponsor, string number)
{
short _sec1 = (short)sec1;
short _sec2 = (short)sec2;
SMS_Member sm = new SMS_Member();
sm.ReferenceNo = refno;
sm.Group_Name = group;
sm.Account_Number = account;
sm.Family_Name = lname;
sm.First_Name = fname;
sm.Town = city;
sm.Province = province;
sm.Sponsor_ID = sponsor;
sm.CP_Number = number;
sm.Section_A = _sec1;
sm.Section_B = _sec2;
sm.DateReg = HelpController.DateFormat(DateTime.Now.Month + "/" + DateTime.Now.Day + "/" + DateTime.Now.Year + " " + DateTime.Now.ToShortTimeString());
sm.monthOf = DateTime.Now.Month;
sm.yearOf = DateTime.Now.Year;
sm.Status = true;
try
{
db.SMS_Members.InsertOnSubmit(sm);
var emoney = db.SMS_eMoneys.Where(x => x.Account == number).FirstOrDefault();
if (emoney == null)
{
SMS_eMoney money = new SMS_eMoney();
money.Account = number;
money.Amount = Convert.ToDecimal(100.00);
money.Status = true;
db.SMS_eMoneys.InsertOnSubmit(money);
}
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
partial void UpdateSMS_Member(SMS_Member instance);
partial void DeleteSMS_Member(SMS_Member instance);
partial void InsertSMS_Member(SMS_Member instance);
