public BaseApiResponse UpdateAttorneyUser(AttorneyUsersEntity model)
        {
            var response = new BaseApiResponse();

            try
            {
                SqlParameter[] param = { new SqlParameter("Email", (object)model.Email ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("FirstName", (object)model.FirstName ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("LastName", (object)model.LastName ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("AttorneyEmployeeTypeId", (object)model.AttorneyEmployeeTypeId ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("UserId", (object)model.AttorneyUserId ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("CreatedBy", (object)model.CreatedBy ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("CompanyNo", (object)model.CompanyNo ?? (object)DBNull.Value) };
                var            result = _repository.ExecuteSQL <string>("UpdateAttorneyUser", param).FirstOrDefault();
                if (result != string.Empty)
                {
                    response.str_ResponseData = result;
                    response.Success          = true;
                }
            }
            catch (Exception ex)
            {
                response.Message.Add(ex.Message);
            }

            return(response);
        }
        public BaseApiResponse InsertAttorneyUser(AttorneyUsersEntity model)
        {
            var    response       = new BaseApiResponse();
            string RandomPassword = Axiom.Common.CommonHelper.CreateRandomPassword(8);
            CompanyDetailForEmailEntity objCompany = CommonFunction.CompanyDetailForEmail(model.CompanyNo);

            try
            {
                SqlParameter[] param = { new SqlParameter("Email", (object)model.Email ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("FirstName", (object)model.FirstName ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("LastName", (object)model.LastName ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("AttorneyEmployeeTypeId", (object)model.AttorneyEmployeeTypeId ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("Password", (object)Security.Encrypt(RandomPassword) ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("CreatedBy", (object)model.CreatedBy ?? (object)DBNull.Value)
                                         ,                         new SqlParameter("CompanyNo", (object)model.CompanyNo ?? (object)DBNull.Value) };
                var            result = _repository.ExecuteSQL <string>("InsertAttorneyUser", param).FirstOrDefault();
                if (result != string.Empty && result != "-1")
                {
                    // SEND WELCOME EMAIL TO USER ATTORNEY
                    StringBuilder body         = new StringBuilder();
                    string        htmlfilePath = AppDomain.CurrentDomain.BaseDirectory + "/MailTemplate/WelcomeNewUser.html";
                    using (StreamReader reader = new StreamReader((htmlfilePath)))
                    {
                        body.Append(reader.ReadToEnd());
                    }

                    body = body.Replace("{FirstName}", model.FirstName);
                    body = body.Replace("{LastName}", model.LastName);
                    body = body.Replace("{Email}", model.Email);
                    body = body.Replace("{Password}", RandomPassword);
                    body = body.Replace("{Link}", objCompany.SiteURL);
                    body = body.Replace("{LogoURL}", objCompany.Logopath);
                    body = body.Replace("{ThankYou}", objCompany.ThankYouMessage);
                    body = body.Replace("{CompanyName}", objCompany.CompName);


                    string subject = "Welcome To " + objCompany.CompName;
                    EmailHelper.Email.Send(objCompany.CompNo, model.Email, body.ToString(), subject, "", "[email protected],[email protected]");
                }
                response.str_ResponseData = result;
                response.Success          = true;
            }
            catch (Exception ex)
            {
                response.Message.Add(ex.Message);
            }

            return(response);
        }