public static bool cUpdateCredit(MODEL_Insur_thai.Loan_Model.LoanInfo data)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@Loan_Id", data.Loan_Id);
cmd.Parameters.AddWithValue("@bank_Id", data.bank_Id);
cmd.Parameters.AddWithValue("@Loan_typeId", data.Loan_typeId);
cmd.Parameters.AddWithValue("@Loan_Name", data.Loan_Name);
cmd.Parameters.AddWithValue("@Loan_Descript", data.Loan_Descript);
cmd.Parameters.AddWithValue("@Loan_Amount", data.Loan_Amount);
cmd.Parameters.AddWithValue("@Loan_Interest", data.Loan_Interest);
cmd.Parameters.AddWithValue("@Loan_Promotion", data.Loan_Promotion);
cmd.Parameters.AddWithValue("@Loan_urlReference", data.Loan_urlReference);
cmd.Parameters.AddWithValue("@Loan_fee", data.Loan_fee);
cmd.Parameters.AddWithValue("@Loan_logoPath", data.Loan_logoPath);
cmd.Parameters.AddWithValue("@Loan_smLogo", data.Loan_smLogo);
cmd.Parameters.AddWithValue("@Loan_status", data.Loan_status);
cmd.Parameters.AddWithValue("@update_user", data.update_user);
string sql = @"
if not exists (select * from Loan_info where Loan_Id = @Loan_Id)
begin
insert into Loan_info(bank_Id ,Loan_typeId ,Loan_Name,Loan_Descript,Loan_Amount,Loan_Interest,Loan_Promotion,Loan_urlReference,Loan_fee,Loan_logoPath,Loan_smLogo,Loan_status ,create_user,update_user,create_date,update_date)
values(@bank_Id ,@Loan_typeId ,@Loan_Name,@Loan_Descript,@Loan_Amount,@Loan_Interest,@Loan_Promotion,@Loan_urlReference,@Loan_fee,@Loan_logoPath,@Loan_smLogo,@Loan_status ,@update_user,@update_user,getdate(),getdate())
end
else
begin
update Loan_info
set bank_Id = @bank_Id,
Loan_typeId = @Loan_typeId,
Loan_Name = @Loan_Name,
Loan_Descript = @Loan_Descript,
Loan_Amount = @Loan_Amount,
Loan_Interest = @Loan_Interest,
Loan_Promotion = @Loan_Promotion,
Loan_urlReference= @Loan_urlReference,
Loan_fee = @Loan_fee,
Loan_logoPath= @Loan_logoPath,
Loan_smLogo= @Loan_smLogo,
Loan_status = @Loan_status,
update_user = @update_user,
update_date = getdate()
where Loan_Id = @Loan_Id
end
";
return(cSourceData.ExecuteData(sql, cmd));
}
public static List <MODEL_Insur_thai.Loan_Model.callLoanPackage> cLoadPackageById(MODEL_Insur_thai.Loan_Model.LoanInfo data)
{
return(DAL_Insur_thai.Loan_DAL.cLoadPackageById(data));
}
public static bool cUpdateCredit(MODEL_Insur_thai.Loan_Model.LoanInfo data)
{
return(DAL_Insur_thai.Loan_DAL.cUpdateCredit(data));
}
public static List <MODEL_Insur_thai.Loan_Model.callLoanPackage> cLoadPackageById(MODEL_Insur_thai.Loan_Model.LoanInfo data)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@Loan_Id", data.Loan_Id);
string sql = @"
select * from Loan_info
where Loan_Id = @Loan_Id
";
var item = cSourceData.GetData(sql, cmd).Tables[0];
List <MODEL_Insur_thai.Loan_Model.callLoanPackage> obj = new List <MODEL_Insur_thai.Loan_Model.callLoanPackage>();
if (item.Rows.Count > 0)
{
for (var i = 0; i < item.Rows.Count; i++)
{
obj.Add(
new MODEL_Insur_thai.Loan_Model.callLoanPackage
{
Loan_Name = item.Rows[i]["Loan_Name"].ToString(),
Loan_Id = Convert.ToInt32(item.Rows[i]["Loan_Id"].ToString()),
bank_Id = Convert.ToInt32(item.Rows[i]["bank_Id"].ToString()),
//Loan_type = item.Rows[i]["Loan_type"].ToString(),
Loan_Descript = item.Rows[i]["Loan_Descript"].ToString(),
Loan_Amount = item.Rows[i]["Loan_Amount"].ToString(),
Loan_Interest = item.Rows[i]["Loan_Interest"].ToString(),
Loan_Promotion = item.Rows[i]["Loan_Promotion"].ToString(),
Loan_logoPath = item.Rows[i]["Loan_logoPath"].ToString(),
Loan_fee = item.Rows[i]["Loan_fee"].ToString()
});
}
}
return(obj);
}
