예제 #1
0
 public SigmaResultType ForgotPassword(string userId, string email)
 {
     SigmaResultType result = new SigmaResultType();
     MailMgr mailMgr = new MailMgr();
     try
     {
         result = mailMgr.ForgotPassword(userId, email);
         return result;
     }
     catch (Exception ex)
     {
         // Log Exception
         ExceptionHelper.logException(ex);
         result.IsSuccessful = false;
         result.ErrorMessage = ex.Message;
         return result;
     }
 }
예제 #2
0
        public SigmaResultType AddSigmaUser(TypeSigmaUser objSigmaUser)
        {
            TypeUserInfo userinfo = AuthMgr.GetUserInfo();
            objSigmaUser.CreatedBy = userinfo.SigmaUserId;

            TransactionScope scope = null;
            SigmaResultType result = new SigmaResultType();

            // Get connection string
            string connStr = ConnStrHelper.getDbConnString();
            string pwd = RandumPassword();
            List<SqlParameter> paramList = new List<SqlParameter>();
            paramList.Add(new SqlParameter("@SigmaUserId", objSigmaUser.SigmaUserId));
            paramList.Add(new SqlParameter("@CompanyId", objSigmaUser.CompanyId));
            paramList.Add(new SqlParameter("@EmployeeId", objSigmaUser.EmployeeId));
            paramList.Add(new SqlParameter("@FirstName", objSigmaUser.FirstName));
            paramList.Add(new SqlParameter("@LastName", objSigmaUser.LastName));
            paramList.Add(new SqlParameter("@PhoneNo", objSigmaUser.PhoneNo));
            paramList.Add(new SqlParameter("@Email", objSigmaUser.Email));
            paramList.Add(new SqlParameter("@PhotoUrl", objSigmaUser.PhotoUrl));
            paramList.Add(new SqlParameter("@Password", GetMD5Hash(RandumPassword())));
            paramList.Add(new SqlParameter("@CreatedBy", objSigmaUser.CreatedBy));

            using (scope = new TransactionScope(TransactionScopeOption.Required))
            {
                result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, "usp_AddSigmaUser", paramList.ToArray());

                objSigmaUser.Password = pwd;

                MailMgr mailMgr = new MailMgr();

                mailMgr.SendMail(objSigmaUser);

                result.IsSuccessful = true;

                scope.Complete();
            }

            return result;
        }
예제 #3
0
        public SigmaResultType AddSigmaUserTemplate(TypeSigmaUser objSigmaUser)
        {
            TypeUserInfo userinfo = AuthMgr.GetUserInfo();
            objSigmaUser.CreatedBy = userinfo.SigmaUserId;

            TransactionScope scope = null;
            SigmaResultType result = new SigmaResultType();

            // Get connection string
            string connStr = ConnStrHelper.getDbConnString();
            string pwd = RandumPassword();

            List<SqlParameter> paramList = new List<SqlParameter>();
            paramList.Add(new SqlParameter("@SigmaUserId", objSigmaUser.SigmaUserId));
            paramList.Add(new SqlParameter("@CompanyName", objSigmaUser.CompanyName));
            paramList.Add(new SqlParameter("@EmployeeId", objSigmaUser.EmployeeId));
            paramList.Add(new SqlParameter("@FirstName", objSigmaUser.FirstName));
            paramList.Add(new SqlParameter("@LastName", objSigmaUser.LastName));
            paramList.Add(new SqlParameter("@PhoneNo", objSigmaUser.PhoneNo));
            paramList.Add(new SqlParameter("@Email", objSigmaUser.Email));
            paramList.Add(new SqlParameter("@PhotoUrl", objSigmaUser.PhotoUrl));
            paramList.Add(new SqlParameter("@Password", GetMD5Hash(RandumPassword())));
            paramList.Add(new SqlParameter("@CreatedBy", objSigmaUser.CreatedBy));
            SqlParameter outParam = new SqlParameter("@ExMessage", SqlDbType.NVarChar, 100);
            outParam.Direction = ParameterDirection.Output;
            paramList.Add(outParam);

            using (scope = new TransactionScope(TransactionScopeOption.Required))
            {
                result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, "usp_AddSigmaUserByTemplate", paramList.ToArray());
                result.IsSuccessful = true;
                if (!string.IsNullOrEmpty(outParam.Value.ToString()))
                    result.ErrorMessage = outParam.Value.ToString();
                else
                {
                    objSigmaUser.Password = pwd;

                    MailMgr mailMgr = new MailMgr();

                    mailMgr.SendMail(objSigmaUser);
                }

                scope.Complete();
            }

            return result;
        }