protected void btnCreate_Click(object sender, EventArgs e) { QCTLinqDataContext db = new QCTLinqDataContext(); Contractor c = new Contractor { Company = txtCompany.Text, VendorNumber = txtVendorNumber.Text, ContactName = txtContactName.Text, MailingAddress = txtMailAddress.Text, Town = txtTown.Text, PostalCode = txtPostalCode.Text, Email = txtEmail.Text, NCContact = txtNCContact.Text, ExemptFromAuto = false }; db.Contractors.InsertOnSubmit(c); db.SubmitChanges(); int ID = c.ID; WSIB w = new WSIB { cID = ID }; db.WSIBs.InsertOnSubmit(w); db.SubmitChanges(); Response.Redirect("~/EditContractor.aspx?ID=" + ID); }
protected void btnSaveWSIB_Click(object sender, EventArgs e) { int cID = Int32.Parse(Request.QueryString["ID"]); bool newWSIB = false; QCTLinqDataContext db = new QCTLinqDataContext(); WSIB w = (from a in db.WSIBs where a.cID == cID select a).SingleOrDefault(); if (w == null) { w = new WSIB(); w.cID = cID; newWSIB = true; } w.WSIBCoverage = ddWSIBCoverage.SelectedIndex > 0 ? int.Parse(ddWSIBCoverage.SelectedValue) : (int?)null; w.WSIBCertRecd = ddCertRecd.Value; w.IndOpLetterRecd = ddIndOpLetter.Value; w.IndOpIDNum = txtIDNum.Text; w.WSIBExemptFormRecd = ddWSIBExempt.Value; w.AODAFormSubmit = ddAODASubmitted.Value; w.AODAStandardsCompliance = ddAODAStandardsCompliance.Value; w.NCHSPolicyReqd = ddNCHSReqd.Value; w.NCHSPolicyRecd = ddNCHSReceived.Value; w.MoL100Recd = ddMoL100.SelectedValue; w.HSPolicy = ddContHS.SelectedValue; if (newWSIB) { db.WSIBs.InsertOnSubmit(w); } db.SubmitChanges(); notWSIB.Type = "success"; notWSIB.Message = "Changes have been saved!"; notWSIB.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Functions.SecurePage(); int cID; if (!String.IsNullOrEmpty(Request.QueryString["ID"]) && int.TryParse(Request.QueryString["ID"].ToString(), out cID)) { // populate links in various tabs lnkNewInsurance.NavigateUrl = "~/InsurancePolicies/New.aspx?cID=" + cID; lnkNewAgreemnt.NavigateUrl = "~/Agreements.aspx?cID=" + cID + "&mode=add"; lnkNewPermit.NavigateUrl = "~/Permits.aspx?cID=" + cID + "&mode=add"; lnkNewLicence.NavigateUrl = "~/Licences.aspx?cID=" + cID + "&mode=add"; btnCancel.NavURL = "~/ViewContractor.aspx?ID=" + cID; ddPhoneType.DataSource = Contractors.GetPhoneTypes(); ddPhoneType.DataTextField = "Value"; ddPhoneType.DataValueField = "ID"; ddPhoneType.DataBind(); rptInsurance.DataSource = Contractors.GetInsurance(cID); rptInsurance.DataBind(); rptAgreements.DataSource = Contractors.GetAgreements(cID); rptAgreements.DataBind(); rptPermits.DataSource = Contractors.GetPermits(cID); rptPermits.DataBind(); rptLicenses.DataSource = Contractors.GetLicenses(cID); rptLicenses.DataBind(); ddWSIBCoverage.DataSource = Contractors.GetWSIBTypes(); ddWSIBCoverage.DataTextField = "Value"; ddWSIBCoverage.DataValueField = "ID"; ddWSIBCoverage.DataBind(); rptJobs.DataSource = Contractors.GetJobs(cID); rptJobs.DataBind(); WSIB w = Contractors.GetWSIB(cID); if (w != null) { ddWSIBCoverage.SelectedValue = w.WSIBCoverage.HasValue ? w.WSIBCoverage.ToString() : String.Empty; if (ddWSIBCoverage.SelectedValue.Equals("1")) { phClearance.Visible = true; } else if (ddWSIBCoverage.SelectedValue.Equals("2")) { phIndOp.Visible = true; } else if (ddWSIBCoverage.SelectedValue.Equals("3")) { phWSIBExempt.Visible = true; } ddCertRecd.Value = w.WSIBCertRecd; ddIndOpLetter.Value = w.IndOpLetterRecd; txtIDNum.Text = w.IndOpIDNum; ddWSIBExempt.Value = w.WSIBExemptFormRecd; ddAODASubmitted.Value = w.AODAFormSubmit; ddAODAStandardsCompliance.Value = w.AODAStandardsCompliance; ddNCHSReqd.Value = w.NCHSPolicyReqd; phNCHSPolicyRecd.Visible = ddNCHSReqd.Value == null ? false : (bool)ddNCHSReqd.Value; ddNCHSReceived.Value = w.NCHSPolicyRecd; ddMoL100.SelectedValue = w.MoL100Recd; ddContHS.SelectedValue = w.HSPolicy; } Contractor c = Contractors.GetContractor(cID); CompanyTextBox.Text = c.Company; ltSubTitle.Text = "Editing " + c.Company; VendorNumberTextBox.Text = c.VendorNumber; ContactNameTextBox.Text = c.ContactName; MailingAddressTextBox.Text = c.MailingAddress; TownTextBox.Text = c.Town; PostalCodeTextBox.Text = c.PostalCode; EmailTextBox.Text = c.Email; txtNCContact.Text = c.NCContact; ddExemptFromAuto.Value = c.ExemptFromAuto; phExemptFromAutoComments.Visible = c.ExemptFromAuto == true; txtExemptFromAutoComments.Text = c.ExemptFromAutoComments; txtContratorNotes.Text = c.Notes; rptPhones.DataSource = Contractors.GetPhoneNumbers(cID); rptPhones.DataBind(); // if there are any status messages to display... display them! if (Request.QueryString["msg"] != null) { switch (Request.QueryString["msg"]) { case "insadded": notInsurance.Type = "success"; notInsurance.Message = "Insurance Policy added!"; notInsurance.Visible = true; break; case "insedited": notInsurance.Type = "success"; notInsurance.Message = "Insurance Policy updated!"; notInsurance.Visible = true; break; } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int ID = int.Parse(Request.QueryString["ID"]); if (Functions.CanEdit()) { btnEdit.NavURL = "~/EditContractor.aspx?ID=" + ID; } else { btnEdit.Visible = false; } QCTLinqDataContext db = new QCTLinqDataContext(); Contractor c = db.Contractors.Single(i => i.ID == ID); ltVendorNumber.Text = c.VendorNumber; ltCompany.Text = c.Company; ltContactName.Text = c.ContactName; ltMailingAddress.Text = c.MailingAddress; ltTown.Text = c.Town; ltPostalCode.Text = c.PostalCode; lnkEmail.NavigateUrl = "mailto:" + c.Email; lnkEmail.Text = c.Email; ltNCContact.Text = c.NCContact; notExemptFromAuto.Visible = c.ExemptFromAuto == true ? true : false; notExemptFromAuto.Message = c.ExemptFromAuto == true ? "This contractor is exempt from auto insurance: " + c.ExemptFromAutoComments : String.Empty; lblContractorNotes.Text = (c.Notes == null || c.Notes.Equals(String.Empty)) ? "No notes for this contractor." : c.Notes; rptPhones.DataSource = Contractors.GetPhoneNumbers(ID); rptPhones.DataBind(); rptInsurance.DataSource = Contractors.GetInsurance(ID); rptInsurance.DataBind(); rptAgreements.DataSource = Contractors.GetAgreements(ID); rptAgreements.DataBind(); rptPermits.DataSource = Contractors.GetPermits(ID); rptPermits.DataBind(); rptLicenses.DataSource = Contractors.GetLicenses(ID); rptLicenses.DataBind(); rptJobs.DataSource = Contractors.GetJobs(ID); rptJobs.DataBind(); WSIB w = Contractors.GetWSIB(ID); if (w != null) { ltWSIBCoverage.Text = w.WSIBCoverage.HasValue ? w.TypeOfWSIB.Value : "---"; if (ltWSIBCoverage.Text.Equals("WSIB Clearance Certificate")) { phClearance.Visible = true; } else if (ltWSIBCoverage.Text.Equals("Independant Operator Letter")) { phIndOp.Visible = true; } else if (ltWSIBCoverage.Text.Equals("WSIB Exemption")) { phWSIBExempt.Visible = true; } ltlWSIBCert.Text = w.WSIBCertRecd.ToYesNoString(); ltIndOp.Text = w.IndOpLetterRecd.ToYesNoString(); ltIDNum.Text = w.IndOpIDNum; ltExemptionRecd.Text = w.WSIBExemptFormRecd.ToYesNoString(); ltCompSub.Text = w.AODAFormSubmit.ToYesNoString(); ltAODAStandards.Text = w.AODAStandardsCompliance.ToYesNoString(); ltNCHSReqd.Text = w.NCHSPolicyReqd.ToYesNoString(); phNCHS.Visible = w.NCHSPolicyReqd == null ? false : w.NCHSPolicyReqd.Value; ltNCHSRecd.Text = w.NCHSPolicyRecd.ToYesNoString(); ltMoL100Recd.Text = (w.MoL100Recd == null || w.MoL100Recd.Equals(String.Empty)) ? "---" : w.MoL100Recd; ltConHS.Text = (w.HSPolicy == null || w.HSPolicy.Equals(String.Empty)) ? "---" : w.HSPolicy; } } }