Esempio n. 1
0
        public static string RegisterNewUser(tbl_userdata user)
        {
            string activationCode = generateActivationCode();

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_userName", user.fld_username);
                dic.Add("in_password", SaltNHash(user.fld_password));
                dic.Add("in_firstName", user.fld_firstname);
                dic.Add("in_lastName", user.fld_lastname);
                dic.Add("in_gender", user.fld_gender);
                dic.Add("in_address", user.fld_address);
                dic.Add("in_zipCode", user.fld_zipcode);
                dic.Add("in_dob", user.fld_dateofbirth);
                dic.Add("in_phoneNumber", user.fld_phonenumber);
                dic.Add("in_emailAddress", user.fld_email);
                dic.Add("in_activationCode", activationCode);
                dic.Add("in_isActivated", false);
                dic.Add("out_userId", 0);
                dic = ProcedureCall <int> .ExecuteNonQuery(dic, "user_Register");

                user.fld_activationcode = activationCode;
                user.fld_userid         = Convert.ToInt32(dic["out_userId"]);
                EsUpdater <tbl_userdata> .InsertDocument(user, "moll_users", "User", dic["out_userId"].ToString());

                return(activationCode);
            }
            catch (Exception e)
            {
                return("Db Error!");
            }
        }
Esempio n. 2
0
        public static bool CheckShoppingCartItem(int fld_offeredserviceid, int fld_userid)
        {
            Dictionary <string, Object> dic = new Dictionary <string, Object>();

            dic.Add("in_givenServiceId", fld_offeredserviceid);
            dic.Add("in_givenUserId", fld_userid);
            dic.Add("out_result", 0);
            dic = ProcedureCall <int> .ExecuteNonQuery(dic, "CheckShoppingCartItemExistance");

            if (Convert.ToInt32(dic["out_result"]) > 0)
            {
                return(true);
            }

            return(false);
        }
Esempio n. 3
0
        public static int FindOrderId(int fld_offeredserviceid, string email)
        {
            try
            {
                Dictionary <string, object> dic = new Dictionary <string, Object>();
                dic.Add("in_offeredServiceId", fld_offeredserviceid);
                dic.Add("in_givenEmail", email);
                dic.Add("out_result", -1);
                dic = ProcedureCall <int> .ExecuteNonQuery(dic, "util_getOrderId");

                return(Convert.ToInt32(dic["out_result"]));
            }
            catch (Exception e)
            {
                return(-1);
            }
        }
Esempio n. 4
0
        public static int FindUserIdByEmail(string emailAddress)
        {
            int result = -1;

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_email", emailAddress);
                dic.Add("out_userId", result);
                Dictionary <string, Object> results = ProcedureCall <int> .ExecuteNonQuery(dic, "user_FindUserIdByEmail");

                return(Convert.ToInt32(results["out_userId"]));
            }
            catch (Exception e)
            {
                return(result);
            }
        }
Esempio n. 5
0
        //Creating a row using a ModelStateDictionary
        public static int CreateRow(ModelStateDictionary modelState, string targetTable)
        {
            try
            {
                Dictionary <string, object> dic = new Dictionary <string, object>();
                dic.Add("in_TargetTable", targetTable);
                dic.Add("out_generatedId", -1);

                dic = CreateStrings(modelState, dic);
                dic = ProcedureCall <object> .ExecuteNonQuery(dic, "util_CreateRow");

                return(Convert.ToInt32(dic["out_generatedId"]));
            }
            catch (Exception e)
            {
                return(-1);
            }
        }
Esempio n. 6
0
        //Creating a row from an object

        public static int CreateRow(Object row)
        {
            try
            {
                Dictionary <string, object> dic = new Dictionary <string, object>();
                dic.Add("in_targetTable", row.GetType().Name);
                dic.Add("out_generatedId", -1);

                dic = CreateStrings(row, dic);
                dic = ProcedureCall <object> .ExecuteNonQuery(dic, "util_CreateRow");

                return(Convert.ToInt32(dic["out_generatedId"]));
            }
            catch (Exception e)
            {
                return(-1);
            }
        }
Esempio n. 7
0
        public static int CheckIfUserExists(string emailAddress)
        {
            int result = -1;

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_emailAddress", emailAddress);
                dic.Add("out_result", result);
                dic = ProcedureCall <int> .ExecuteNonQuery(dic, "auth_CheckUserExists");

                return(Convert.ToInt32(dic["out_result"]));
            }
            catch (Exception e)
            {
                return(-2);
            }
        }
Esempio n. 8
0
        public static int CheckIfUserNameIsTaken(string userName)
        {
            int result = -2;

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_userName", userName);
                dic.Add("out_result", -2);
                dic = ProcedureCall <int> .ExecuteNonQuery(dic, "CheckIfUserNameIsTaken");

                return(Convert.ToInt32(dic["out_result"]));
            }

            catch (Exception e)
            {
                return(result);
            }
        }
Esempio n. 9
0
        public static int CheckIfPasswordsMatchs(LoginModel loginMdl)
        {
            int errorResult = 2;

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_emailAddress", loginMdl.EmailAddress);
                dic.Add("in_password", SaltNHash(loginMdl.Password));
                dic.Add("out_result", -2);
                dic = ProcedureCall <int> .ExecuteNonQuery(dic, "auth_CheckUserExists");

                return(Convert.ToInt32(dic["out_result"]));
            }
            catch (Exception ex)
            {
                return(errorResult);
            }
        }
Esempio n. 10
0
        public static int VerifyUser(string token, int userid)
        {
            int result = 0;

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_token", token);
                dic.Add("in_userid", userid);
                dic.Add("out_result", result);

                dic = ProcedureCall <int> .ExecuteNonQuery(dic, "user_verify");

                EsUpdater <tbl_userdata> .UpdateField("" + userid, "fld_isactivated", 1);

                return(Convert.ToInt32(dic["out_result"]));
            }
            catch (Exception e)
            {
                return(result);
            }
        }
Esempio n. 11
0
        public static string DeleteRow(string targetTable, string targetColumn, int targetValue)
        {
            string result = "";

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_TargetTable", targetTable);
                dic.Add("in_TargetColumn", targetColumn);
                dic.Add("in_TargetValue", targetValue);

                dic = ProcedureCall <Object> .ExecuteNonQuery(dic, "util_DeleteRow");



                return("Change successful");
            }
            catch (Exception e)
            {
                result = "Failed to change field";
                return(result);
            }
        }
Esempio n. 12
0
        public static string UpdateNumberField(string targetTable, string fieldToChange, int valueForField, string primaryKeyColumn, int id)
        {
            string result = "";

            try
            {
                Dictionary <string, Object> dic = new Dictionary <string, Object>();
                dic.Add("in_TargetTable", targetTable);
                dic.Add("in_FieldToChange", fieldToChange);
                dic.Add("in_valueForField", valueForField);
                dic.Add("in_PrimaryKeyColumn", primaryKeyColumn);
                dic.Add("in_Id", id);

                dic = ProcedureCall <Object> .ExecuteNonQuery(dic, "util_UpdateNumberField");

                return("Change successful");
            }
            catch (Exception e)
            {
                result = "Failed to change field";
                return(result);
            }
        }