public BaseResponse <bool> CreateYacht(YachtCreateModel model)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var userId = GetUserGuidId();
//Add yacht
var yacht = new Yachts();
yacht = _mapper.Map <YachtCreateModel, Yachts>(model, yacht);
yacht.UniqueId = UniqueIDHelper.GenarateRandomString(12);
yacht.Deleted = false;
yacht.CreatedBy = userId;
yacht.CreatedDate = DateTime.Now;
yacht.LastModifiedBy = userId;
yacht.LastModifiedDate = DateTime.Now;
_context.Yachts.Add(yacht);
var result = _context.SaveChanges();
var listYachtAttrVal = new List <YachtAttributeValues>();
//Add yacht attributevalue accomodations
if (!string.IsNullOrEmpty(model.ListAccomodation))
{
var attrAccomodations = model.ListAccomodation.Split(",");
foreach (var item in attrAccomodations)
{
var yachtAttributeValue = new YachtAttributeValues
{
AttributeCategoryFid = (int)YachtAttributeEnum.Accomodations,
AttributeFid = item.Split("_")[0].ToInt32(),
AttributeValue = item.Split("_")[1],
YachtFid = yacht.Id,
LastModifiedBy = userId,
LastModifiedDate = DateTime.Now
};
listYachtAttrVal.Add(yachtAttributeValue);
}
}
//Add yacht port
if (model.PortLocationId > 0)
{
var portInfo = _context.PortLocations.AsNoTracking().Where(x => x.Id == model.PortLocationId && x.Deleted == false).FirstOrDefault();
if (portInfo != null)
{
var yachtPort = new YachtPorts
{
YachtFid = yacht.Id,
PortFid = portInfo.Id,
PortName = portInfo.PickupPointName,
IsActivated = true,
Deleted = false,
CreatedBy = userId,
CreatedDate = DateTime.Now,
EffectiveDate = DateTime.Now
};
//update location for yacht
yacht.Country = portInfo.Country;
yacht.City = portInfo.City;
_context.Yachts.Update(yacht);
_context.YachtPorts.Add(yachtPort);
}
}
//Add yacht attributevalue amenities
if (!string.IsNullOrEmpty(model.ListAmenities))
{
var attrAmenities = model.ListAmenities.Split(",");
foreach (var item in attrAmenities)
{
var yachtAttributeValue = new YachtAttributeValues
{
AttributeCategoryFid = (int)YachtAttributeEnum.Ametities,
AttributeFid = item.Split("_")[0].ToInt32(),
AttributeValue = item.Split("_")[1],
YachtFid = yacht.Id,
LastModifiedBy = userId,
LastModifiedDate = DateTime.Now
};
listYachtAttrVal.Add(yachtAttributeValue);
}
}
if (listYachtAttrVal.Count > 0)
{
_context.YachtAttributeValues.AddRange(listYachtAttrVal);
}
//Add yacht non bussinessday
if (!string.IsNullOrEmpty(model.ListNonBusinessDay))
{
var listNonBizDay = model.ListNonBusinessDay.Split(",");
var listYachtNonBizDay = new List <YachtNonOperationDays>();
foreach (var item in listNonBizDay)
{
var date = item.Replace(".", "-");
var dateTime = (date + "-" + DateTime.Now.Year).ToNullDateTime();
if (dateTime != null)
{
var yachtNonBizDay = new YachtNonOperationDays
{
YachtFid = yacht.Id,
Recurring = false,
Remark = "",
StartDate = dateTime.Value,
EndDate = dateTime.Value,
CreatedBy = userId,
CreatedDate = DateTime.Now,
LastModifiedBy = userId,
LastModifiedDate = DateTime.Now
};
listYachtNonBizDay.Add(yachtNonBizDay);
}
}
_context.YachtNonOperationDays.AddRange(listYachtNonBizDay);
}
//Add yachtCounter
var yachtCounter = new YachtCounters
{
YachtId = yacht.Id,
YachtUniqueId = yacht.UniqueId,
TotalViews = 0,
TotalBookings = 0,
TotalSuccessBookings = 0,
TotalReviews = 0,
TotalRecommendeds = 0,
TotalNotRecommendeds = 0
};
_context.YachtCounters.Add(yachtCounter);
result = _context.SaveChanges();
transaction.Commit();
transaction.Dispose();
return(BaseResponse <bool> .Success());
}
catch (Exception ex)
{
return(BaseResponse <bool> .InternalServerError(message : ex.Message, fullMsg : ex.StackTrace));
}
}
}
//*****modified by hoangle 10-10-2019
//*****next modified by
//*****using Yacht/CartPayment
public BaseResponse <SaveCharterPaymentResponseViewModel> SaveChartering(SaveBookingRequestModel requestModel, string PaymentMethod)
{
#region initalize logging
string errCode = "0";
SaveCharterPaymentResponseViewModel errGlobal = new SaveCharterPaymentResponseViewModel();
#endregion
#region logging Subject
string dataSubjectLogging = "";
errGlobal.Name = "SavePaymentTrip";
errGlobal.Value = dataSubjectLogging;
errGlobal.ResuldCode = errCode;
errGlobal.Id = "0";
errGlobal.UniqueId = "";
#endregion
try
{
var redisCartRequestModel = requestModel.RedisCartRequestModel;
var bookingRequestModel = requestModel.BookingRequestModel;
var value = _distributedCache.GetString(redisCartRequestModel.Key);
if (value != null)
{
var lstRedisStorage = JsonConvert.DeserializeObject <List <RedisStorage> >(value);
//requestModel.HashKey ==> Dining or Yacht or other...
var RedisStorageModel = lstRedisStorage.FirstOrDefault(k => k.Domain == redisCartRequestModel.HashKey);
#region DOMAIN
if (RedisStorageModel != null)// DOMAIN IS EXIST
{
var result = RedisStorageModel.PackageStorage;
if (result != null)
{
List <YachtPackageServiceModel> lstYachtPackage = result.Where(x => redisCartRequestModel.itemList.Contains(x.YachtId)).Select(i => i).ToList();
if (lstYachtPackage != null)
{
///Foreach Yacht choosed
foreach (YachtPackageServiceModel yachtItem in lstYachtPackage)
{
#region CALCULATION
MerchantPaymentPackageViewModel responsePackageModel = new MerchantPaymentPackageViewModel();
List <MerchantPaymentEachPackageViewModel> lstProductInventories = new List <MerchantPaymentEachPackageViewModel>();
#region logging Subject
if (dataSubjectLogging != "")
{
dataSubjectLogging += ",";
}
dataSubjectLogging += "{";
dataSubjectLogging += $"YachtId:{yachtItem.YachtId},";
dataSubjectLogging += $"Passenger:{yachtItem.Passenger },";
dataSubjectLogging += $"CheckIn:{yachtItem.CheckIn },";
dataSubjectLogging += $"CheckOut:{yachtItem.CheckOut },";
string ErrorCode = "0";
string ErrorDescription = "";
string ErrorGlobalPackageDescription = "";
#endregion
try
{
#region YACHT
var yachtFIdde = Terminator.Decrypt(yachtItem.YachtId).ToInt32();
double dbYachtFee = 0;
string yachtCultureCode = "";
string yachtCurrencyCode = "";
#region NUMBER OF DAY OR WEEK
int bookingDayNumber = GlobalMethod.BookingDayNumber(yachtItem.CheckIn, yachtItem.CheckOut);
#region GET PRICE
var responsePricingPlanDetail = _yachtPricingPlanDetailService.GetPricingPlanDetailYachtFId(yachtItem.YachtId);
if (responsePricingPlanDetail != null && responsePricingPlanDetail.IsSuccessStatusCode && responsePricingPlanDetail.ResponseData != null)
{
if (responsePricingPlanDetail.ResponseData.Details != null)
{
var priceDetail = responsePricingPlanDetail.ResponseData.Details.OrderByDescending(x => x.PricingTypeFid).FirstOrDefault();
if (priceDetail != null)
{
yachtCultureCode = priceDetail.CultureCode;
yachtCurrencyCode = priceDetail.CurrencyCode;
}
GlobalMethod.GetPriceRecuse(responsePricingPlanDetail.ResponseData.Details, bookingDayNumber, ref dbYachtFee);
}
}
#endregion
responsePackageModel.Id = yachtItem.YachtId;
responsePackageModel.Passenger = yachtItem.Passenger;
responsePackageModel.YachtTotal = dbYachtFee;
responsePackageModel.Total = dbYachtFee;
responsePackageModel.PackageTotal = 0;
responsePackageModel.DiscountTotal = 0;
#endregion
/**INSERT INTO CHARTERING**/
#region YachtPort Infomation
var responseYachtPort = (
from p in _aqYachtContext.YachtPorts
.Where(k => k.YachtFid == yachtFIdde &&
k.Deleted == false &&
k.EffectiveDate <= DateTime.Now.Date &&
k.IsActivated == true &&
k.EffectiveDate == _aqYachtContext.YachtPorts
.Where(o => o.YachtFid == yachtFIdde &&
o.Deleted == false &&
o.EffectiveDate <= DateTime.Now.Date &&
o.IsActivated == true
)
.OrderByDescending(x => x.EffectiveDate)
.Select(i => i.EffectiveDate).FirstOrDefault()
).DefaultIfEmpty().Take(1)
select p
).FirstOrDefault();
#endregion
#region YachtInfomation
bool isCrewmember = false;
Yachts yachtOjb = _aqYachtContext.Yachts.FirstOrDefault(x => x.Id == yachtFIdde);
if (yachtOjb != null)
{
if (yachtOjb.CrewMembers > 0)
{
isCrewmember = true;
}
}
#endregion
#region INSERT INTO CHARTERING
YachtCharterings charteringModel = new YachtCharterings();
charteringModel.YachtFid = yachtFIdde;
charteringModel.SourceFid = 1;
charteringModel.SourceResKey = "SOURCEAQBOOKINGS";
charteringModel.UniqueId = UniqueIDHelper.GenarateRandomString(12);
//customer
charteringModel.CustomerName = bookingRequestModel.NameOfUser;
charteringModel.ReservationEmail = bookingRequestModel.EmailOfUser;
bool isUerExisting = false;
if (bookingRequestModel.IsEmailExist != 0)
{
isUerExisting = true;
}
charteringModel.IsExistingCustomer = isUerExisting;
if (bookingRequestModel.IdOfUser.Trim() != "")
{
charteringModel.CustomerFid = new Guid(bookingRequestModel.IdOfUser.Trim());
}
charteringModel.ContactNo = bookingRequestModel.ContactNo;
charteringModel.Passengers = yachtItem.Passenger;
charteringModel.CharterDateFrom = DateTime.Now;
charteringModel.CharterDateTo = DateTime.Now;
charteringModel.BookingDate = DateTime.Now;
//yacht port
if (responseYachtPort != null)
{
charteringModel.YachtPortFid = responseYachtPort.PortFid;
charteringModel.YachtPortName = responseYachtPort.PortName;
}
else
{
charteringModel.YachtPortFid = -1;
charteringModel.YachtPortName = "";
}
charteringModel.HaveCrewsMember = isCrewmember;
charteringModel.CultureCode = yachtCultureCode;
charteringModel.CurrencyCode = yachtCurrencyCode;
charteringModel.StatusFid = Convert.ToInt32(YachtCharterStatusEnum.Waiting);
charteringModel.StatusResKey = "WAITINGPAYMENT";
charteringModel.Processed = false;
_aqYachtContext.YachtCharterings.Add(charteringModel);
_aqYachtContext.SaveChanges();
long charteringModelId = charteringModel.Id;
#region logging
errGlobal.Id = Terminator.Encrypt(charteringModelId.ToString());
errGlobal.UniqueId = charteringModel.UniqueId;
#endregion
#endregion
#endregion
#region PACKAGE
bool isPackageAddition = false;
List <MerchantProductInventoriesModel> lstProductPackage = yachtItem.ProductPackage;
double dbPackageFee = 0;
double dbTotalFinalValue = 0;
double dbTotalGrandTotalValue = 0;
double dbTotalDiscountPackage = 0;
if (lstProductPackage != null)
{
List <string> lstProductId = lstProductPackage.Select(x => x.productInventoryFId).ToList();
var responsePriceOfProduct = _yachtMerchantProductInventoryService.GetPriceOfProductInventoryByArrayOfProductId(lstProductId);
if (responsePriceOfProduct != null && responsePriceOfProduct.IsSuccessStatusCode && responsePriceOfProduct.ResponseData != null)
{
foreach (MerchantProductInventoriesModel proItem in lstProductPackage)
{
#region logging Detail
//SaveCharterPaymentDetailViewModel errDetail = new SaveCharterPaymentDetailViewModel();
string dataSubLogging = "";
dataSubLogging += "{";
dataSubLogging += $"ProductInventoryFId:\"{proItem.productInventoryFId }\",";
dataSubLogging += $"Quantity:{ proItem.quantity}";
string ErrorDetailCode = "0";
string ErrorDetailPackageDescription = "";
#endregion
try
{
YachtMerchantProductInventoriesWithPriceViewModel reponseProduct = responsePriceOfProduct.ResponseData.FirstOrDefault(x => x.Id.Trim() == proItem.productInventoryFId.Trim());
if (reponseProduct != null)
{
MerchantPaymentEachPackageViewModel objPackageWithPrice = new MerchantPaymentEachPackageViewModel();
/**INSERT INTO CHARTERINGDETAIL**/
#region INSERT INTO CHARTERINGDETAIL
YachtCharteringDetails charteringDetailModel = new YachtCharteringDetails();
charteringDetailModel.CharteringFid = charteringModelId;
charteringDetailModel.YachtFid = yachtFIdde;
charteringDetailModel.ItemTypeFid = 1;
charteringDetailModel.ItemTypeResKey = "VENDORSERVICES";
charteringDetailModel.RefFid = Terminator.Decrypt(reponseProduct.Id).ToInt32();
charteringDetailModel.ItemName = reponseProduct.ProductName;
charteringDetailModel.CultureCode = reponseProduct.CultureCode;
charteringDetailModel.CurrencyCode = reponseProduct.CurrencyCode;
charteringDetailModel.OrderAmount = proItem.quantity;
charteringDetailModel.DiscountedValue = 0;
charteringDetailModel.OriginalValue = reponseProduct.Price;
charteringDetailModel.FinalValue = reponseProduct.Price - charteringDetailModel.DiscountedValue;
charteringDetailModel.GrandTotalValue = GlobalMethod.PackageTotal(charteringDetailModel.FinalValue, proItem.quantity);
// charteringDetailModel.FinalValue = charteringDetailModel.GrandTotalValue - charteringDetailModel.DiscountedValue;
_aqYachtContext.YachtCharteringDetails.Add(charteringDetailModel);
_aqYachtContext.SaveChanges();
#endregion
dbTotalFinalValue += charteringDetailModel.FinalValue;
dbTotalGrandTotalValue += charteringDetailModel.GrandTotalValue;
dbPackageFee += GlobalMethod.PackageTotal(charteringDetailModel.OriginalValue, proItem.quantity);
dbTotalDiscountPackage += GlobalMethod.PackageTotal(charteringDetailModel.DiscountedValue, proItem.quantity);
isPackageAddition = true;
}
ErrorDetailCode = "1";
}
catch (Exception ex)
{
#region logging add detail to errGlobal variable
ErrorDetailCode = "-1";
ErrorDetailPackageDescription = ex.Message.ToString();
#endregion
}
dataSubLogging += $"ErrorCode:{ ErrorDetailCode}";
dataSubLogging += $"ErrorDescription:{ ErrorDetailPackageDescription}";
dataSubLogging += "}";
#region ADD PACKAGE DETAIL ERROR TO THE YACHT ERROR.
if (ErrorGlobalPackageDescription != "")
{
ErrorGlobalPackageDescription += ",";
}
ErrorGlobalPackageDescription += dataSubLogging;
#endregion
}
responsePackageModel.PackageTotal = dbPackageFee;
responsePackageModel.DiscountTotal = responsePackageModel.DiscountTotal + dbTotalDiscountPackage;
responsePackageModel.Total = (responsePackageModel.PackageTotal + responsePackageModel.Total);
responsePackageModel.lstPaymentPackage = lstProductInventories;
}
}
#endregion
responsePackageModel.PrePaidRate = 0.5;
responsePackageModel.PrepaidValue = responsePackageModel.PrePaidRate * responsePackageModel.Total;
//***UPDATE CHARTERING PRICING
var newChartering = _aqYachtContext.YachtCharterings.FirstOrDefault(x => x.Id == charteringModelId);
if (newChartering != null)
{
newChartering.HaveAdditionalServices = isPackageAddition;
newChartering.PrepaidRate = responsePackageModel.PrePaidRate;
newChartering.PrepaidValue = responsePackageModel.PrepaidValue;
newChartering.GrandTotalValue = responsePackageModel.Total - responsePackageModel.DiscountTotal;
newChartering.DiscountedValue = responsePackageModel.DiscountTotal;
newChartering.OriginalValue = responsePackageModel.Total;
_aqYachtContext.SaveChanges();
}
//****INSERT TO PAYMENTLOGS TABLE
YachtCharteringPaymentLogs paymentLogs = new YachtCharteringPaymentLogs();
paymentLogs.CharteringFid = charteringModelId;
//call api payment from Mr Long
paymentLogs.PaymentBy = "";
paymentLogs.PaymentRef = "";
paymentLogs.PaymentMethod = PaymentMethod;
paymentLogs.PaymentDate = DateTime.Now;
paymentLogs.PaymentAmount = responsePackageModel.PrepaidValue;
paymentLogs.CultureCode = yachtCultureCode;
paymentLogs.CurrencyCode = yachtCurrencyCode;
paymentLogs.StatusFid = Convert.ToInt32(YachtCharterStatusEnum.Waiting);//wating for payment
_aqYachtContext.YachtCharteringPaymentLogs.Add(paymentLogs);
_aqYachtContext.SaveChanges();
#endregion
ErrorCode = "1";
}
catch (Exception ex)
{
ErrorCode = "-1";
ErrorDescription = ex.Message.ToString();
}
dataSubjectLogging += $"ErrorCode:{ErrorCode },";
dataSubjectLogging += $"ErrorDescription:{ErrorDescription }";
dataSubjectLogging += $"ErrorDetail:{ErrorGlobalPackageDescription }";
dataSubjectLogging += "}";
}
errGlobal.Value = dataSubjectLogging;
}
}
}
#endregion
}
#region logging
errCode = "1";
errGlobal.ResuldCode = errCode;
#endregion
return(BaseResponse <SaveCharterPaymentResponseViewModel> .Success(errGlobal));
}
catch (Exception ex)
{
errCode = "-1";
errGlobal.ResuldCode = errCode;
errGlobal.Describes = ex.Message.ToString();
return(BaseResponse <SaveCharterPaymentResponseViewModel> .InternalServerError(errGlobal, ex.Message));
}
}