public ChitSubscriberDueModel Get(string AccessId)
{
var data = _unitOfWork.GetRepository <ChitSubscriberDueTable>().Single(x => x.AccessId == AccessId, include: x => x.Include(x => x.DueAmountInfo).ThenInclude(x => x.Voucher).Include(x => x.ChitSubscriber).ThenInclude(x => x.Customer).ThenInclude(x => x.Contact).Include(x => x.ChitSubscriber).ThenInclude(x => x.Agent).ThenInclude(x => x.Contact).Include(x => x.ChitSubscriber).ThenInclude(x => x.ChitGroup));
ChitSubscriberDueModel chit = new ChitSubscriberDueModel
{
AccessId = data.AccessId,
ChitSubscriber = new ChitSubscriberModel
{
AccessId = data.ChitSubscriber.AccessId,
Customer = new CustomerModel
{
AccessId = data.ChitSubscriber.Customer.AccessId,
ContactKeyId = data.ChitSubscriber.Customer.Contact.KeyId,
FirstName = data.ChitSubscriber.Customer.Contact.FirstName,
LastName = data.ChitSubscriber.Customer.Contact.LastName,
MobileNo = data.ChitSubscriber.Customer.Contact.MobileNumber
},
Agent = new AgentModel {
AccessId = data.ChitSubscriber.Agent.AccessId
},
ChitGroup = new ChitGroupModel {
AccessId = data.ChitSubscriber.ChitGroup.AccessId
}
},
Amount = data.DueAmountInfo.Amount,
TransactionDate = data.DueAmountInfo.Voucher.VoucherDate
};
return(chit);
}
private ChitSubscriberDueModel GetCurrentSubcriberDue()
{
Validate();
var model = new ChitSubscriberDueModel {
ChitSubscriberKeyId = SelectedChitSubscriber.KeyId, TransactionDate = BillDate, Amount = this.PaymentAmount, AccessId = this.AccessId
};
return(model);
}
public void Insert(ChitSubscriberDueModel chitSubscriberDueModel)
{
var voucherModel = new VoucherTable {
KeyId = Guid.NewGuid(), VoucherDate = System.DateTime.Now
};
_unitOfWork.GetRepository <VoucherTable>().Add(voucherModel);
string st = Reflection.GetPropFullName(new ChitSubscriberDueTable(), "DueAmountInfoKeyId");
if (st != "")
{
AccountBookFieldMapTable row = _unitOfWork.GetRepository <AccountBookFieldMapTable>().Single(x => x.FieldNameKey == st);
var CashBook = _unitOfWork.GetRepository <AccountBookTable>().Single(x => x.ProgId == AccountBookProgs.CashBook);
if (row != null && CashBook != null)
{
string AccessId = int.Parse(chitSubscriberDueModel.AccessId).ToString();
var voucherInfoModelCr = new VoucherInfoTable {
KeyId = Guid.NewGuid(), VoucherKeyId = voucherModel.KeyId, AccountBookKeyId = row.AccountBookKeyId, Amount = chitSubscriberDueModel.Amount, IsCredit = true
};
var voucherInfoModelDr = new VoucherInfoTable {
KeyId = Guid.NewGuid(), VoucherKeyId = voucherModel.KeyId, AccountBookKeyId = CashBook.KeyId, Amount = chitSubscriberDueModel.Amount, IsCredit = false
};
_unitOfWork.GetRepository <VoucherInfoTable>().Add(voucherInfoModelCr);
_unitOfWork.GetRepository <VoucherInfoTable>().Add(voucherInfoModelDr);
_unitOfWork.GetRepository <ChitSubscriberDueTable>().Add(new ChitSubscriberDueTable {
KeyId = Guid.NewGuid(), AccessId = chitSubscriberDueModel.AccessId, ChitSubscriberKeyId = chitSubscriberDueModel.ChitSubscriberKeyId, DueAmountInfoKeyId = voucherInfoModelCr.KeyId
});
_unitOfWork.SaveChanges();
}
}
else
{
throw new Exception("Account Book not Configured");
}
}
public void Update(ChitSubscriberDueModel chitSubscriberModel)
{
throw new NotImplementedException();
}