private void btnSave_Click_1(object sender, EventArgs e) { if(txtAge.Text == "" || txtContactNo.Text == "" || txtFname.Text == "" || txtLname.Text =="" || txtAddress.Text == "" || txtContactNo.Text == ""){ MessageBox.Show("Please supply the required fields."); return; } if(txtlengthservice.Text == ""){ txtlengthservice.Text = "0"; } cl_moneylender cMoneyLender = new cl_moneylender(); cl_LenderInformation l_Info = new cl_LenderInformation(); cMoneyLender.propfname = txtFname.Text; cMoneyLender.proplname = txtLname.Text; cMoneyLender.propMI = txtMI.Text; cMoneyLender.propAddress = txtAddress.Text; cMoneyLender.propAge = Convert.ToInt32(txtAge.Text); cMoneyLender.propCreditLimit = Convert.ToDouble(222); cMoneyLender.propLenderID = txtMoneyLenderID.Text; cMoneyLender.propContact_no = txtContactNo.Text; cMoneyLender.propIs_inactive = cboLenderType.Text; l_Info.propLengthofService = Convert.ToInt32(txtlengthservice.Text.ToString()); l_Info.propHouseType = cbohousetype.Text; l_Info.propGender = cboGender.Text; l_Info.propEmail = txtemail.Text; l_Info.propOccupation = txtoccupation.Text; l_Info.propPosition = txtposition.Text; l_Info.propTIN_no = txtTin_no.Text; l_Info.propCompanyName = txtcompanyname.Text; l_Info.propCompanyAdd = txtcompanyaddress.Text; l_Info.propCivilStatus = cboCivilStatus.Text; l_Info.propbirthplace = txtbirthplace.Text; l_Info.propDOB = dob.Value; cl_spouse sp = new cl_spouse(); sp.propspousename = txtspousename.Text; sp.propspouseOcc = txtSoCCu.Text; sp.propsCompany =txtsCompany.Text; sp.propsPosition=txtspouseP.Text; //check if is active or not cl_borrower_loan bl = new cl_borrower_loan(); if (cboCivilStatus.Text != "Single") { sp.props_age = Convert.ToInt32(txtSpouseAge.Text); } if (cMoneyLender.propAge < 18 ) { MessageBox.Show("Age should not lesser than 18"); return; } if (PUBLIC_VARS.EDITMODE == true){ cMoneyLender.UPDATE_DATA(mlt); int l_sid = Convert.ToInt32(PUBLIC_VARS.d.getlastid().ToString()); l_Info.propmonenylenderInfoID = l_sid; l_Info.INSERT_DATATOLENDER(); if (cboCivilStatus.Text != "Single") { sp.propMoneyLender_id = l_sid; sp.UPDATE_SPOUSE(mlt); } cMoneyLender.propMoneyLender_id = mlt; if (InsertPictureBarrowerImages == "") { cMoneyLender.propPicBarrower = tempPictures; } else { cMoneyLender.propPicBarrower = InsertPictureBarrowerImages; } cMoneyLender.UpdatePicBarrower(); MessageBox.Show( PUBLIC_VARS.updateData); } else{ MYFUNCTIONS f = new MYFUNCTIONS(); if (cMoneyLender.isBarrowerExist() == true) { MessageBox.Show("Record already exist."); return; } cMoneyLender.INSERT_DATA(); int iiiD = PUBLIC_VARS.d.getlastid(); int l_sid = Convert.ToInt32(PUBLIC_VARS.d.getlastid().ToString()); l_Info.propmonenylenderInfoID = l_sid; l_Info.INSERT_DATATOLENDER(); if(cboCivilStatus.Text != "Single"){ sp.propMoneyLender_id = l_sid; sp.INSERT_SPOUSE(); } Int64 dx = f.autoUserID() + 1; f.InsertCounterNo(dx); if (InsertPictureBarrowerImages == ""){ InsertPictureBarrowerImages = "default_avatar.jpg"; } cMoneyLender.propPicBarrower = InsertPictureBarrowerImages; cMoneyLender.propMoneyLender_id = iiiD; cMoneyLender.InserPictureBarrower(); MessageBox.Show(PUBLIC_VARS.saveData); } //cMoneyLender.LOAD_MONEYLENDER(lst.lsvMoneyLender); //MYFUNCTIONS m = new MYFUNCTIONS(); //string sql = "SELECT * FROM tmoneylender"; //m.PopulateListView(lsvevent,sql); cMoneyLender.LOAD_MONEYLENDER(lsvevent); this.Close(); }
private void frmCustomer_Load(object sender, EventArgs e) { if (PUBLIC_VARS.EDITMODE == true) { cl_moneylender cm = new cl_moneylender(); cl_LenderInformation c_info = new cl_LenderInformation(); cm.LOADTOFIELDS(mlt); txtAddress.Text = cm.propAddress; txtFname.Text = cm.propfname; txtLname.Text = cm.proplname; txtMI.Text = cm.propMI; txtAge.Text = cm.propAge.ToString(); txtTin_no.Text = cm.propCreditLimit.ToString(); txtContactNo.Text = cm.propContact_no; txtMoneyLenderID.Text = cm.propLenderID; cboLenderType.Text = cm.propIs_inactive; c_info.LOAD_TOFIELDSinfo(mlt); txtbirthplace.Text = c_info.propbirthplace; dob.Value = c_info.propDOB; cboCivilStatus.Text = c_info.propCivilStatus; cboGender.Text = c_info.propGender; cbohousetype.Text = c_info.propHouseType; txtemail.Text = c_info.propEmail; txtoccupation.Text = c_info.propOccupation; txtposition.Text = c_info.propPosition; txtlengthservice.Text = Convert.ToInt32(c_info.propLengthofService).ToString(); txtcompanyaddress.Text = c_info.propCompanyAdd; txtcompanyname.Text = c_info.propCompanyName; cm.loadPictureBarrower(mlt); tempPictures = cm.propPicBarrower; //pictureBarrowerImages = cm.propPicBarrower; picBorrower.Image = Image.FromFile(@"D:\MY PROJECTS\LoanTrackingSystem\loantracking\loantracking\bimages\" + cm.propPicBarrower); picBorrower.SizeMode = PictureBoxSizeMode.StretchImage; // picBorrower.Image = Image.FromFile(@"D:\MY PROJECTS\LoanTrackingSystem\loantracking\loantracking\bimages\default_avatar.jpg"); // picBorrower.SizeMode = PictureBoxSizeMode.StretchImage; if (c_info.propCivilStatus != "Single") { cl_spouse sp = new cl_spouse(); sp.LOAD_TOFIELDSPOUSE(mlt); txtspousename.Text = sp.propspousename; txtSpouseAge.Text = Convert.ToInt32(sp.props_age).ToString(); txtspouseP.Text = sp.propsPosition; txtsCompany.Text = sp.propsCompany; txtSoCCu.Text = sp.propspouseOcc; } } else { MYFUNCTIONS f = new MYFUNCTIONS(); DateTime dt = DateTime.Today; Int64 dx =f.autoUserID()+1; txtMoneyLenderID.Text =dt.Year.ToString("X2") + String.Format("{0:D5}", dx); picBorrower.Image = Image.FromFile(@"D:\MY PROJECTS\LoanTrackingSystem\loantracking\loantracking\bimages\default_avatar.jpg"); picBorrower.SizeMode = PictureBoxSizeMode.StretchImage; } }