public void SaveOrEditRows(object sender, EventArgs e) { try { if (dgPermits.Items.Count > 0) { Button btn = (Button)sender; string senderValue = btn.Text; if (senderValue == "Edit") { cancelButton.Enabled = true; saveButton.Enabled = true; } BuildingPDirtyCollection buildingPDirtyCollection = new BuildingPDirtyCollection(); foreach (DataGridItem row in dgPermits.Items) { var cbx = row.FindControl("CheckBox1"); if (cbx is CheckBox) { CheckBox cb = (CheckBox)cbx; if (cb.Checked) { BuildingPDirty buildingPDirtySave = new BuildingPDirty(); foreach (var c in row.Cells) { if (c is TableCell) { TableCell t = (TableCell)c; foreach (var ctl in t.Controls) { if (ctl is TextBox) { TextBox tb = (TextBox)ctl; if (senderValue == "Edit") { tb.Enabled = true; } else if (senderValue == "Save") { string tbId = tb.ID; switch (tbId) { case "PermitIDCell": buildingPDirtySave.PermitIdStr = tb.Text; break; case "FirstNameCell": buildingPDirtySave.ApplicantFirstNameStr = tb.Text; break; case "LastNameCell": buildingPDirtySave.ApplicantLastNameStr = tb.Text; break; //case "RemodelOrNewCell": // buildingPDirtySave.RemodelOrNewConstructionStr = tb.Text; // break; case "AddressCell": buildingPDirtySave.AddressStr = tb.Text; break; case "CityCell": buildingPDirtySave.CityStr = tb.Text; break; case "ZIPCell": buildingPDirtySave.ZipStr = tb.Text; break; case "SquareFeetCell": buildingPDirtySave.SquareFeetStr = tb.Text; break; case "HeightCell": buildingPDirtySave.HeightInFeetStr = tb.Text; break; case "StartDateCell": buildingPDirtySave.StartDateStr = tb.Text; break; case "EndDateCell": buildingPDirtySave.EstimatedEndDateStr = tb.Text; break; } } } else if (ctl is DropDownList) { DropDownList ddl = (DropDownList)ctl; if (senderValue == "Edit") { ddl.Enabled = true; } else if (senderValue == "Save") { if (ddl.ID == "RemodelOrNewCell") { buildingPDirtySave.RemodelOrNewConstructionStr = ddl.SelectedValue; } } } } } } if (senderValue == "Save") { buildingPDirtyCollection.BuildingPDirtyList.Add(buildingPDirtySave); } } } } if (senderValue == "Save") { BuildPCollection buildPCollection = new BuildPCollection(); foreach (BuildingPDirty buildingPDirty in buildingPDirtyCollection.BuildingPDirtyList) { Validator validatorSave = new Validator(buildingPDirty); if (validatorSave.AllAreValid) { buildingPDirty.PassedValidation = true; BuildingP buildingP = new BuildingP(buildingPDirty); buildPCollection.BuildingPList.Add(buildingP); } } DataA dataA = new DataA(); if (dataA.UpdatePermitData(buildPCollection) > 0) { insertFeedback.InnerHtml = "<span style='color:green;font-weight:bold;'>Changes Saved</span>"; } else { insertFeedback.InnerHtml = "<span style='color:red;font-weight:bold;'>Errors while saving. Please try again.</span>"; } LoadPermits(); } } } catch (Exception ex) { this.ReportExceptions(ex, "Error while saving or editing permit(s). ", ""); } }
public static object SearchLinkedBuildingPermits(List <BuildingPDirty> searchParams) { string firstName = searchParams[0].ApplicantFirstName; string lastName = searchParams[0].ApplicantLastName; try { //BuildingPCollection linkedBuildingPermitsCollection = new BuildingPCollection(); BuildingPDirtyCollection linkedBuildingPermitsCollection = new BuildingPDirtyCollection(); if (firstName.Length < 41 && lastName.Length < 41) { DataA dataA = new DataA(); DataTable linkedBuildingPermits = dataA.SearchBuildingPermits(firstName, lastName); if (linkedBuildingPermits.Rows.Count > 0) { foreach (DataRow r in linkedBuildingPermits.Rows) { BuildingPDirty buildingPDirty = new BuildingPDirty(); buildingPDirty.ApplicantFirstName = r["ApplicantFirstName"].ToString(); buildingPDirty.ApplicantLastName = r["ApplicantLastName"].ToString(); buildingPDirty.SquareFeet = r["SquareFeet"].ToString(); buildingPDirty.Height = r["Height"].ToString(); buildingPDirty.ConstructionStartDate = r["StartDate"].ToString(); if (r["EndDate"].ToString() == DateTime.MaxValue.ToString()) { buildingPDirty.EstimatedCompletionDate = ""; } else { //DateTime endDateLong = DateTime.Parse(r["EndDate"].ToString()); buildingPDirty.EstimatedCompletionDate = r["EndDate"].ToString(); } buildingPDirty.Address = r["Address"].ToString(); buildingPDirty.City = r["City"].ToString(); buildingPDirty.Zip = r["Zip"].ToString(); buildingPDirty.RemodelOrNewConstruction = r["RemodelOrNewConstruction"].ToString(); buildingPDirty.PermitId = r["PermitID"].ToString(); //buildingPDirty.PassedValidation = true; //BuildingP buildingP = new BuildingP(buildingPDirty); linkedBuildingPermitsCollection.BuildingPDirtyList.Add(buildingPDirty); } } else { return(0); } } else { return("firstNameOrLastNameTooLong"); } return(linkedBuildingPermitsCollection); } catch (Exception) { return("serverError"); } }