} //========== end of the mtd
public IEnumerable <Models.IncomeAdjustmentSummaryModel> IncomeAdjustmentGetSBUSummary(int pr, int yr, string cp)
{
cp = cp.Replace("FORWARDSLASHXTER", "/");
cp = cp.Replace("DOTXTER", ".");
List <IncomeAdjustmentSummaryModel> obList = new List <IncomeAdjustmentSummaryModel>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("Income_Adjustment_GetSBUSummary", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Year",
Value = yr,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Period",
Value = pr,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Caption",
Value = cp,
});
con.Open();
//cmd.ExecuteNonQuery();
//cmd2.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var ob = new IncomeAdjustmentSummaryModel();
//iob.ID = reader["ID"] != DBNull.Value ? int.Parse(reader["ID"].ToString()) : 0;
ob.sbu_Code = reader["sbu_Code"] != DBNull.Value ? reader["sbu_Code"].ToString() : "default";
ob.SBUName = reader["SBUName"] != DBNull.Value ? reader["SBUName"].ToString() : "default";
ob.ActualBalance = reader["Actual"] != DBNull.Value ? decimal.Parse(reader["Actual"].ToString()) : 0;
ob.AverageBalance = reader["Average"] != DBNull.Value ? decimal.Parse(reader["Average"].ToString()) : 0;
ob.Rev_Exp = reader["RevExp"] != DBNull.Value ? decimal.Parse(reader["RevExp"].ToString()) : 0;
obList.Add(ob);
}
con.Close();
}
return(obList);
} //========== end of the mtd
} //========== end of the mtd
public IEnumerable <Models.IncomeAdjustmentSummaryModel> GetIncomeAdjustmentVolProdSummary(int pr, int yr)
{
List <IncomeAdjustmentSummaryModel> obList = new List <IncomeAdjustmentSummaryModel>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("Income_Adjustment_VolProdSummary", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Year",
Value = yr,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Period",
Value = pr,
});
con.Open();
//cmd.ExecuteNonQuery();
//cmd2.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var ob = new IncomeAdjustmentSummaryModel();
//iob.ID = reader["ID"] != DBNull.Value ? int.Parse(reader["ID"].ToString()) : 0;
ob.ProductCode = reader["ProductCode"] != DBNull.Value ? reader["ProductCode"].ToString() : "default";
ob.Caption = reader["Caption"] != DBNull.Value ? reader["Caption"].ToString() : "default";
ob.ActualBalance = reader["Actual"] != DBNull.Value ? decimal.Parse(reader["Actual"].ToString()) : 0;
ob.AverageBalance = reader["Average"] != DBNull.Value ? decimal.Parse(reader["Average"].ToString()) : 0;
ob.Rev_Exp = reader["RevExp"] != DBNull.Value ? decimal.Parse(reader["RevExp"].ToString()) : 0;
ob.Category = reader["Category"] != DBNull.Value ? reader["Category"].ToString() : "default";
ob.CurrencyType = reader["Currency_Type"] != DBNull.Value ? reader["Currency_Type"].ToString() : "default";
ob.Period = reader["Period"] != DBNull.Value ? int.Parse(reader["Period"].ToString()) : 0;
ob.Year = reader["Year"] != DBNull.Value ? int.Parse(reader["Year"].ToString()) : 0;
obList.Add(ob);
}
con.Close();
}
return(obList);
} //========== end of the mtd
