public bool Remove(ContactDetailsModel obj) { using (var conn = new SqlConnection(_connectionString)) { try { ContactDetailsModel model = new ContactDetailsModel(); SqlCommand sqlcommand = new SqlCommand(); sqlcommand.CommandText = "DELETE FROM ContactDetails where Id=" + obj.Id; sqlcommand.Connection = conn; conn.Open(); if (sqlcommand.ExecuteNonQuery() < 1) { conn.Close(); return(false); } conn.Close(); return(true); } catch (Exception ex) { return(false); } } }
public ContactDetailsModel GetById(int id) { using (var conn = new SqlConnection(_connectionString)) { try { ContactDetailsModel model = new ContactDetailsModel(); SqlCommand sqlcommand = new SqlCommand(); sqlcommand.CommandText = "SELECT * FROM ContactDetails where Id=" + id; sqlcommand.Connection = conn; conn.Open(); SqlDataReader reader = sqlcommand.ExecuteReader(); while (reader.HasRows && reader.Read()) { model.Id = reader.SafeGetInt("Id"); model.FirstName = reader.SafeGetString("FirstName"); model.LastName = reader.SafeGetString("LastName"); model.Email = reader.SafeGetString("Email"); model.PhoneNumber = reader.SafeGetString("PhoneNumber"); if (Enum.TryParse(reader.SafeGetString("Status"), out Status status)) { model.Status = status; } } conn.Close(); return(model); } catch (Exception ex) { return(null); } } }
public bool Add(ContactDetailsModel obj) { using (var conn = new SqlConnection(_connectionString)) { try { SqlCommand sqlcommand = new SqlCommand(); sqlcommand.CommandText = "insert into ContactDetails(FirstName,LastName,Email,PhoneNumber,Status) " + "VALUES('" + obj.FirstName + "','" + obj.LastName + "','" + obj.Email + "','" + obj.PhoneNumber + "','" + obj.Status + "')"; sqlcommand.Connection = conn; conn.Open(); if (sqlcommand.ExecuteNonQuery() < 1) { conn.Close(); return(false); } conn.Close(); return(true); } catch (Exception ex) { return(false); } } }
public GenericResult UpdateContact(Guid id, [FromBody] ContactDetailsModel model) { var cmd = new SaveContactCommand(_orgService); model.Id = id; return(cmd.Save(model)); }
public ActionResult Apply(Guid jobAdId, Guid fileReferenceId, ContactDetailsModel contactDetails) { try { var jobAd = GetJobAd(jobAdId, JobAdProcessing.ManagedExternally); if (jobAd == null) { return(JsonNotFound("job ad")); } // Check the file exists. var fileReference = _filesQuery.GetFileReference(fileReferenceId); if (fileReference == null) { return(JsonNotFound("file")); } // Submit the application. var contact = _anonymousUsersCommand.CreateContact(CurrentAnonymousUser, new ContactDetails { EmailAddress = contactDetails.EmailAddress, FirstName = contactDetails.FirstName, LastName = contactDetails.LastName }); var applicationId = _anonymousJobAdApplicationsCommand.Submit(contact, jobAd, fileReferenceId); return(Json(new JsonApplicationResponseModel { Id = applicationId })); } catch (UserException ex) { ModelState.AddModelError(ex, new StandardErrorHandler()); } return(Json(new JsonResponseModel())); }
public async Task <IActionResult> AddUserContact(ContactDetailsModel contactDetailsModel) { if (!ModelState.IsValid) { return(BadRequest(new Response() { Message = "Invalid Parameters!.Contact Support Team", IsSuccess = false })); } var result = await _companyManagementManager.AddContactDetails(contactDetailsModel); if (result == 1) { return(StatusCode(201, new Response() { Message = "User Information has been Successfully Added", IsSuccess = true })); } else if (result == 0) { return(StatusCode(500, new Response() { Message = "Issue while proceesing the Request. Please contact the Support Team", IsSuccess = false })); } else { return(StatusCode(200, new Response() { Message = "Phone Number Already Exists. Please use other phone number to add the contact", IsSuccess = false })); } }
public bool Edit(ContactDetailsModel obj) { using (var conn = new SqlConnection(_connectionString)) { try { ContactDetailsModel model = new ContactDetailsModel(); SqlCommand sqlcommand = new SqlCommand(); sqlcommand.CommandText = "UPDATE ContactDetails SET FirstName='" + obj.FirstName + "'," + "LastName='" + obj.LastName + "', " + "Email='" + obj.Email + "', " + "PhoneNumber='" + obj.PhoneNumber + "', " + "Status='" + obj.Status + "' where Id=" + obj.Id; sqlcommand.Connection = conn; conn.Open(); if (sqlcommand.ExecuteNonQuery() < 1) { conn.Close(); return(false); } conn.Close(); return(true); } catch (Exception ex) { return(false); } } }
public static Entity ToEntity(this ContactDetailsModel model) { return(new Entity("contact") { Id = model.Id, ["firstname"] = model.FirstName, ["lastname"] = model.LastName, ["emailaddress1"] = model.Email, ["telephone1"] = model.BusinessPhone }); }
public ActionResult <Contact> UpdateContact(ContactDetailsModel contactDetailsModel) { try { return(_contactOrganizerService.UpdateContactDetails(contactDetailsModel.Id, contactDetailsModel)); } catch (ValidationException validationException) { return(BadRequest(validationException.Errors)); } }
public ActionResult Delete(ContactDetailsModel contactDetails) { if (ObjectRegistration.ContactDataSource.Remove(contactDetails)) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can not delete. internal error occured!"); } return(View(contactDetails)); }
/// <summary> /// Convert object into origanal model /// </summary> /// <param name="cntdata"></param> /// <returns></returns> public static Contact ConvertBackToSchemaClass(ContactDetailsModel cntdata) { return(new Contact() { Email = cntdata.Email, FirstName = cntdata.FirstName, LastName = cntdata.LastName, Id = cntdata.Id, Status = cntdata.Status.ToString(), Phone = cntdata.PhoneNumber }); }
public bool Remove(ContactDetailsModel obj) { try { _contacts.Contact.Remove(_contacts.Contact.Find(x => x.Id == obj.Id)); Helper.SchemaHelper.Serialize(_filepath, _contacts); return(true); } catch { return(false); } }
public ActionResult Create(ContactDetailsModel contactDetails) { if (ModelState.IsValid) { if (ObjectRegistration.ContactDataSource.Add(contactDetails)) { return(RedirectToAction("index")); } else { ModelState.AddModelError("", "Can not save changes internal error occured!"); } } return(View(contactDetails)); }
public bool Edit(ContactDetailsModel obj1) { try { var currentobj = _contacts.Contact.FindIndex(x => x.Id == obj1.Id); var newobj = Helper.SchemaHelper.ConvertBackToSchemaClass(obj1); _contacts.Contact[currentobj] = newobj; Helper.SchemaHelper.Serialize(_filepath, _contacts); return(true); } catch { return(false); } }
public ActionResult SaveSearch(ContactDetailsModel contactDetails) { try { // Save the current search. var currentSearch = MemberContext.CurrentSearch; if (currentSearch == null) { return(JsonNotFound("current search")); } // Look for a current user. var registeredUser = CurrentRegisteredUser; if (registeredUser != null) { var search = new JobAdSearch { Criteria = currentSearch.Criteria.Clone() }; _jobAdSearchAlertsCommand.CreateJobAdSearchAlert(registeredUser.Id, search, DateTime.Now); } else { var anonymousUser = CurrentAnonymousUser; if (anonymousUser != null) { // The owner of the alert is the contact for the anonymous user. var contact = _anonymousUsersCommand.CreateContact(anonymousUser, new ContactDetails { EmailAddress = contactDetails.EmailAddress, FirstName = contactDetails.FirstName, LastName = contactDetails.LastName }); var search = new JobAdSearch { Criteria = currentSearch.Criteria.Clone() }; _jobAdSearchAlertsCommand.CreateJobAdSearchAlert(contact.Id, search, DateTime.Now); } } return(Json(new JsonResponseModel())); } catch (UserException ex) { ModelState.AddModelError(ex, new StandardErrorHandler()); } return(Json(new JsonResponseModel())); }
Guid IHotelManagementRepository.UpdateContactInformation(ContactDetailsModel model) { var entity = new ContactDetails() { Taxid = model.Taxid, TelephoneNumber = model.TelephoneNumber, FaxNumber = model.FaxNumber, EmailAddress = model.EmailAddress, CountryCode = model.CountryCode, PostalCode = model.PostalCode, DateTime = DateTime.UtcNow }; Context.ContactDetails.Add(entity); Context.SaveChanges(); return(entity.Id); }
public void Setup() { var optionsBuilder = new DbContextOptionsBuilder <PortFreightContext>() .UseInMemoryDatabase("InMemoryDb") .Options; httpContext = new DefaultHttpContext(); tempData = new TempDataDictionary(httpContext, Mock.Of <ITempDataProvider>()); var modelState = new ModelStateDictionary(); actionContext = new ActionContext(httpContext, new RouteData(), new PageActionDescriptor(), modelState); var modelMetadataProvider = new EmptyModelMetadataProvider(); viewData = new ViewDataDictionary(modelMetadataProvider, modelState); pageContext = new PageContext(actionContext) { ViewData = viewData }; portFreightUsers = new List <PortFreightUser> { new PortFreightUser() { Id = "TestUser1", Email = "*****@*****.**", SenderId = "Test1234", UserName = "******" }, new PortFreightUser() { Id = "TestUser2", Email = "*****@*****.**", SenderId = "Test5678", UserName = "******" } }; mockUserManager = MockUserManager <PortFreightUser>(portFreightUsers); mockUserManager.Setup(p => p.GetUserAsync(httpContext.User)).ReturnsAsync(portFreightUsers.FirstOrDefault()); actualContext = new PortFreightContext(optionsBuilder); model = new ContactDetailsModel(mockUserManager.Object, actualContext) { PageContext = pageContext, Url = new UrlHelper(actionContext), ContactDetails = new ContactDetails() }; }
public bool UpdateHotelDetails(HotelSetupViewModel viewModel) { var hotelDetailsModel = new HotelDetailsModel() { HotelName = viewModel.HotelName, CompanyName = viewModel.CompanyName, BusinessNumber = Convert.ToInt32(viewModel.BusinessNumber), }; Repository.UpdateHotelInformation(hotelDetailsModel); var contactDetailsModel = new ContactDetailsModel() { Taxid = viewModel.Taxid, TelephoneNumber = viewModel.Telephone, FaxNumber = viewModel.FaxNumber, EmailAddress = viewModel.EmailAddress, CountryCode = viewModel.CountryCode, PostalCode = viewModel.PostalCode, }; Repository.UpdateContactInformation(contactDetailsModel); var addressDetailsModel = new AddressDetailsModel() { Address = viewModel.Address, City = viewModel.City, CityCode = viewModel.CityCode, State = viewModel.State, }; Repository.UpdateAddressInformation(addressDetailsModel); var logoDetailsModel = new LogoDetailsModel() { Website = viewModel.Website, Logo = viewModel.Logo, Skype = viewModel.Skype, Language = viewModel.Language, }; Repository.UpdateLogoInformation(logoDetailsModel); return(true); }
public async Task <int> AddContactDetails(ContactDetailsModel contactDetails) { var result = await _companyManagementRepository.CheckDuplicateByphone(contactDetails.CompanyId, contactDetails.Mobile); if (result.Count >= 1) { return(-1); } var mappedObject = _mapper.Map <ContactDetails>(contactDetails); if (await _companyManagementRepository.AddContactDetails(mappedObject)) { return(1); } else { return(0); } }
public GenericResult Save(ContactDetailsModel model) { using (var ctx = new OrganizationServiceContext(_service)) { var existingContact = (from c in ctx.CreateQuery(Contact) where (string)c[Email] == model.Email select c).FirstOrDefault(); if (existingContact == null) { _service.Create(model.ToEntity()); return(GenericResult.Succeed()); } else { return(GenericResult.FailWith($"Contact with email '{model.Email}' already exists")); } } }
private async Task <CompanyDetailModel> CompanyDetailById(int companyId) { CompanyDetailModel companyDetailModel = new CompanyDetailModel(); var result = await _companyManagementRepository.GetCompanyDetailsById(companyId); var statusCode = await _companyManagementRepository.GetStatusCode(); var contactDetails = await _companyManagementRepository.GetContactDetailsByCompany(companyId); if (result != null) { var mappedObject = _mapper.Map <CompanyDetailsModel>(result); foreach (var status in statusCode) { if (mappedObject.StatusId == status.StatusId) { mappedObject.StatusDescription = status.StatusDescription; } } foreach (var contactDetail in contactDetails) { ContactDetailsModel contact = new ContactDetailsModel(); ContactDetailsModel mappedContactDetails = _mapper.Map <ContactDetailsModel>(contactDetail); contact.CompanyId = mappedContactDetails.CompanyId; contact.Email = mappedContactDetails.Email; contact.FullName = mappedContactDetails.FullName; contact.Mobile = mappedContactDetails.Mobile; contact.GenderId = mappedContactDetails.GenderId; contact.UserId = mappedContactDetails.UserId; companyDetailModel.contactDetails.Add(contact); } companyDetailModel.companyDetails = mappedObject; int currentStatusId = companyDetailModel.companyDetails.StatusId; int nextStatusId = companyDetailModel.companyDetails.StatusId; string nextStatusDescription = companyDetailModel.companyDetails.StatusDescription; SetNextStatusCode(ref currentStatusId, ref nextStatusId, ref nextStatusDescription); companyDetailModel.NextStatusDescription = nextStatusDescription; companyDetailModel.NextStatusId = nextStatusId; companyDetailModel.IsSuccess = true; } return(companyDetailModel); }
public bool Add(ContactDetailsModel obj) { try { var schemaclassobj = Helper.SchemaHelper.ConvertBackToSchemaClass(obj); if (_contacts == null) { _contacts = new Contacts() { Contact = new List <Contact>() } } ; _contacts.Contact.Add(schemaclassobj); Helper.SchemaHelper.Serialize(_filepath, _contacts); return(true); } catch { return(false); } }
public ActionResult CustomerDetails(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Contacts.Instance.Clear(); Contacts.Instance.AddRange(BusinessContact.Load()); var contact = Contacts.Instance.Find(x => x.IsThisUniqueId(id)); if (contact == null) { return(HttpNotFound()); } ContactDetailsModel model = new ContactDetailsModel(contact); model.LendedBooks = BusinessProduct.GetCustomerLendedBooks(id); if (contact.Contact != null) { return(View("CustomerDetails", model)); } return(View("Index")); }
public GenericResult SaveNewContact([FromBody] ContactDetailsModel model) { var cmd = new SaveContactCommand(_orgService); return(cmd.Save(model)); }