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