public static string ManageInsert(NameValueCollection querystring)
{
decimal decimalParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var BnkRecon = new MCPlanQuotaDetail
{
MCQuotaDetailID = querystring.Get("MCQuotaDetailID"),
MCQuotaHdrID = querystring.Get("MCQuotaHdrID"),
QuotaBranchID = querystring.Get("BranchID"),
QuotaYear = querystring.Get("QuotaYear"),
Jan = decimal.TryParse(querystring.Get("Jan"), out decimalParser) ? decimalParser : 0,
Feb = decimal.TryParse(querystring.Get("Feb"), out decimalParser) ? decimalParser : 0,
Mar = decimal.TryParse(querystring.Get("Mar"), out decimalParser) ? decimalParser : 0,
Apr = decimal.TryParse(querystring.Get("Apr"), out decimalParser) ? decimalParser : 0,
May = decimal.TryParse(querystring.Get("May"), out decimalParser) ? decimalParser : 0,
Jun = decimal.TryParse(querystring.Get("Jun"), out decimalParser) ? decimalParser : 0,
Jul = decimal.TryParse(querystring.Get("Jul"), out decimalParser) ? decimalParser : 0,
Aug = decimal.TryParse(querystring.Get("Aug"), out decimalParser) ? decimalParser : 0,
Sep = decimal.TryParse(querystring.Get("Sep"), out decimalParser) ? decimalParser : 0,
Oct = decimal.TryParse(querystring.Get("Oct"), out decimalParser) ? decimalParser : 0,
Nov = decimal.TryParse(querystring.Get("Nov"), out decimalParser) ? decimalParser : 0,
Dec = decimal.TryParse(querystring.Get("Dec"), out decimalParser) ? decimalParser : 0,
};
string param = WebCommon.ToXML(BnkRecon);
return(MCPlanQuotaDAL.ManageInsert(param));
}
public static List <MCPlanQuotaDetail> GetPlan(int hdrID)
{
var dbUtil = new DatabaseManager();
var brDetail = new List <MCPlanQuotaDetail>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spMCPlanQuotaGetPlan";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDQuota", hdrID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var brdtl = new MCPlanQuotaDetail
{
MCQuotaDetailID = ReferenceEquals(reader["MCQuotaDetailID"], String.Empty) ? String.Empty : (string)reader["MCQuotaDetailID"],
MCQuotaHdrID = ReferenceEquals(reader["MCQuotaHdrID"], String.Empty) ? String.Empty : (string)reader["MCQuotaHdrID"],
QuotaBranchID = ReferenceEquals(reader["QuotaBranchID"], String.Empty) ? String.Empty : (string)reader["QuotaBranchID"],
QuotaBranchName = ReferenceEquals(reader["QuotaBranchName"], String.Empty) ? String.Empty : (string)reader["QuotaBranchName"],
QuotaYear = ReferenceEquals(reader["QuotaYear"], String.Empty) ? String.Empty : (string)reader["QuotaYear"],
Jan = ReferenceEquals(reader["Jan"], 0) ? 0 : (decimal)reader["Jan"],
Feb = ReferenceEquals(reader["Feb"], 0) ? 0 : (decimal)reader["Feb"],
Mar = ReferenceEquals(reader["Mar"], 0) ? 0 : (decimal)reader["Mar"],
Apr = ReferenceEquals(reader["Apr"], 0) ? 0 : (decimal)reader["Apr"],
May = ReferenceEquals(reader["May"], 0) ? 0 : (decimal)reader["May"],
Jun = ReferenceEquals(reader["Jun"], 0) ? 0 : (decimal)reader["Jun"],
Jul = ReferenceEquals(reader["Jul"], 0) ? 0 : (decimal)reader["Jul"],
Aug = ReferenceEquals(reader["Aug"], 0) ? 0 : (decimal)reader["Aug"],
Sep = ReferenceEquals(reader["Sep"], 0)? 0 : (decimal)reader["Sep"],
Oct = ReferenceEquals(reader["Oct"], 0) ? 0 : (decimal)reader["Oct"],
Nov = ReferenceEquals(reader["Nov"], 0) ? 0 : (decimal)reader["Nov"],
Dec = ReferenceEquals(reader["Dece"], 0) ? 0 : (decimal)reader["Dece"],
Total = ReferenceEquals(reader["Tot"], 0) ? 0 : (decimal)reader["Tot"]
};
brDetail.Add(brdtl);
}
return(brDetail);
}
}
}
}
