public static List <MODEL_Insur_thai.Loan_Model.bank_pathfile> cLoadFilePath(MODEL_Insur_thai.Loan_Model.bank_pathfile data)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@loan_Id", data.loan_Id);
string sql = @"
select * from bank_pathfile
where loan_Id = @loan_Id
";
var item = cSourceData.GetData(sql, cmd).Tables[0];
List <MODEL_Insur_thai.Loan_Model.bank_pathfile> obj = new List <MODEL_Insur_thai.Loan_Model.bank_pathfile>();
if (item.Rows.Count > 0)
{
for (var i = 0; i < item.Rows.Count; i++)
{
obj.Add(
new MODEL_Insur_thai.Loan_Model.bank_pathfile
{
file_desc = item.Rows[i]["file_desc"].ToString(),
file_name = item.Rows[i]["file_name"].ToString(),
file_path = item.Rows[i]["file_path"].ToString()
});
}
}
return(obj);
}
public static List <MODEL_Insur_thai.Loan_Model.bank_pathfile> cLoadFilePath(MODEL_Insur_thai.Loan_Model.bank_pathfile data)
{
return(DAL_Insur_thai.Loan_DAL.cLoadFilePath(data));
}
