public static List <CollectionDMCMDetail> GetCollectionDMCM(String dfdate, String dtdate, Decimal colCashInTarget)
{
var dbUtil = new DatabaseManager();
var colDMCM = new List <CollectionDMCMDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGenerateCollectionDMCMInitial";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@cashInTarget", colCashInTarget);
cmd.Parameters.AddWithValue("@dateProcessFrom", dfdate);
cmd.Parameters.AddWithValue("@dateProcessTo", dtdate);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var colDMCMs = new CollectionDMCMDetail
{
RegionID = ReferenceEquals(reader["RegionID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["RegionID"]),
RegionName = ReferenceEquals(reader["RegionName"], DBNull.Value) ? "" : Convert.ToString(reader["RegionName"]),
BranchID = ReferenceEquals(reader["BranchID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["BranchID"]),
BranchName = ReferenceEquals(reader["BranchName"], DBNull.Value) ? "" : Convert.ToString(reader["BranchName"]),
CashInTarget = ReferenceEquals(reader["CashInTarget"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInTarget"]),
///CashInTargetLastMonth = ReferenceEquals(reader["CashInTargetLastMonth"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInTargetLastMonth"]),
CashInActual = ReferenceEquals(reader["CashInActual"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInActual"]),
CashInActualLastMonth = ReferenceEquals(reader["CashInActualLastMonth"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInActualLastMonth"]),
Variance = ReferenceEquals(reader["Variance"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["Variance"]),
Percentage = ReferenceEquals(reader["Percentage"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["Percentage"]),
};
colDMCM.Add(colDMCMs);
}
}
}
}
return(colDMCM);
}
public static List <CollectionDMCMDetail> DisplaySelectedDataOnTheGrid(int id)
{
var dbUtil = new DatabaseManager();
var tempData = new List <CollectionDMCMDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spDisplaySelectedCollectionDMCMData";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var data = new CollectionDMCMDetail
{
RegionID = ReferenceEquals(reader["RegionID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["RegionID"]),
RegionName = ReferenceEquals(reader["RegionName"], DBNull.Value) ? "" : Convert.ToString(reader["RegionName"]),
BranchID = ReferenceEquals(reader["BranchID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["BranchID"]),
BranchName = ReferenceEquals(reader["BranchName"], DBNull.Value) ? "" : Convert.ToString(reader["BranchName"]),
CashInTarget = ReferenceEquals(reader["CashInTarget"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInTarget"]),
CashInTargetLastMonth = ReferenceEquals(reader["CashInTargetLastMonth"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInTargetLastMonth"]),
CashInActual = ReferenceEquals(reader["CashInActual"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInActual"]),
CashInActualLastMonth = ReferenceEquals(reader["CashInActualLastMonth"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["CashInActualLastMonth"]),
Variance = ReferenceEquals(reader["Variance"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["Variance"]),
Percentage = ReferenceEquals(reader["Percentage"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["Percentage"])
};
tempData.Add(data);
}
}
}
}
return(tempData);
}
