public List <DailyLedger> GetPrevieByTransactionId(int?TransactionId) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; List <DailyLedger> objDailyLedgerList = new List <DailyLedger>(); DailyLedger objDailyLedger = new DailyLedger(); try { objDbCommand.AddInParameter("TransactionId", TransactionId); objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[dbo].[uspPreviewByTransactionId]", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { while (objDbDataReader.Read()) { objDailyLedger = new DailyLedger(); objDailyLedger.TransactionId = objDbDataReader["TransactionId"].ToString(); objDailyLedger.TransactionDateShow = string.Format("{0:dd/MMM/yyyy}", objDbDataReader["TransactionDate"].ToString()); objDailyLedger.CustomerName = objDbDataReader["CustomerName"].ToString(); objDailyLedger.SupplierName = objDbDataReader["SupplierName"].ToString(); objDailyLedger.ExpenseType = objDbDataReader["ExpenseType"].ToString(); objDailyLedger.DebitAmount = Convert.ToDecimal(objDbDataReader["DebitAmount"]); objDailyLedger.CreditAmount = Convert.ToDecimal(objDbDataReader["CreditAmount"]); objDailyLedgerList.Add(objDailyLedger); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objDailyLedgerList); }
public List <DailyLedger> GetPartyNameByAccountType(string AccountType) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; List <DailyLedger> objDailyLedgerList = new List <DailyLedger>(); DailyLedger objDailyLedger = new DailyLedger(); try { objDbCommand.AddInParameter("AccountType", AccountType); objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[dbo].[uspGetPartyNameByAccountType]", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { while (objDbDataReader.Read()) { objDailyLedger = new DailyLedger(); this.BuildModelForBuildModelForChequeDetail(objDbDataReader, objDailyLedger); objDailyLedgerList.Add(objDailyLedger); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objDailyLedgerList); }
private void BuildModelForBuildModelForChequeDetail(DbDataReader objDataReader, DailyLedger objDailyLedger) { DataTable objDataTable = objDataReader.GetSchemaTable(); foreach (DataRow dr in objDataTable.Rows) { String column = dr.ItemArray[0].ToString(); switch (column) { case "DailyLedgerId": if (!Convert.IsDBNull(objDataReader["DailyLedgerId"])) { objDailyLedger.DailyLedgerId = Convert.ToInt32(objDataReader["DailyLedgerId"]); } break; case "TransationDate": if (!Convert.IsDBNull(objDataReader["TransationDate"])) { objDailyLedger.TransactionDate = Convert.ToDateTime(objDataReader["TransationDate"].ToString()); } break; case "AccountType": if (!Convert.IsDBNull(objDataReader["AccountType"])) { objDailyLedger.AccountType = objDataReader["AccountType"].ToString(); } break; case "PartyId": if (!Convert.IsDBNull(objDataReader["PartyId"])) { objDailyLedger.PartyId = Convert.ToByte(objDataReader["PartyId"]); } break; case "PartyName": if (!Convert.IsDBNull(objDataReader["PartyName"])) { objDailyLedger.PartyName = objDataReader["PartyName"].ToString(); } break; case "LedgerEntryType": if (!Convert.IsDBNull(objDataReader["LedgerEntryType"])) { objDailyLedger.LedgerEntryType = objDataReader["LedgerEntryType"].ToString(); } break; case "DebitAmount": if (!Convert.IsDBNull(objDataReader["DebitAmount"])) { objDailyLedger.DebitAmount = Convert.ToDecimal(objDataReader["DebitAmount"]); } break; case "CreditAmount": if (!Convert.IsDBNull(objDataReader["CreditAmount"])) { objDailyLedger.CreditAmount = Convert.ToDecimal(objDataReader["CreditAmount"].ToString()); } break; case "Remarks": if (!Convert.IsDBNull(objDataReader["Remarks"])) { objDailyLedger.Remarks = objDataReader["Remarks"].ToString(); } break; default: break; } } }