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); }