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);