public Record.LoanProfit GetLoanProfit(int fileId, ref string err)
{
err = string.Empty;
Record.LoanProfit loanProfit = null;
bool logErr = false;
if (fileId <= 0)
{
err = string.Format("GetLoanProfit, FileId {0} is invalid.", fileId);
return(loanProfit);
}
string sqlCmd = string.Format("select top 1 * from dbo.LoanProfit where FileId={0}", fileId);
DataSet ds = null;
try
{
ds = DbHelperSQL.Query(sqlCmd);
if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
return(loanProfit);
}
DataRow dr = ds.Tables[0].Rows[0];
loanProfit = new Record.LoanProfit()
{
FileId = dr["FileId"] == DBNull.Value || dr["FileId"] == null ? 0 : (int)dr["FileId"],
CompensationPlan = dr["CompensationPlan"] == DBNull.Value || dr["CompensationPlan"] == null ? string.Empty : dr["CompensationPlan"].ToString(),
NetSell = dr["NetSell"] == DBNull.Value || dr["NetSell"] == null ? string.Empty : dr["NetSell"].ToString(),
SRP = dr["SRP"] == DBNull.Value || dr["SRP"] == null ? string.Empty : dr["SRP"].ToString(),
LLPA = dr["LLPA"] == DBNull.Value || dr["LLPA"] == null ? string.Empty : dr["LLPA"].ToString(),
Investor = dr["Investor"] == DBNull.Value || dr["Investor"] == null ? string.Empty : dr["Investor"].ToString(),
LenderCredit = dr["LenderCredit"] == DBNull.Value || dr["LenderCredit"] == null ? string.Empty : dr["LenderCredit"].ToString(),
HedgeCost = dr["HedgeCost"] == DBNull.Value ? string.Empty : dr["HedgeCost"].ToString(),
MandatoryFinalPrice = dr["MandatoryFinalPrice"] == DBNull.Value ? string.Empty : dr["MandatoryFinalPrice"].ToString(),
CommitmentNumber = dr["CommitmentNumber"] == DBNull.Value ? string.Empty : dr["CommitmentNumber"].ToString(),
CommitmentTerm = dr["CommitmentTerm"] == DBNull.Value ? string.Empty : dr["CommitmentTerm"].ToString(),
CommitmentDate = dr["CommitmentDate"] == DBNull.Value ? string.Empty : dr["CommitmentDate"].ToString(),
CommitmentExpDate = dr["CommitmentExpDate"] == DBNull.Value ? string.Empty : dr["CommitmentExpDate"].ToString(),
Error = dr["Error"] == DBNull.Value ? string.Empty : (string)dr["Error"]
};
return(loanProfit);
}
catch (Exception ex)
{
err = "GetLoanProfit, Exception: " + ex.Message;
logErr = true;
return(loanProfit);
}
finally
{
if (logErr)
{
Trace.TraceError(err);
//EventLog.WriteEntry(InfoHubEventLog.LogSource, err, EventLogEntryType.Warning);
}
}
}
//public void SaveLoanProfit(string fileId, string netSell, string SRP, string LLPA, string investor)
//{
// string err = "";
// bool logErr = false;
// SqlParameter[] parameters = {
// new SqlParameter("@FileId", SqlDbType.Int),
// new SqlParameter("@NetSell", SqlDbType.Decimal),
// new SqlParameter("@SRP", SqlDbType.Decimal),
// new SqlParameter("@LLPA", SqlDbType.Decimal),
// new SqlParameter("@Investor", SqlDbType.NVarChar,500)
// };
// parameters[0].Value = fileId;
// parameters[1].Value = netSell;
// parameters[2].Value = SRP;
// parameters[3].Value = LLPA;
// parameters[4].Value = investor;
// string sqlCmd = "[lpsp_SaveLoanProfit]";
// try
// {
// DbHelperSQL.RunProcedure(sqlCmd, parameters);
// }
// catch (Exception ex)
// {
// err = "SaveLoanProfit, Exception: " + ex.Message;
// int Event_id = 8114;
// EventLog.WriteEntry(InfoHubEventLog.LogSource, err, EventLogEntryType.Warning, Event_id, Category);
// }
// finally
// {
// if (logErr)
// {
// Trace.TraceError(err);
// int Event_id = 8114;
// EventLog.WriteEntry(InfoHubEventLog.LogSource, err, EventLogEntryType.Warning, Event_id, Category);
// }
// }
//}
#endregion
public bool SaveLoanProfit(Record.LoanProfit rec, out string err)
{
err = "";
bool success = false;
bool logErr = false;
if (rec == null)
{
err = "SaveLoanProfit, the Record.LoanProfit is null.";
return(success);
}
try
{
SqlParameter[] parameters =
{
new SqlParameter("@FileId", SqlDbType.Int), // 0
new SqlParameter("@NetSell", SqlDbType.Decimal), // 1
new SqlParameter("@SRP", SqlDbType.Decimal), // 2
new SqlParameter("@LLPA", SqlDbType.Decimal), // 3
new SqlParameter("@Investor", SqlDbType.NVarChar, 500), // 4
new SqlParameter("@HedgeCost", SqlDbType.Decimal), // 5
new SqlParameter("@MandatoryFinalPrice", SqlDbType.Decimal), // 6
new SqlParameter("@CommitmentNumber", SqlDbType.NVarChar, 255), // 7
new SqlParameter("@CommitmentTerm", SqlDbType.SmallInt), // 8
new SqlParameter("@CommitmentDate", SqlDbType.Date), // 9
new SqlParameter("@CommitmentExpDate", SqlDbType.Date), // 10
new SqlParameter("@Error", SqlDbType.NVarChar, 500) // 11
};
parameters[0].Value = rec.FileId;
//NetSell
decimal dNetSell = 0;
parameters[1].Value = DBNull.Value;
if (rec.NetSell != string.Empty && decimal.TryParse(rec.NetSell, out dNetSell))
{
parameters[1].Value = dNetSell;
}
//SRP
decimal dSRP = 0;
parameters[2].Value = DBNull.Value;
if (rec.SRP != string.Empty && decimal.TryParse(rec.SRP, out dSRP))
{
parameters[2].Value = dSRP;
}
//LLPA
decimal dLLPA = 0;
parameters[3].Value = DBNull.Value;
if (rec.LLPA != string.Empty && decimal.TryParse(rec.LLPA, out dLLPA))
{
parameters[3].Value = dLLPA;
}
//Investor
parameters[4].Value = rec.Investor;
// Hedge Cost
decimal dHedgeCost = 0;
parameters[5].Value = DBNull.Value;
if (rec.HedgeCost != string.Empty && decimal.TryParse(rec.HedgeCost, out dHedgeCost))
{
parameters[5].Value = dHedgeCost;
}
decimal dMandatoryFinalPrice = 0;
parameters[6].Value = DBNull.Value;
if (rec.MandatoryFinalPrice != string.Empty && decimal.TryParse(rec.MandatoryFinalPrice, out dMandatoryFinalPrice))
{
parameters[6].Value = dMandatoryFinalPrice;
}
parameters[7].Value = rec.CommitmentNumber;
int iCommitmentTerm = 0;
parameters[8].Value = DBNull.Value;
if (rec.CommitmentTerm != string.Empty && int.TryParse(rec.CommitmentTerm, out iCommitmentTerm))
{
parameters[8].Value = iCommitmentTerm;
}
DateTime dtCommitmentDate = DateTime.MinValue;
parameters[9].Value = DBNull.Value;
if (rec.CommitmentDate != string.Empty && DateTime.TryParse(rec.CommitmentDate, out dtCommitmentDate))
{
parameters[9].Value = dtCommitmentDate;
}
DateTime dtCommitmentExpDate = DateTime.MinValue;
parameters[10].Value = DBNull.Value;
if (rec.CommitmentExpDate != string.Empty && DateTime.TryParse(rec.CommitmentExpDate, out dtCommitmentExpDate))
{
parameters[10].Value = dtCommitmentExpDate;
}
parameters[11].Value = rec.Error;
string sqlCmd = "[lpsp_SaveLoanProfit]";
DbHelperSQL.RunProcedure(sqlCmd, parameters);
success = true;
}
catch (Exception ex)
{
err = string.Format("SaveLoanProfit, FileID: {0} \r\nException: {1} ", rec.FileId, ex.ToString());
//logErr = true;
}
//finally
//{
//if (logErr)
//{
// Trace.TraceError(err);
// int Event_id = 8114;
// EventLog.WriteEntry(InfoHubEventLog.LogSource, err, EventLogEntryType.Warning, Event_id, Category);
//}
//}
return(success);
}