public ActionResult MemberReceiptView(string Id)
{
GroupMemberReceiptViewDto grpMemberReceiptDto = new GroupMemberReceiptViewDto();
int AccountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt32(Id.DecryptString());
grpMemberReceiptDto = _groupMemberReceiptService.GetGroupMemberReceiptViewDetails(AccountMasterId);
return(View(grpMemberReceiptDto));
}
public GroupMemberReceiptViewDto GetGroupMemberReceiptViewDetails(int AccountMasterId)
{
SqlConnection con = new SqlConnection(DBConstants.MFIS_CS);
SqlCommand cmd = new SqlCommand("uspGetGroupMemberReceiptView", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AccountMasterId", AccountMasterId);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
GroupMemberReceiptViewDto recptDto = null;
if (dr.Read())
{
recptDto = new GroupMemberReceiptViewDto();
recptDto.MemberName = Convert.ToString(dr["MemberName"]);
recptDto.TransactionMode = Convert.ToString(dr["TransactionMode"]);
recptDto.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]);
recptDto.TotalAmount = Convert.ToDecimal(dr["Amount"]);
recptDto.VoucherNumber = Convert.ToString(dr["VoucherNumber"]);
recptDto.VoucherRefNumber = Convert.ToString(dr["VoucherRefNumber"]);
recptDto.CollectionAgentName = Convert.ToString(dr["EmployeeName"]);
recptDto.BankAccountHead = Convert.ToString(dr["BankAccount"]);
if (!Convert.IsDBNull(dr["ChequeDate"]))
{
recptDto.ChequeDate = Convert.ToDateTime(dr["ChequeDate"]);
}
recptDto.ChequeNumber = Convert.ToString(dr["ChequeNumber"]);
recptDto.Narration = Convert.ToString(dr["Narration"]);
}
if (dr.NextResult())
{
recptDto.Transactions = new List <GroupMemberReceiptTranDto>();
GroupMemberReceiptTranDto objTran = null;
while (dr.Read())
{
objTran = new GroupMemberReceiptTranDto();
objTran.Amount = Convert.ToDecimal(dr["Amount"]);
objTran.GLAccount = Convert.ToString(dr["GLAHName"]);
objTran.SLAccount = Convert.ToString(dr["SLAHName"]);
recptDto.Transactions.Add(objTran);
}
}
return(recptDto);
}
public GroupMemberReceiptViewDto GetGroupMemberReceiptViewDetails(int AccountMasterId)
{
GroupMemberReceiptViewDto groupMemberReceiptDto = _groupMemberReceiptDal.GetGroupMemberReceiptViewDetails(AccountMasterId);
return(groupMemberReceiptDto);
}
