public static List <CashPositionDetail> DisplaySelectedDataOnTheGrid(int id)
{
var dbUtil = new DatabaseManager();
var tempData = new List <CashPositionDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spCashPosition_DisplaySelectedDataOnTheGrid";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var data = new CashPositionDetail
{
intIDCashPosition = ReferenceEquals(reader["intIDCashPosition"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDCashPosition"]),
Title = ReferenceEquals(reader["Title"], DBNull.Value) ? "" : Convert.ToString(reader["Title"]),
RestrictedAmount = ReferenceEquals(reader["RestrictedAmount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["RestrictedAmount"]),
BalanceThisMonth = ReferenceEquals(reader["BalanceThisMonth"], DBNull.Value) ? 0.00 : Convert.ToDouble(reader["BalanceThisMonth"]),
BalanceLastMonth = ReferenceEquals(reader["BalanceLastMonth"], DBNull.Value) ? 0.00 : Convert.ToDouble(reader["BalanceLastMonth"]),
Type = ReferenceEquals(reader["Type"], DBNull.Value) ? "" : Convert.ToString(reader["Type"])
};
tempData.Add(data);
}
}
}
}
return(tempData);
}
public static List <CashPositionDetail> GenCashPosition(String dtdateGen, Decimal restrictedAmount)
{
var dbUtil = new DatabaseManager();
var cashPosition = new List <CashPositionDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGenerateCashPosition";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@dateGen", dtdateGen);
cmd.Parameters.AddWithValue("@restrictedAmount", restrictedAmount);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var cashPo = new CashPositionDetail
{
Title = ReferenceEquals(reader["Title"], DBNull.Value) ? "" : Convert.ToString(reader["Title"]),
RestrictedAmount = ReferenceEquals(reader["RestrictedAmount"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["RestrictedAmount"]),
BalanceThisMonth = ReferenceEquals(reader["BalanceThisMonth"], DBNull.Value) ? 0.00 : Convert.ToDouble(reader["BalanceThisMonth"]),
BalanceLastMonth = ReferenceEquals(reader["BalanceLastMonth"], DBNull.Value) ? 0.00 : Convert.ToDouble(reader["BalanceLastMonth"]),
BalanceEndLastMonth = ReferenceEquals(reader["BalanceEndLastMonth"], DBNull.Value) ? 0.00 : Convert.ToDouble(reader["BalanceEndLastMonth"]), //newly added 03182015@1:47PM
Type = ReferenceEquals(reader["Type"], DBNull.Value) ? "" : Convert.ToString(reader["Type"])
};
cashPosition.Add(cashPo);
}
}
}
}
return(cashPosition);
}
