public List <ContraEntryWithDrawlLookupDto> FederationContraEntryWithDrawlLookup() { List <ContraEntryWithDrawlLookupDto> lstFederationContraEntryWithDrawlLookupDto = new List <ContraEntryWithDrawlLookupDto>(); List <uspFederationContraEntryWithDrawlLookup_Result> objFederationContraEntryWithDrawlLookup_Result = _dbContext.uspFederationContraEntryWithDrawlLookup().ToList(); foreach (var contraEntryWithDrawlLokup in objFederationContraEntryWithDrawlLookup_Result) { ContraEntryWithDrawlLookupDto contraEntryWithDrawlLookupDto = Mapper.Map <uspFederationContraEntryWithDrawlLookup_Result, ContraEntryWithDrawlLookupDto>(contraEntryWithDrawlLokup); lstFederationContraEntryWithDrawlLookupDto.Add(contraEntryWithDrawlLookupDto); } return(lstFederationContraEntryWithDrawlLookupDto); }
public List <ContraEntryWithDrawlLookupDto> GroupContraEntryWithDrawlLookup(int groupId, int userId) { List <ContraEntryWithDrawlLookupDto> lstContraWithDraw = new List <ContraEntryWithDrawlLookupDto>(); ContraEntryWithDrawlLookupDto objContraWithDraw = null; SqlConnection con = new SqlConnection(DBConstants.MFIS_CS); SqlCommand cmd = new SqlCommand("uspGroupContraEntryWithDrawlLookup", con); cmd.Parameters.AddWithValue("@GroupId", groupId); cmd.Parameters.AddWithValue("@UserId", userId); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objContraWithDraw = new ContraEntryWithDrawlLookupDto(); objContraWithDraw.AccountMasterID = Convert.ToInt32(dr["AccountMasterID"]); objContraWithDraw.VoucherNumber = Convert.ToString(dr["VoucherNumber"]); objContraWithDraw.AHName = Convert.ToString(dr["AHName"]); objContraWithDraw.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]); objContraWithDraw.Amount = Convert.ToDecimal(dr["Amount"]); objContraWithDraw.Narration = Convert.ToString(dr["Narration"]); objContraWithDraw.StatusCode = Convert.ToString(dr["StatusCode"]); objContraWithDraw.Status = Convert.ToString(dr["Status"]); objContraWithDraw.IsEdit = Convert.ToBoolean(dr["CanEdit"]); objContraWithDraw.IsDelete = Convert.ToBoolean(dr["CanDelete"]); objContraWithDraw.LockStatus = Convert.ToString(dr["LockStatus"]); objContraWithDraw.LockStatusCode = Convert.ToString(dr["LockStatusCode"]); lstContraWithDraw.Add(objContraWithDraw); } return(lstContraWithDraw); }