protected void btnSave_Click(object sender, EventArgs e) { try { DateTime dt1 = DateTime.Parse("1/1/1953"); if (txtRegistrationDate.Text == "") { dt1 = DateTime.Parse("1/1/1753"); } else { dt1 = DateTime.Parse(txtRegistrationDate.Text); } DateTime dt = DateTime.Parse(txtCommencementDate.Text); LoanDSTableAdapters.CoporateInformationTableAdapter companyDetails = new LoanDSTableAdapters.CoporateInformationTableAdapter(); companyDetails.UpdateCoporateInformation(txtCompanyName.Value, dt, Convert.ToInt32(txtYearsInBusiness.Value.Trim()), Convert.ToInt32(ddlIndustryType.Text), Convert.ToInt32(ddlSector.SelectedValue), txtPhysicalAddress.Value.Trim(), txtTel1.Value.Trim(), txtTel2.Value.Trim(), txtFax.Value.Trim(), txtNatureofbusiness.Value.Trim(), ddlPremisesStatus.Text, Convert.ToInt32(ddlRegistered.Text), dt1, txtRegistrationNumber.Text, txtVATNo.Value.Trim(), txtTIN.Value.Trim(), txtwebsite.Value.Trim(), MySessionManager.ClientID ); this.editskip.Value = "1"; } catch (Exception ex) { } }
public void loadCompanyDetails(int clientID) { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0]; LoanDSTableAdapters.CoporateInformationTableAdapter companyDetails = new LoanDSTableAdapters.CoporateInformationTableAdapter(); LoanDS.CoporateInformationDataTable tblCompanyDetails = companyDetails.GetCoporateInformation(MySessionManager.ClientID); if (tblCompanyDetails.Rows.Count > 0) { txtCompanyName.Value = tblCompanyDetails[0].datCompanyName.ToString(); txtCommencementDate.Text = tblCompanyDetails[0].datCommencementDate.ToShortDateString(); txtNatureofbusiness.Value = tblCompanyDetails[0].datNatureOfBusiness.ToString(); txtPhysicalAddress.Value = tblCompanyDetails[0].datPhysicalAddress.ToString(); txtRegistrationNumber.Text = tblCompanyDetails[0].datRegistrationNumber.ToString(); txtRegistrationDate.Text = tblCompanyDetails[0].datRegistrationDate.ToShortDateString(); txtYearsInBusiness.Value = tblCompanyDetails[0].datYearsInBusiness.ToString(); txtwebsite.Value = tblCompanyDetails[0].datWebsite.ToString(); txtVATNo.Value = tblCompanyDetails[0].datVATNumber.ToString(); txtTIN.Value = tblCompanyDetails[0].datTIN.ToString(); if (tblCompanyDetails[0].IsdatTelephoneNumber1Null() == false) { txtTel1.Value = tblCompanyDetails[0].datTelephoneNumber1.ToString(); } else if (tblClient.IsdatMobileNumber1Null() == false) { txtTel1.Value = tblClient.datMobileNumber1.ToString(); } if (tblCompanyDetails[0].IsdatTelephoneNumber2Null() == false) { txtTel2.Value = tblCompanyDetails[0].datTelephoneNumber2.ToString(); } else if (tblClient.IsdatMobileNumber2Null() == false) { txtTel2.Value = tblClient.datMobileNumber2.ToString(); } txtTel2.Value = tblCompanyDetails[0].datTelephoneNumber2.ToString(); txtFax.Value = tblCompanyDetails[0].datFaxNumber.ToString(); if (tblCompanyDetails[0].IsdatIndustryTypeNull() == false) { ddlIndustryType.SelectedValue = tblCompanyDetails[0].datIndustryType.ToString(); } //if (tblCompanyDetails[0].IsdatSectorNull()==false) { if(ddlIndustryType.SelectedValue = tblCompanyDetails[0].datSector.ToString(); } if (tblCompanyDetails[0].IsdatPremissesStatusNull() == false) { ddlPremisesStatus.SelectedValue = tblCompanyDetails[0].datPremissesStatus.ToString(); } if (tblCompanyDetails[0].IsdatIsRegisteredNull() == false) { ddlRegistered.SelectedValue = tblCompanyDetails[0].datIsRegistered.ToString(); } this.type.Value = "update"; this.editskip.Value = "2"; } } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { try { // fetch the en-GB culture CultureInfo ukCulture = new CultureInfo("en-GB"); // pass the DateTimeFormat information to DateTime.Parse DateTime dt = DateTime.Parse(txtCommencementDate.Text, ukCulture.DateTimeFormat); DateTime dt1 = DateTime.Parse(txtRegistrationDate.Text, ukCulture.DateTimeFormat); if (this.type.Value != "update") { LoanDSTableAdapters.CoporateInformationTableAdapter companyDetails = new LoanDSTableAdapters.CoporateInformationTableAdapter(); companyDetails.InsertCoporateInformation(MySessionManager.AppID, MySessionManager.ClientID, txtCompanyName.Value, dt, Convert.ToInt32(txtYearsInBusiness.Value.Trim()), Convert.ToInt32(ddlIndustryType.Text), Convert.ToInt32(ddlSector.SelectedValue), txtPhysicalAddress.Value.Trim(), txtTel1.Value.Trim(), txtTel2.Value.Trim(), txtFax.Value.Trim(), txtNatureofbusiness.Value.Trim(), ddlPremisesStatus.Text, Convert.ToInt32(ddlRegistered.Text), dt1, txtRegistrationNumber.Text, txtVATNo.Value.Trim(), txtTIN.Value.Trim(), txtwebsite.Value.Trim(), MySessionManager.CurrentUser.UserID ); this.editskip.Value = "1"; } else if (this.type.Value == "update") { LoanDSTableAdapters.CoporateInformationTableAdapter companyDetails = new LoanDSTableAdapters.CoporateInformationTableAdapter(); companyDetails.UpdateCoporateInformation(txtCompanyName.Value, dt, Convert.ToInt32(txtYearsInBusiness.Value.Trim()), Convert.ToInt32(ddlIndustryType.Text), Convert.ToInt32(ddlSector.SelectedValue), txtPhysicalAddress.Value.Trim(), txtTel1.Value.Trim(), txtTel2.Value.Trim(), txtFax.Value.Trim(), txtNatureofbusiness.Value.Trim(), ddlPremisesStatus.Text, Convert.ToInt32(ddlRegistered.Text), dt1, txtRegistrationNumber.Text, txtVATNo.Value.Trim(), txtTIN.Value.Trim(), txtwebsite.Value.Trim(), MySessionManager.ClientID ); this.editskip.Value = "1"; } } catch { } }