public List <GeneralPaymentsLookupDto> GroupGeneralPaymentLookUp(int groupId, int userId)
{
List <GeneralPaymentsLookupDto> lstGroupGeneralPayments = new List <GeneralPaymentsLookupDto>();
GeneralPaymentsLookupDto objGp = null;
SqlConnection con = new SqlConnection(DBConstants.MFIS_CS);
SqlCommand cmd = new SqlCommand("uspGroupGeneralPaymentsLookup", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@GroupID", groupId);
cmd.Parameters.AddWithValue("@UserId", userId);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objGp = new GeneralPaymentsLookupDto();
objGp.AccountMasterID = Convert.ToInt64(dr["AccountMasterID"]);
objGp.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]);
objGp.VoucherNumber = Convert.ToString(dr["VoucherNumber"]);
objGp.AHName = Convert.ToString(dr["AHName"]);
//objGp.MemberName = Convert.ToString(dr["MemberName"]);
objGp.Amount = Convert.ToDecimal(dr["Amount"]);
objGp.Narration = Convert.ToString(dr["Narration"]);
objGp.StatusCode = Convert.ToString(dr["StatusCode"]);
objGp.Status = Convert.ToString(dr["Status"]);
objGp.IsEdit = Convert.ToBoolean(dr["CanEdit"]);
objGp.IsDelete = Convert.ToBoolean(dr["CanDelete"]);
objGp.LockStatus = Convert.ToString(dr["LockStatus"]);
objGp.LockStatusCode = Convert.ToString(dr["LockStatusCode"]);
lstGroupGeneralPayments.Add(objGp);
}
return(lstGroupGeneralPayments);
}
public List <GeneralPaymentsLookupDto> Lookup()
{
List <GeneralPaymentsLookupDto> lstGeneralPaymentsLookupDto = new List <GeneralPaymentsLookupDto>();
List <uspFederationGeneralPaymentsLookup_Result> lstuspGeneralPaymentsLookup_Result = _dbContext.uspFederationGeneralPaymentsLookup().ToList();
foreach (var GeneralPayments in lstuspGeneralPaymentsLookup_Result)
{
GeneralPaymentsLookupDto GeneralpaymentsDto = Mapper.Map <uspFederationGeneralPaymentsLookup_Result, GeneralPaymentsLookupDto>(GeneralPayments);
lstGeneralPaymentsLookupDto.Add(GeneralpaymentsDto);
}
return(lstGeneralPaymentsLookupDto);
}
