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