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_Member(SMS_Member instance);
partial void DeleteSMS_Member(SMS_Member instance);
partial void InsertSMS_Member(SMS_Member instance);