public List <ContraEntryDepositedLookupDto> FederationContraEntryDepositedLookup()
{
List <ContraEntryDepositedLookupDto> lstContraEntryDepositedLookupDto = new List <ContraEntryDepositedLookupDto>();
List <uspFederationContraEntryDepositedLookup_Result> uspContraEntryDepositedLookup_Result = _dbContext.uspFederationContraEntryDepositedLookup().ToList();
foreach (var contraEntryDepositedLokup in uspContraEntryDepositedLookup_Result)
{
ContraEntryDepositedLookupDto contraEntryDepositedLookupDto = Mapper.Map <uspFederationContraEntryDepositedLookup_Result, ContraEntryDepositedLookupDto>(contraEntryDepositedLokup);
lstContraEntryDepositedLookupDto.Add(contraEntryDepositedLookupDto);
}
return(lstContraEntryDepositedLookupDto);
}
public List <ContraEntryDepositedLookupDto> GroupContraEntryDepositedLookup(int groupId, int userId)
{
List <ContraEntryDepositedLookupDto> lstContraDeposit = new List <ContraEntryDepositedLookupDto>();
ContraEntryDepositedLookupDto objContraDeposit = null;
SqlConnection con = new SqlConnection(DBConstants.MFIS_CS);
SqlCommand cmd = new SqlCommand("uspGroupContraEntryDepositedLookup", con);
cmd.Parameters.AddWithValue("@GroupId", groupId);
cmd.Parameters.AddWithValue("@UserId", userId);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objContraDeposit = new ContraEntryDepositedLookupDto();
objContraDeposit.AccountMasterID = Convert.ToInt32(dr["AccountMasterID"]);
objContraDeposit.VoucherNumber = Convert.ToString(dr["VoucherNumber"]);
objContraDeposit.AHName = Convert.ToString(dr["AHName"]);
objContraDeposit.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]);
objContraDeposit.Amount = Convert.ToDecimal(dr["Amount"]);
objContraDeposit.Narration = Convert.ToString(dr["Narration"]);
objContraDeposit.StatusCode = Convert.ToString(dr["StatusCode"]);
objContraDeposit.Status = Convert.ToString(dr["Status"]);
objContraDeposit.IsEdit = Convert.ToBoolean(dr["CanEdit"]);
objContraDeposit.IsDelete = Convert.ToBoolean(dr["CanDelete"]);
objContraDeposit.LockStatus = Convert.ToString(dr["LockStatus"]);
objContraDeposit.LockStatusCode = Convert.ToString(dr["LockStatusCode"]);
lstContraDeposit.Add(objContraDeposit);
}
return(lstContraDeposit);
}