public static bool fillLoanDetail(frmNewLoan loan, String loanid)
{
SQLiteDataReader dr = executeReader("select * from loan where " + CL_LOANID + "=" + loanid);
if (dr.Read())
{
String mortgageItems = dr[CL_MORTGAGE_ITEMS].ToString();
String mortgageRemarks = dr[CL_MORTGAGE_REMARKS].ToString();
String[] items = mortgageItems.Split(new String[] { DATABASE_FIELD_SEPARATOR }, StringSplitOptions.None);
String[] remarks = mortgageRemarks.Split(new String[] { DATABASE_FIELD_SEPARATOR }, StringSplitOptions.None);
bool mCheck = false, mVehicle = false, mGold = false, mDocument = false;
String rCheck = "", rVehicle = "", rGold = "", rDocument = "";
if (items.Length == 4 && remarks.Length == 4)
{
mCheck = items[0].Trim().Length != 0;
rCheck = remarks[0].Trim();
mVehicle = items[1].Trim().Length != 0;
rVehicle = remarks[1].Trim();
mGold = items[2].Trim().Length != 0;
rGold = remarks[2].Trim();
mDocument = items[3].Trim().Length != 0;
rDocument = remarks[3].Trim();
}
Image photo = null;
try
{
photo = ByteToImage((Byte[])dr[CL_PHOTO]);
}
catch (Exception) { }
Image scanPhoto = null;
try
{
scanPhoto = ByteToImage((Byte[])dr[CL_CHECK_SCAN]);
}
catch (Exception) { }
loan.setValues(dr[CL_NAME].ToString(), dr[CL_ADDRESS].ToString(), dr[CL_CONTACTNUMBER].ToString(), dr[CL_REFNAME].ToString(), dr[CL_REFCONTACTNUMBER].ToString(), dr[CL_LOANNO].ToString(), mCheck, mVehicle, mGold, mDocument, rCheck, rVehicle, rGold, rDocument, (Bitmap)photo, (Bitmap)scanPhoto);
return(true);
}
else
{
return(false);
}
}
private void lvLoans_DoubleClick(object sender, EventArgs e)
{
try
{
if (lvLoans.SelectedItems.Count == 1)
{
Jobs.Log("LoanEdit Called", null);
frmNewLoan loan = new frmNewLoan();
loan.setEditMode(lvLoans.SelectedItems[0].Tag.ToString());
loan.ShowDialog(this);
loadLoans();
}
}
catch (Exception ex)
{
Jobs.Log("Error[LoanListDoubleClick]", ex);
}
}
