public static List <CashConversionModule> getCC(string criteria, int branchID)
{
var dbUtil = new DatabaseManager();
var brHeader = new List <CashConversionModule>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spCashConversionGetTran";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
cmd.Parameters.AddWithValue("@intBranchID", branchID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var brhdr = new CashConversionModule
{
ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
intIDMasLocation = ReferenceEquals(reader["intIDMasLocation"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasLocation"]),
intIDSalMCFinancing = ReferenceEquals(reader["intIDSalMCFinancing"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDSalMCFinancing"]),
strAccountCode = ReferenceEquals(reader["strAccountCode"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strAccountCode"]),
datAccountDate = ReferenceEquals(reader["datAccountDate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datAccountDate"]),
datFirstDueDate = ReferenceEquals(reader["datFirstDueDate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datFirstDueDate"]),
datConvertedDate = ReferenceEquals(reader["datConvertedDate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datConvertedDate"]),
strCustomerName = ReferenceEquals(reader["strCustomerName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strCustomerName"]),
decFactorRate = ReferenceEquals(reader["decFactorRate"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["decFactorRate"]),
decRateFromLCP = ReferenceEquals(reader["decRateFromLCP"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["decRateFromLCP"]),
decRateFromMonthLCP = ReferenceEquals(reader["decRateFromMonthLCP"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["decRateFromMonthLCP"]),
amtLCP = ReferenceEquals(reader["amtLCP"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["amtLCP"]),
amtCashPrice = ReferenceEquals(reader["amtCashPrice"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["amtCashPrice"]),
intMonthLapse = ReferenceEquals(reader["intMonthLapse"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["intMonthLapse"]),
amtTotalPay = ReferenceEquals(reader["amtTotalPay"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["amtTotalPay"]),
amtDP = ReferenceEquals(reader["amtDP"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["amtDP"]),
amtRebate = ReferenceEquals(reader["amtRebate"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["amtRebate"]),
amtMAmort = ReferenceEquals(reader["amtMAmort"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["amtMAmort"]),
amtTotalPayWithRebate = ReferenceEquals(reader["amtTotalPayWithRebate"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["amtTotalPayWithRebate"]),
};
brHeader.Add(brhdr);
}
return(brHeader);
}
}
}
}
public static string Manage(NameValueCollection querystring)
{
int integerParse;
decimal decimalParse;
//bool boolParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var cashconv = new CashConversionModule
{
ID = int.TryParse(querystring.Get("CCID"), out integerParse) ? integerParse : 0,
intIDMasLocation = int.TryParse(querystring.Get("BranchID"), out integerParse) ? integerParse : 0,
datAccountDate = querystring.Get("AcctDate"),
datFirstDueDate = querystring.Get("FirstDueDate"),
datConvertedDate = querystring.Get("ConversionDate"),
intIDSalMCFinancing = int.TryParse(querystring.Get("SalesID"), out integerParse) ? integerParse : 0,
strAccountCode = querystring.Get("AccountCode"),
decRateFromLCP = decimal.TryParse(querystring.Get("InterestRate"), out decimalParse) ? decimalParse : 0,
decRateFromMonthLCP = decimal.TryParse(querystring.Get("InterestRateMonth"), out decimalParse) ? decimalParse : 0,
decFactorRate = decimal.TryParse(querystring.Get("FactorRate"), out decimalParse) ? decimalParse : 0,
amtLCP = decimal.TryParse(querystring.Get("LCP"), out decimalParse) ? decimalParse : 0,
amtDP = decimal.TryParse(querystring.Get("DownPayment"), out decimalParse) ? decimalParse : 0,
amtCashPrice = decimal.TryParse(querystring.Get("CashPrice"), out decimalParse) ? decimalParse : 0,
intMonthLapse = decimal.TryParse(querystring.Get("MonthLapse"), out decimalParse) ? decimalParse : 0,
amtTotalPay = decimal.TryParse(querystring.Get("TotalPayNetRebate"), out decimalParse) ? decimalParse : 0,
amtTotalPayWithRebate = decimal.TryParse(querystring.Get("TotalPayWithRebate"), out decimalParse) ? decimalParse : 0,
amtRebate = decimal.TryParse(querystring.Get("Rebate"), out decimalParse) ? decimalParse : 0,
};
string isInsert = querystring.Get("TransType");
string param = WebCommon.ToXML(cashconv);
return(CashConversionModuleDAL.Manage(param, isInsert));
}