public Contracts.DataModels.Country ActivateCountry([FromBody] Contracts.DataModels.Country model)
{
try
{
Contracts.DataModels.Country country = _countryRepository.GetByAltId(model.AltId);
if (country != null)
{
country.IsEnabled = model.IsEnabled;
_countryRepository.Save(country);
if (!model.IsEnabled)
{
_activityHelper.SaveActivity("Deactivated Country - " + country.Name, "You have deactivatred country " + country.Name + " on " + DateTime.Now.ToString("ddd, dd MMM yyy HH:mm:ss"), model.CreatedBy);
}
else
{
_activityHelper.SaveActivity("Activated Country - " + country.Name, "You have activatred country " + country.Name + " on " + DateTime.Now.ToString("ddd, dd MMM yyy HH:mm:ss"), model.CreatedBy);
}
return(country);
}
}
catch (Exception ex)
{
}
return(new Contracts.DataModels.Country());
}
public Contracts.DataModels.Country Edit([FromBody] Contracts.DataModels.Country model)
{
try
{
Contracts.DataModels.Country country = _countryRepository.GetByAltId(model.AltId);
if (country != null)
{
country.Name = model.Name;
country.NativeName = model.NativeName;
country.Region = model.Region;
country.SubRegion = model.SubRegion;
country.AlphaTwoCode = model.AlphaTwoCode;
country.AlphaThreeCode = model.AlphaThreeCode;
country.Language = model.Language;
country.Currency = model.Currency;
country.UpdatedUtc = DateTime.UtcNow;
country.UpdatedBy = model.UpdatedBy;
country = _countryRepository.Save(country);
}
_activityHelper.SaveActivity("Updated Country - " + country.Name, "You have updated country " + country.Name + " on " + DateTime.Now.ToString("ddd, dd MMM yyy HH:mm:ss"), (Guid)model.UpdatedBy);
return(country);
}
catch (Exception ex)
{
return(new Contracts.DataModels.Country());
}
}
public bool DeleteCountry([FromBody] Contracts.DataModels.Country model)
{
try
{
Contracts.DataModels.Country country = _countryRepository.GetByAltId(model.AltId);
if (country != null)
{
_countryRepository.Delete(country);
_activityHelper.SaveActivity("Deleted Country - " + country.Name, "You have deleted country " + country.Name + " on " + DateTime.Now.ToString("ddd, dd MMM yyy HH:mm:ss"), model.CreatedBy);
return(true);
}
}
catch (Exception ex)
{
}
return(false);
}
public bool SyncCountries([FromBody] Contracts.Models.User model)
{
List <Contracts.Models.ApiIntegrations.Country> countries = _apiCountryAll.GetAllCountries();
List <Contracts.DataModels.Country> countryList = new List <Contracts.DataModels.Country>();
IEnumerable <Contracts.DataModels.Country> availableCountryList = _countryRepository.GetAll(null);
foreach (Contracts.Models.ApiIntegrations.Country itemCountry in countries)
{
Contracts.DataModels.Country isCountryExist = availableCountryList.Where(w => w.Name == itemCountry.name).FirstOrDefault();
try
{
if (isCountryExist == null)
{
countryList.Add(new Contracts.DataModels.Country
{
Name = itemCountry.name,
NativeName = itemCountry.nativeName,
AlphaTwoCode = itemCountry.alpha2Code,
AlphaThreeCode = itemCountry.alpha3Code,
Capital = itemCountry.capital,
Flags = itemCountry.flag,
Area = itemCountry.area.ToString(),
Region = itemCountry.region,
SubRegion = itemCountry.subregion,
Population = itemCountry.population,
Currency = Mapper <string> .MapObjectToJsonString(itemCountry.currencies),
Language = Mapper <string> .MapObjectToJsonString(itemCountry.languages),
TimeZone = itemCountry.timezones != null ? itemCountry.timezones[0] : null,
CreatedBy = model.AltId
});
}
}
catch (Exception ex)
{
}
}
Dapper.DynamicParameters dynamicParameters = new Dapper.DynamicParameters();
dynamicParameters.Add("@XmlSeatLayout", Serialize <List <Contracts.DataModels.Country> >(countryList), System.Data.DbType.Xml);
_countryRepository.ExecuteStoredProcedure("spInsertCountries", dynamicParameters);
_activityHelper.SaveActivity("Country Data Synchronization", "You have performed country data sync opertion on " + DateTime.Now.ToString("ddd, dd MMM yyy HH:mm:ss"), model.AltId);
return(true);
}
protected override async Task <ICommandResult> Handle(UpdateUserCommand command)
{
UpdateUserCommandResult commandResult = new UpdateUserCommandResult();
var userModel = _userRepository.GetByAltId(command.UserProfile.AltId);
var userAdditionalModel = _feelUserAdditionalDetailRepository.GetByUserId(Convert.ToInt32(userModel.Id));
if (!string.IsNullOrEmpty(command.UserProfile.FirstName) && !string.IsNullOrEmpty(command.UserProfile.LastName))
{
var countryAltId = Guid.Empty;
if (!string.IsNullOrEmpty(command.UserProfile.PhoneCode))
{
countryAltId = new Guid(command.UserProfile.PhoneCode.Split("~")[1]);
command.UserProfile.PhoneCode = command.UserProfile.PhoneCode.Split("~")[0];
}
else
{
command.UserProfile.PhoneCode = "";
}
if (ShouldUpdate(userModel, null, command.UserProfile))
{
var country = new Contracts.DataModels.Country();
if (countryAltId != Guid.Empty)
{
country = _countryRepository.GetByAltId(countryAltId);
}
userModel.FirstName = command.UserProfile.FirstName;
userModel.LastName = command.UserProfile.LastName;
userModel.PhoneCode = command.UserProfile.PhoneCode;
userModel.PhoneNumber = command.UserProfile.PhoneNumber;
userModel.CountryId = country != null ? country.Id : null as int?;
_userRepository.Save(userModel);
}
if (userAdditionalModel == null)
{
SaveUserAdditionalDetail(userModel, command.UserProfile);
}
else
{
if (ShouldUpdate(null, userAdditionalModel, command.UserProfile))
{
var formattedDate = "";
if (!string.IsNullOrEmpty(command.UserProfile.DOB))
{
var splittedDate = command.UserProfile.DOB.Split("/");
formattedDate = splittedDate[2] + "-" + splittedDate[1] + "-" + splittedDate[0];
}
if (!string.IsNullOrEmpty(command.UserProfile.Gender))
{
userAdditionalModel.Gender = (Gender)Enum.Parse(typeof(Gender), command.UserProfile.Gender);
}
userAdditionalModel.BirthDate = formattedDate;
userAdditionalModel = _feelUserAdditionalDetailRepository.Save(userAdditionalModel);
}
}
}
var userProfileModel = GetUserProfile(userModel, userAdditionalModel);
commandResult.UserProfile = userProfileModel;
return(commandResult);
}
//FinancDetailsByIdQueryResults IQueryHandler<FinancDetailsByIdQuery, FinancDetailsByIdQueryResults>.Handle(FinancDetailsByIdQuery query)
public FinancDetailsByIdQueryResults Handle(FinancDetailsByIdQuery query)
{
FIL.Contracts.DataModels.FinanceDetail financeDetails = new FIL.Contracts.DataModels.FinanceDetail();
FIL.Contracts.DataModels.EventDetail eventDetail = new FIL.Contracts.DataModels.EventDetail();
FIL.Contracts.DataModels.Event eventRes = new FIL.Contracts.DataModels.Event();
FIL.Contracts.DataModels.Venue venueDetail = new FIL.Contracts.DataModels.Venue();
FIL.Contracts.DataModels.Venue venueDetailRes = new FIL.Contracts.DataModels.Venue();
FIL.Contracts.DataModels.City cityDetailRes = new Contracts.DataModels.City();
FIL.Contracts.DataModels.State stateDetailRes = new Contracts.DataModels.State();
FIL.Contracts.DataModels.Country countryDetailRes = new Contracts.DataModels.Country();
var eventResult = _eventRepository.GetByAltId(query.EventId);
var eventDetailRes = _eventDetailRepository.GetByEventId(eventResult.Id);
var financedetail = _financeDetailRepository.GetFinanceDetailsByEventId(eventResult.Id);
if (eventDetailRes != null)
{
venueDetailRes = _venueRepository.GetByVenueId((int)eventDetailRes.VenueId);
if (venueDetailRes != null)
{
cityDetailRes = _cityRepository.GetByCityId(venueDetailRes.CityId);
}
if (cityDetailRes != null)
{
stateDetailRes = _stateRepository.GetByStateId(cityDetailRes.StateId);
}
if (stateDetailRes != null)
{
countryDetailRes = _countryRepository.GetByCountryId(stateDetailRes.CountryId);
}
}
var resultdata = new FinancDetailsByIdQueryResults();
if (financedetail != null)
{
resultdata.FirstName = financedetail.FirstName;
resultdata.Id = financedetail.Id;
resultdata.LastName = financedetail.LastName;
resultdata.AccountNickName = financedetail.AccountNickName;
resultdata.BankName = financedetail.BankName;
resultdata.BankAccountType = financedetail.BankAccountType;
resultdata.BankName = financedetail.BankName;
resultdata.PANNo = financedetail.PANNo;
resultdata.RoutingNo = financedetail.RoutingNo;
resultdata.GSTNo = financedetail.GSTNo;
resultdata.AccountNo = financedetail.AccountNo;
resultdata.AccountNickName = financedetail.AccountNickName;
resultdata.CountryId = financedetail.CountryId;
resultdata.StateId = financedetail.StateId;
resultdata.CurrencyId = financedetail.CurrencyId;
resultdata.FinancialsAccountBankAccountGSTInfo = financedetail.FinancialsAccountBankAccountGSTInfo;
}
resultdata.EventId = eventResult.Id;
if (venueDetailRes != null)
{
resultdata.location = venueDetailRes.Name;
resultdata.address1 = venueDetailRes.AddressLineOne;
resultdata.address2 = venueDetailRes.AddressLineOne;
}
if (eventDetailRes != null)
{
resultdata.EventDetailId = (int)(eventDetailRes.Id);
}
if (stateDetailRes != null)
{
resultdata.state = stateDetailRes.Name;
}
if (cityDetailRes != null)
{
resultdata.city = cityDetailRes.Name;
}
if (countryDetailRes != null)
{
resultdata.country = countryDetailRes.Name;
}
return(resultdata);
}
