private IList <Dependent> DependentMapper(NewMembersFrom f, Member member)
{
List <Dependent> dependents = new List <Dependent>();
if (!string.IsNullOrEmpty(f.FirstDependent_CardId) &&
!string.IsNullOrEmpty(f.FirstDependent_FirstName)
)
{
dependents.Add(
new Dependent
{
CreatedDate = f.CreatedDate,
Gender = ParseGender(f.FirstDependent_Gender.Trim()),
IsDeleted = false,
MembershipEndDate = member.MembershipEndDate,
MembershipStartDate = member.MembershipStartDate,
Status = true,
UpdatedDate = DateTime.Now,
CardId = f.FirstDependent_CardId.Replace(" ", "-"),
Email = f.FirstDependent_Email,
ImagePath = f.FirstDependent_ImagePath,
IpAddress = "",
MemberId = member.Id,
FirstName = f.FirstDependent_FirstName,
MiddleName = f.FirstDependent_MiddleName,
LastName = f.FirstDependent_LastName,
MobileNumber = f.FirstDependent_MobileNumber,
DependentDOB = ParseDate(f.FirstDependent_DOB)
}
);
}
if (!string.IsNullOrEmpty(f.SecondDependent_CardId) &&
!string.IsNullOrEmpty(f.SecondDependent_FirstName)
)
{
dependents.Add(
new Dependent
{
CreatedDate = f.CreatedDate,
Gender = ParseGender(f.SecondDependent_Gender.Trim()),
IsDeleted = false,
MembershipEndDate = member.MembershipEndDate,
MembershipStartDate = member.MembershipStartDate,
Status = true,
UpdatedDate = DateTime.Now,
CardId = f.SecondDependent_CardId.Replace(" ", "-"),
Email = f.SecondDependent_Email,
ImagePath = f.SecondDependent_ImagePath,
IpAddress = "",
MemberId = member.Id,
FirstName = f.SecondDependent_FirstName,
MiddleName = f.SecondDependent_MiddleName,
LastName = f.SecondDependent_LastName,
MobileNumber = f.SecondDependent_MobileNumber,
DependentDOB = ParseDate(f.SecondDependent_DOB)
}
);
}
return(dependents);
}
private Member MemberMapper(NewMembersFrom f)
{
return(new Member
{
//Id = f.Member_Id,
CreatedDate = f.CreatedDate,
Gender = ParseGender(f.Member_Gender.Trim()),
IsDeleted = false,
MembershipEndDate = f.Member_MembershipEndDate,
MembershipStartDate = f.Member_MembershipStartDate,
Status = true,
UpdatedDate = DateTime.Now,
CardId = f.Member_CardId.Replace(" ", "-"),
Email = f.Member_Email,
ImagePath = f.Member_ImagePath,
IpAddress = null,
//RowVersion =
AccountId = f.Member_AccountId,
ReferredBy = ParseReferredBy(f.Member_ReferredBy.Trim()),
MembershipType = ParseCategory(f.Member_MembershipType.Trim()),
Title = ParseTitle(f.Member_Title),
FirstName = f.Member_FirstName,
MiddleName = f.Member_MiddleName,
LastName = f.Member_LastName,
ProfessionalTitle = f.Member_ProfessionalTitle,
Designation = f.Member_Designation,
Organization = f.Member_Designation,
TelephoneNumber = f.Member_PresentTelephone,
PresentAddress = f.Member_PresentAddress,
PresentCity = f.Member_PresentCity,
PresentState = f.Member_PresentState,
PresentPin = f.Member_PresentPin,
PermanentAddress = f.Member_PermanentAddress,
PermanentCity = f.Member_PermanentCity,
PermanentState = f.Member_PermanentState,
PermanentPin = f.Member_PermanentPin,
PrimaryMobileNumber = f.Member_PrimaryMobileNumber,
SecondaryMobileNumber = f.Member_SecondaryMobileNumber,
Location = f.Member_LocationId,
LocationId = ParseLocation(f.Member_LocationId.Trim()),
FormPath = null,
CreatedBy = "Exported",
MaritalStatus = ParseMaritalStatus(f.Member_MaritalStatus.Trim()),
Occupation = ParseOccupation(f.Member_Occupation.Trim()),
SponcerId = 0,
Addressed = f.Member_Addressed,
MemberDOB = ParseDate(f.Member_DOB),
AnnualIncome = ParseDecimal(f.Member_AnnualIncome)
});
}
private Spouse SpouseMapper(NewMembersFrom f, Member member)
{
if (string.IsNullOrEmpty(f.Spouse_CardId) &&
string.IsNullOrEmpty(f.Spouse_FirstName))
{
return(null);
}
return(new Spouse
{
CreatedDate = f.CreatedDate,
Gender = ParseGender(f.Spouse_Gender.Trim()),
//Id
IsDeleted = false,
MembershipEndDate = member.MembershipEndDate,
MembershipStartDate = member.MembershipStartDate,
Status = true,
UpdatedDate = DateTime.Now,
CardId = f.Spouse_CardId.Replace(" ", "-"),
Email = f.Spouse_Email,
ImagePath = f.Spouse_ImagePath,
IpAddress = null,
//RowVersion = null,
MemberId = member.Id,
Title = ParseTitle(f.Spouse_Title.Trim()),
FirstName = f.Spouse_FirstName,
MiddleName = f.Spouse_MiddleName,
LastName = f.Spouse_LastName,
PrimaryMobileNumber = f.Spouse_PrimaryMobileNumber,
SecondaryMobileNumber = f.Spouse_SecondaryMobileNumber,
TelephoneNumber = f.Spouse_PresentTelephone,
ProfessionalTitle = f.Spouse_ProfessionalTitle,
Designation = f.Spouse_Designation,
Organization = f.Spouse_Organization,
PresentAddress = f.Spouse_PresentAddress,
PresentCity = f.Spouse_PresentCity,
PresentState = f.Spouse_PresentState,
PresentPin = f.Spouse_PresentPin,
PermanentAddress = f.Spouse_PermanentAddress,
PermanentCity = f.Spouse_PermanentCity,
PermanentState = f.Spouse_PermanentState,
PermanentPin = f.Spouse_PermanentPin,
MaritalStatus = ParseMaritalStatus(f.Spouse_MaritalStatus.Trim()),
Occupation = ParseOccupation(f.Spouse_Occupation.Trim()),
SponcerId = 0,
Addressed = f.Spouse_Addressed,
SpouseDOB = ParseDate(f.Spouse_DOB),
AnnualIncome = ParseDecimal(f.Spouse_AnnualIncome)
});
}
private IList <Cheque> ChequeMapper(NewMembersFrom f)
{
List <Cheque> cheques = new List <Cheque>();
cheques.Add(
new Cheque
{
DrawnOn = f.FirstCheque_DrawnOn,
Date = ParseDate(f.FirstCheque_Date),
Number = f.FirstCheque_Number,
Amount = ParseDecimal(f.ChequeTotalAmount),
ChequeStatus = ParsePaymentStatus(f.PaymentStatus.Trim())
}
);
return(cheques);
}
private Member ObjectMapper(NewMembersFrom form)
{
Member member = MemberMapper(form);
Spouse spouse = SpouseMapper(form, member);
IList <Dependent> dependents = DependentMapper(form, member);
Payment payment = PaymentMapper(form, member);
if (spouse != null)
{
member.Spouse = spouse;
}
if (dependents != null && dependents.Count > 0)
{
member.Dependents = dependents;
}
member.Payments = payment;
return(member);
}
public async Task <IActionResult> ExportAsync([FromBody] string values)
{
if (string.IsNullOrEmpty(values) &&
values.Split(',').Count() == 0)
{
return(BadRequest("no ids available to export"));
}
List <string> result = new List <string>();
string[] items = values.Split(',');
for (int i = 0; i < items.Length; i++)
{
int id = Convert.ToInt32(items[i]);
NewMembersFrom form = _oForms.SingleOrDefault(m => m.Member_Id == id);
Member member = ObjectMapper(form);
try
{
await _dbContext.Members.AddAsync(member);
int x = await _dbContext.SaveChangesAsync();
if (x > 0)
{
result.Add($"Success: {member.AccountId}");
}
else
{
result.Add($"Success but not added: {member.AccountId}");
}
}
catch (Exception e)
{
result.Add($"Failed: {member.AccountId}, due to {e.Message}");
}
}
return(Ok($"'Success' : {string.Join(",", result)}"));
}
private Payment PaymentMapper(NewMembersFrom f, Member member)
{
Payment p = new Payment();
p.Created = "Exported";
p.CreatedDate = member.CreatedDate;
p.UpdatedDate = DateTime.Now;
p.IsDeleted = false;
p.IpAddress = "";
p.MemberId = member.Id;
p.PaymentMode = ParsePaymentMode(f.PaymentMode.Trim());
switch (p.PaymentMode)
{
//For BankTransfer
case 1:
p.GST = f.BankTransferGST;
p.TaxAmount = ParseDecimal(f.BankTransferTaxAmount);
p.MembershipFee = ParseDecimal(f.BankMembershipFee);
p.TotalAmount = ParseDecimal(f.BankTransferTotalAmount);
p.TransactionId = f.BankRRN;
p.PaymentStatus = ParsePaymentStatus(f.PaymentStatus.Trim());
break;
//For Cash
case 2:
p.GST = f.CashGST;
p.TaxAmount = ParseDecimal(f.CashTaxAmount);
p.MembershipFee = ParseDecimal(f.CreditCardMembershipFee);
p.TotalAmount = ParseDecimal(f.CreditCardTotalAmount);
p.TransactionId = "";
p.PaymentStatus = ParsePaymentStatus(f.PaymentStatus.Trim());
break;
//For Cheque
case 3:
p.GST = f.ChequeGST;
p.TaxAmount = ParseDecimal(f.ChequeTaxAmount);
p.TotalAmount = ParseDecimal(f.ChequeTotalAmount);
p.MembershipFee = (p.TotalAmount - p.TaxAmount);
p.Cheques = ChequeMapper(f);
break;
//For credit card
case 4:
p.PayeeName = f.NameOnCreditCard;
p.GST = f.CreditCardGST;
p.TaxAmount = ParseDecimal(f.CreditCardTaxAmount);
p.MembershipFee = ParseDecimal(f.CreditCardMembershipFee);
p.TotalAmount = ParseDecimal(f.CashTotalAmount);
p.TransactionId = f.BankRRN;
p.PaymentStatus = ParsePaymentStatus(f.PaymentStatus.Trim());
break;
default:
break;
}
p.PaymentDate = ParseDate(f.PaymentDate);
p.IsDiscountApplicable = (f.Payment_MembershipType == "complementry") ? true : false;
p.Description = f.Description;
p.BankName = "";
p.PaymentRecievedBy = $"{f.CreditCardPaymentRecievedBy}, {f.PaymentRecievedBy} ";
return(p);
}
