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); } }