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); }