예제 #1
0
        public IHttpActionResult GetLoginUsers(LoginModel loginModel)
        {
            string sqlQuery     = "";
            string resultString = "";

            try
            {
                if (loginModel.Email != null || loginModel.Password != "")
                {
                    sqlQuery = "select CusID from Custrecords where Email='" + loginModel.Email + "' and Cust_Password='******' ";
                    sdr      = Concls.GetdataReader(sqlQuery);
                    if (sdr.HasRows)
                    {
                        if (sdr.Read())
                        {
                            resultString = sdr["CusID"].ToString();
                        }
                        else
                        {
                            resultString = "";
                        }
                    }
                    else
                    {
                        resultString = "";
                    }
                    sdr.Close();

                    if (string.IsNullOrEmpty(resultString))
                    {
                        resultString = "false";
                    }
                    else
                    {
                        resultString = "true";
                    }

                    return(Ok(resultString));
                }
                else
                {
                    return(Ok("Something went Wrong..."));
                }
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }
        public bool CheckSecurityPin(string SecurityPin)
        {
            string Type     = "Registration";
            bool   flag     = false;
            string OTP_Code = "";

            if (SecurityPin == "")
            {
                SecurityPin = "0";
            }
            SqlDataReader sdr = conCls.GetdataReader("Select OTP_Code from OTP_data_Code Where  Status=0 AND Type='" + Type + "' AND OTP_Code=" + SecurityPin);

            if (sdr.HasRows)
            {
                if (sdr.Read())
                {
                    OTP_Code = sdr["OTP_Code"].ToString();
                }
            }
            sdr.Close();
            sdr.Dispose();

            if (OTP_Code == "")
            {
                flag = false;
            }
            else
            {
                string sessvalue = OTP_Code;
                if (sessvalue == SecurityPin)
                {
                    flag = true;
                }
                else
                {
                    flag = false;
                }
            }
            return(flag);
        }
예제 #3
0
        public IHttpActionResult RegisterMailConfirmation(string otpcode)
        {
            try
            {
                decryption Decryption = new decryption();
                if (!string.IsNullOrEmpty(otpcode))
                {
                    checksecuritypin checksecuritypin = new checksecuritypin();

                    if (!checksecuritypin.CheckSecurityPin(otpcode))
                    {
                        user.ErrorCode    = 0;
                        user.ErrorMessage = "false";
                        //return Ok("error: invalid_otp_code");
                    }
                    else if (checksecuritypin.CheckSecurityPin(otpcode) == false)
                    {
                        user.ErrorCode    = 0;
                        user.ErrorMessage = "false";
                        //return Ok("error: invalid_otp_code");
                    }
                    else
                    {
                        string        custid = "";
                        SqlDataReader sdr    = conCls.GetdataReader("Select CustID from OTP_data_Code Where  Status=0 AND Type='Registration' AND OTP_Code=" + otpcode);
                        if (sdr.HasRows)
                        {
                            if (sdr.Read())
                            {
                                custid = sdr["CustID"].ToString();
                            }
                        }
                        sdr.Close();
                        sdr.Dispose();

                        int flag = 0; string errMsg = "0";
                        conCls.verification_byregistration(custid, out flag, out errMsg);
                        string NewID = "";
                        NewID = flag.ToString();

                        if (NewID.Length > 4)
                        {
                            string regsucc = "";
                            regsucc = errMsg.ToString().Trim();
                            if (regsucc.ToString() == "SUCCESS")
                            {
                                string _Cust_Name = "";
                                string _email     = "";
                                string _username  = "";
                                string sqlStr1    = "";


                                sqlStr1 = "SELECT Cust_UserName, Email, cusid, cust_name from CustRecords_preReg where cusid = " + custid;
                                SqlDataReader sdr1 = conCls.GetdataReader(sqlStr1);
                                if (sdr1.HasRows)
                                {
                                    if (sdr1.Read())
                                    {
                                        _username  = sdr1["Cust_UserName"].ToString();
                                        _email     = sdr1["Email"].ToString();
                                        _Cust_Name = sdr1["cust_name"].ToString();
                                    }
                                    else
                                    {
                                        user.ErrorCode    = 0;
                                        user.ErrorMessage = "false";
                                        //return Ok("error: record_not_available");
                                    }
                                }
                                else
                                {
                                    user.ErrorCode    = 0;
                                    user.ErrorMessage = "false";
                                    //return Ok("error: record_not_available");
                                }

                                sdr1.Close();
                                sdr1.Dispose();

                                SendSMS(NewID, _Cust_Name, _email, _username);
                                user.ErrorCode    = 1;
                                user.ErrorMessage = "true";
                                return(Ok(registrationmodel));
                                //return Ok("true");
                            }
                            else
                            {
                                user.ErrorCode    = 0;
                                user.ErrorMessage = "false";
                                //return Ok("error: please_contact_admin_or_create_support_ticket_for_activate_account");
                            }
                        }
                        else
                        {
                            user.ErrorCode    = 0;
                            user.ErrorMessage = "false";
                            //return Ok("error:email_already_exist_or_sponserid_invalid");
                        }
                    }
                }
                else
                {
                    user.ErrorCode    = 0;
                    user.ErrorMessage = "false";
                    //return Ok("error: otp_code_not_found");
                }
            }
            catch (Exception ex)
            {
                return(Ok(ex.Message.ToString()));
            }
        }
예제 #4
0
        public IHttpActionResult NewRegistrationUsers(RegistrationModel registrationmodel)
        {
            try
            {
                if (string.IsNullOrEmpty(registrationmodel.Name) || string.IsNullOrEmpty(registrationmodel.Email) || string.IsNullOrEmpty(registrationmodel.Password) || string.IsNullOrEmpty(registrationmodel.MobileNo))
                {
                    user.ErrorCode    = 0;
                    user.ErrorMessage = "false";
                    //return Ok("error: please_fill_mandatory_filled");
                }
                else
                {
                    string sqlQuery = "";
                    string valuexx, email_valuexx;
                    if (string.IsNullOrEmpty(registrationmodel.SponserID = ""))
                    {
                        registrationmodel.SponserID = "admin";
                    }


                    sqlQuery = "SELECT cusid FROM Custrecords WHERE loginusername='******'";
                    sdr      = conCls.GetdataReader(sqlQuery);
                    if (sdr.HasRows)
                    {
                        if (sdr.Read())
                        {
                            valuexx = sdr["cusid"].ToString();
                        }
                        else
                        {
                            valuexx = "HELLO";
                        }
                        sdr = conCls.GetdataReader("SELECT count (*) as countemail   FROM  Custrecords_prereg WHERE email= '" + registrationmodel.Email.Replace(" ", "") + "'");
                        if (sdr.HasRows)
                        {
                            if (sdr.Read())
                            {
                                email_valuexx = sdr["countemail"].ToString();                                 // sdr["coun"].ToString();
                            }
                            else
                            {
                                email_valuexx = "1";
                            }
                        }
                        else
                        {
                            email_valuexx = "1";
                        }
                        sdr.Close();

                        if (registrationmodel.Name.Trim().Length > 4)
                        {
                            if (!string.IsNullOrEmpty(registrationmodel.Name))
                            {
                                decimal val;
                                var     isNumericName = decimal.TryParse(registrationmodel.Name.ToString(), out val);
                                if (!isNumericName)
                                {
                                    if (email_valuexx == "0")
                                    {
                                        string   Newid = "0", Errocode = "";
                                        string   _cust_sponserID, _name, _email, _cust_Password, _cust_address, _cust_answer, _cust_question, _cust_city, _cust_state, _cust_country, _Cust_Title, _Cust_Name, _Cust_Gender, _Cust_FatherName, _Cust_Pincode, _Cust_mobileNo, _Cust_nominee, _Cust_Relation, _Cust_Package, _Cust_Location, _Cust_TempPinID, _Cust_BankName, _Cust_BankAcc, _Cust_BankIFSC, _Cust_BankBranch, _Cust_PanID, _custusername;
                                        int      _PayMode = 0;
                                        DateTime _Cust_DOB;
                                        string   msgSuccess = "";
                                        _cust_sponserID  = valuexx;
                                        _name            = registrationmodel.Name;
                                        _email           = registrationmodel.Email;
                                        _Cust_mobileNo   = registrationmodel.MobileNo;
                                        _cust_Password   = registrationmodel.Password;
                                        _cust_address    = "";
                                        _cust_answer     = "";
                                        _cust_question   = "";
                                        _cust_city       = "";
                                        _cust_state      = "";
                                        _cust_country    = "";
                                        _Cust_Title      = "";
                                        _Cust_Name       = registrationmodel.Name;
                                        _Cust_Gender     = "";
                                        _Cust_FatherName = "";
                                        _Cust_DOB        = registrationmodel.Cust_DOB;
                                        _Cust_Pincode    = "";
                                        _Cust_nominee    = "";
                                        _Cust_Relation   = "";
                                        _Cust_Package    = registrationmodel.Cust_Package;
                                        _Cust_Location   = registrationmodel.Cust_Location;
                                        _Cust_TempPinID  = registrationmodel.Cust_tempPinID;
                                        _PayMode         = registrationmodel.PayMode;
                                        _Cust_BankName   = "";
                                        _Cust_BankAcc    = "";
                                        _Cust_BankIFSC   = "";
                                        _Cust_BankBranch = "";
                                        _Cust_PanID      = "";
                                        _custusername    = registrationmodel.custusername;

                                        var resultString = conCls.inserrtnewcustrecords(_cust_sponserID, _email, _cust_address, _cust_answer, _cust_question, _cust_city, _cust_state, _cust_country, _cust_Password, _Cust_Title, _Cust_Name, _Cust_Gender, _Cust_FatherName, _Cust_DOB, _Cust_Pincode, _Cust_mobileNo, _Cust_nominee, _Cust_Relation, _Cust_Package, _Cust_Location, _Cust_TempPinID, _PayMode, _Cust_BankName, _Cust_BankAcc, _Cust_BankIFSC, _Cust_BankBranch, _Cust_PanID, _custusername, out Newid, out Errocode);
                                        if (Newid.Length > 4)
                                        {
                                            ////****************OTP Gnereation Code*********************
                                            ////var Sendsms = new sendsms();
                                            //string numbers = "1234567890";
                                            //string characters = numbers;
                                            //// OTP LENGTH
                                            //int length = 6;

                                            ////INITIAL OTP
                                            //string otp = string.Empty;

                                            ////GENERATING OTP
                                            //for (int i = 0; i < length; i++)
                                            //{
                                            //	string character = string.Empty;
                                            //	do
                                            //	{
                                            //		int index = new Random().Next(0, characters.Length);
                                            //		character = characters.ToCharArray()[index].ToString();
                                            //	} while (otp.IndexOf(character) != -1);
                                            //	otp += character;
                                            //}

                                            SendSMS(Newid, _Cust_Name, _cust_sponserID, _Cust_mobileNo, _cust_Password, _email, _custusername, _cust_Password, _Cust_Package);
                                            string otpstatus = conCls.ExecuteSqlnonQuery("Update [OTP_data_Code] Set Status = 1 Where CustID = '" + Newid + "' AND Type = 'Registration' AND Status = 0").ToString();
                                            string result    = Convert.ToString(resultString);
                                            if (!string.IsNullOrEmpty(result))
                                            {
                                                if (result == "1")
                                                {
                                                    //return new RegistrationModel(_Cust_Name, Request);
                                                    //return Ok("true");
                                                    user.ErrorCode    = 1;
                                                    user.ErrorMessage = "true";
                                                    return(Ok(registrationmodel));
                                                }
                                                else
                                                {
                                                    user.ErrorCode    = 0;
                                                    user.ErrorMessage = "false";
                                                    user.registeruser = null;
                                                }
                                            }
                                            else
                                            {
                                                user.ErrorCode    = 0;
                                                user.ErrorMessage = "false";
                                                user.registeruser = null;
                                                //result = "false";
                                            }
                                        }
                                    }
                                    else
                                    {
                                        user.ErrorCode    = 0;
                                        user.ErrorMessage = "false";
                                        user.registeruser = null;
                                        //return Ok("error: email_already_exist");
                                    }
                                }
                                else
                                {
                                    user.ErrorCode    = 0;
                                    user.ErrorMessage = "false";
                                    user.registeruser = null;
                                    //return Ok("error: numeric_name_not_allowed");
                                }
                            }
                            else
                            {
                                user.ErrorCode    = 0;
                                user.ErrorMessage = "false";
                                user.registeruser = null;
                                //return Ok("error: name_cant_be_null_or_numeric");
                            }
                        }
                        else
                        {
                            user.ErrorCode    = 0;
                            user.ErrorMessage = "false";
                            //user.registeruser = null;
                            //return Ok("error: name_cant_be_less_than_five_characters");
                        }
                    }
                    else
                    {
                        user.ErrorCode    = 0;
                        user.ErrorMessage = "false";
                        user.registeruser = null;
                        //return Ok("error: sponser_id_invalid ");
                    }
                }
                return(Ok(user));
            }
            catch (Exception ex)
            {
                return(Ok(ex.Message.ToString()));
            }
        }