コード例 #1
0
 public static void UpdatePassword(LoginModel _model)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, _model.UserID);
         objWLSql.AddParameter("@Password", DbType.String, ParameterDirection.Input, 0, _model.LoginPassword);
         objWLSql.ExecuteNonQuery("p_Users_ChangePassword");
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #2
0
 public static void UpdateProfileImage(Users user)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, user.UserID);
         objWLSql.AddParameter("@ImageName", DbType.String, ParameterDirection.Input, 0, user.ImageName);
         objWLSql.AddParameter("@ModifiedBy", DbType.Int64, ParameterDirection.Input, 0, user.ModifiedBy);
         objWLSql.ExecuteNonQuery("p_Users_UpdateImage");
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #3
0
 public static List <CarsDetailsDto> GetProductTypes(ProductTypesDto productID)
 {
     try
     {
         DataTable dt;
         wlSQL     objWLSql = new wlSQL();
         objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 7);
         objWLSql.AddParameter("@ProductTypeId", DbType.String, ParameterDirection.Input, 0, productID.ProductTypeId);
         dt = objWLSql.ExecuteDataSet("emi_carproduct").Tables[0];
         return(Util.ConvertDataTable <CarsDetailsDto>(dt));
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #4
0
 public static void UpdateUserRoles(UserRoles _Userrole)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, _Userrole.UserID);
         objWLSql.AddParameter("@RoleID", DbType.Int32, ParameterDirection.Input, 0, _Userrole.RoleID);
         objWLSql.AddParameter("@IsRolePermission", DbType.Boolean, ParameterDirection.Input, 0, _Userrole.IsRolePermission);
         objWLSql.AddParameter("@ModifiedBy", DbType.Int32, ParameterDirection.Input, 0, _Userrole.ModifiedBy);
         objWLSql.ExecuteNonQuery("p_UserRoles_upd");
     }
     catch (Exception ex)
     {
         wlLogging.HandleEx(ex);
     }
 }
コード例 #5
0
 public static string ValidateExternalUser(External externalUser)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@SocialID", DbType.String, ParameterDirection.Input, 0, externalUser.Id);
         objWLSql.AddParameter("@LastName", DbType.String, ParameterDirection.Input, 0, externalUser.LastName);
         objWLSql.AddParameter("@FirstName", DbType.String, ParameterDirection.Input, 0, externalUser.FirstName);
         objWLSql.AddParameter("@Email", DbType.String, ParameterDirection.Input, 0, externalUser.Email);
         objWLSql.AddParameter("@PhotoUrl", DbType.String, ParameterDirection.Input, 0, externalUser.PhotoUrl);
         return(Convert.ToString(objWLSql.ExecuteScalar("p_Users_ins_External")));
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #6
0
        //Authentication
        public static Users ValidateUser(string userName, string password)
        {
            IDataReader dr = null;

            try
            {
                wlSQL objWLSql = new wlSQL();
                objWLSql.AddParameter("@UserName", DbType.String, ParameterDirection.Input, 0, userName);
                objWLSql.AddParameter("@Password", DbType.String, ParameterDirection.Input, 0, password);
                dr = objWLSql.Execute("p_Users_sel_byUserIDAndPassword");
            }
            catch (Exception ex)
            {
                wlLogging.HandleEx(ex);
            }
            return(Util.ContructList <Users>(dr).FirstOrDefault());
        }
コード例 #7
0
 public static int AddUser(Users user)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@FirstName", DbType.String, ParameterDirection.Input, 0, user.FirstName);
         objWLSql.AddParameter("@LastName", DbType.String, ParameterDirection.Input, 0, user.LastName);
         objWLSql.AddParameter("@EmailAddress", DbType.String, ParameterDirection.Input, 0, user.EmailAddress);
         objWLSql.AddParameter("@StatusID", DbType.Int32, ParameterDirection.Input, 0, user.StatusID);
         objWLSql.AddParameter("@CreatedBy", DbType.Int32, ParameterDirection.Input, 0, user.CreatedBy);
         return(Convert.ToInt32(objWLSql.ExecuteScalar("p_Users_ins")));
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #8
0
 public static DataTable GetVersion()
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 1);
         return(objWLSql.ExecuteDataSet("emi_version").Tables[0]);
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #9
0
 public static List <UserRoles> GetUserRolePermissions(int _userID = 0)
 {
     try
     {
         DataTable dt;
         wlSQL     objWLSql = new wlSQL();
         objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, _userID);
         dt = objWLSql.ExecuteDataSet("p_UserRoles_sel_byID").Tables[0];
         return(Util.ConvertDataTable <UserRoles>(dt));
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #10
0
 public static List <UsersDto> GetUserList()
 {
     try
     {
         DataTable dt;
         wlSQL     objWLSql = new wlSQL();
         objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 6);
         dt = objWLSql.ExecuteDataSet("emi_carproduct").Tables[0];
         return(Util.ConvertDataTable <UsersDto>(dt));
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #11
0
 public static List <Users> GetLoginDetails(string emailAddress)
 {
     try
     {
         DataTable dt;
         wlSQL     objWLSql = new wlSQL();
         objWLSql.AddParameter("@EmailAddress", DbType.String, ParameterDirection.Input, 0, emailAddress);
         dt = objWLSql.ExecuteDataSet("p_Users_sel_LoginDetails").Tables[0];
         return(Util.ConvertDataTable <Users>(dt));
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #12
0
 public static DataSet GetProductDetails(int productTypeId)
 {
     try
     {
         DataSet ds;
         wlSQL   objWLSql = new wlSQL();
         objWLSql.AddParameter("@ProductTypes", DbType.Int32, ParameterDirection.Input, 0, productTypeId);
         ds = objWLSql.ExecuteDataSet("emi_ProductsDetails_ProductTypes");
         return(ds);
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #13
0
        public static LoginModel GetAccountInfo(long _userID = 0)
        {
            IDataReader dr = null;

            try
            {
                wlSQL objWLSql = new wlSQL();
                objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, _userID);
                dr = objWLSql.Execute("p_Users_sel_AccountInfo");
            }
            catch (Exception ex)
            {
                throw wlLogging.HandleEx(ex);
            }
            return(Util.ContructList <LoginModel>(dr).FirstOrDefault());
        }
コード例 #14
0
 public static int AddProduct(CarsProduct carsProduct)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 2);
         objWLSql.AddParameter("@CarsProductName1", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductName1);
         objWLSql.AddParameter("@CarsProductDescription", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductDescription);
         objWLSql.AddParameter("@CarsColor", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsColor);
         objWLSql.AddParameter("@CarsDoors", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsDoors);
         objWLSql.AddParameter("@CarsKilometers", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsKilometers);
         objWLSql.AddParameter("@CarsPrice", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsPrice);
         objWLSql.AddParameter("@IsActive", DbType.String, ParameterDirection.Input, 0, carsProduct.IsActive);
         objWLSql.AddParameter("@SessionId", DbType.String, ParameterDirection.Input, 0, carsProduct.SessionId);
         //objWLSql.AddParameter("@CreatedBy", DbType.String, ParameterDirection.Input, 0, carsProduct.CreatedBy);
         return(Convert.ToInt32(objWLSql.ExecuteScalar("emi_carproduct")));
     }
     catch (Exception ex)
     {
         throw wlLogging.HandleEx(ex);
     }
 }
コード例 #15
0
        public static List <AppVersions> GetAllVersion()
        {
            try
            {
                //wlSQL objWLSql = new wlSQL();
                //objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 2);
                //return objWLSql.ExecuteDataSet("emi_version").Tables[0];


                DataTable dt;
                wlSQL     objWLSql = new wlSQL();
                objWLSql.AddParameter("@paramType", DbType.Int32, ParameterDirection.Input, 0, 2);
                dt = objWLSql.ExecuteDataSet("emi_version").Tables[0];
                return(Util.ConvertDataTable <AppVersions>(dt));
            }
            catch (Exception ex)
            {
                throw wlLogging.HandleEx(ex);
            }
        }
コード例 #16
0
 public static void UpdateProduct(CarsProduct carsProduct)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@CarsProductId", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductId);
         objWLSql.AddParameter("@Name", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductName1);
         objWLSql.AddParameter("@CarsProductDescription", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsProductDescription);
         objWLSql.AddParameter("@CarsColor", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsColor);
         objWLSql.AddParameter("@CarsDoors", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsDoors);
         //objWLSql.AddParameter("@CarsImagesUrl", DbType.String, ParameterDirection.Input, 0, carsProduct.CarsImagesUrl);
         objWLSql.AddParameter("@CarsKilometers", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsKilometers);
         objWLSql.AddParameter("@CarsPrice", DbType.Int32, ParameterDirection.Input, 0, carsProduct.CarsPrice);
         objWLSql.ExecuteNonQuery("emi_carproduct");
     }
     catch (Exception ex)
     {
         wlLogging.HandleEx(ex);
     }
 }
コード例 #17
0
 public static void UpdateUser(Users user)
 {
     try
     {
         wlSQL objWLSql = new wlSQL();
         objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, user.UserID);
         objWLSql.AddParameter("@FirstName", DbType.String, ParameterDirection.Input, 0, user.FirstName);
         objWLSql.AddParameter("@LastName", DbType.String, ParameterDirection.Input, 0, user.LastName);
         objWLSql.AddParameter("@EmailAddress", DbType.String, ParameterDirection.Input, 0, user.EmailAddress);
         objWLSql.AddParameter("@StatusID", DbType.Int32, ParameterDirection.Input, 0, user.StatusID);
         objWLSql.AddParameter("@ModifiedBy", DbType.Int32, ParameterDirection.Input, 0, user.ModifiedBy);
         objWLSql.ExecuteNonQuery("p_Users_upd");
     }
     catch (Exception ex)
     {
         wlLogging.HandleEx(ex);
     }
 }
コード例 #18
0
        public static bool IsExistUser(string loginUserName)
        {
            try
            {
                wlSQL objWLSql = new wlSQL();
                objWLSql.AddParameter("@LoginUserName", DbType.String, ParameterDirection.Input, 0, loginUserName);
                object o    = objWLSql.ExecuteScalar("p_Users_sel_IsExistUser");
                bool   flag = false;
                if (o != null)
                {
                    int count = Convert.ToInt32(o.ToString(), CultureInfo.CurrentCulture);
                    if (count > 0)
                    {
                        flag = true;
                    }
                }

                return(flag);
            }
            catch (Exception ex)
            {
                throw wlLogging.HandleEx(ex);
            }
        }
コード例 #19
0
        public static void RegisterUser(Register obj)
        {
            try
            {
                wlSQL objWLSql = new wlSQL();
                //objWLSql.AddParameter("@FullName", DbType.String, ParameterDirection.Input, 0, obj.FullName);
                objWLSql.AddParameter("@Mobile", DbType.String, ParameterDirection.Input, 0, obj.Mobile);
                objWLSql.AddParameter("@UserName", DbType.String, ParameterDirection.Input, 0, obj.UserName);
                objWLSql.AddParameter("@Password", DbType.String, ParameterDirection.Input, 0, obj.Password);
                objWLSql.AddParameter("@Email", DbType.String, ParameterDirection.Input, 0, obj.Email);
                objWLSql.AddParameter("@CountryID", DbType.Int32, ParameterDirection.Input, 0, obj.CountryID);
                objWLSql.AddParameter("@CityID", DbType.Int32, ParameterDirection.Input, 0, obj.CityID);

                objWLSql.ExecuteNonQuery("p_Users_register");
            }
            catch (Exception ex)
            {
                if (ex.GetBaseException().GetType() == typeof(SqlException))
                {
                    //Violation of primary key/Unique constraint can be handled here. Also you may //check if Exception Message contains the constraint Name
                }
            }
        }