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