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