public static object InsertBuildingPermit(List <BuildingPDirty> insertParams) { try { int rowsInserted = 0; Validator validator = new Validator(insertParams[0]); if (validator.AllAreValid) { BuildingPDirty buildingPDirty = insertParams[0]; buildingPDirty.PassedValidation = true; BuildingP buildingP = new BuildingP(insertParams[0]); BuildingPCollection buildingPCollection = new BuildingPCollection(); buildingPCollection.BuildingPList.Add(buildingP); DataA dataA = new DataA(); rowsInserted = dataA.InsertPermitData(buildingPCollection); } else { return("inputsInvalid"); } return(rowsInserted); } catch (Exception) { return("serverError"); } }
protected void SubmitButtonClick(object sender, EventArgs e) { try { BuildingPDirty buildingPDirty = new BuildingPDirty( tbxApplicantFirstName.Value, tbxApplicantLastName.Value, tbxSquareFeet.Value, tbxHeightInFeet.Value, tbxStartDate.Value, tbxEstimatedEndDate.Value, tbxAddress.Value, tbxCity.Value, tbxZip.Value, ddlRemodelOrNewConstruction.SelectedValue); Validator validatorSubmission = new Validator(buildingPDirty); if (!validatorSubmission.AllAreValid) { buildingPDirty.PassedValidation = false; ToggleInputValidationMessages(validatorSubmission); } else { buildingPDirty.PassedValidation = true; BuildingP buildingP = new BuildingP(buildingPDirty); ToggleInputValidationMessages(validatorSubmission); BuildPCollection buildingPCollection = new BuildPCollection(); buildingPCollection.BuildingPList.Add(buildingP); DataA dataA = new DataA(); if (dataA.InsertPermitData(buildingPCollection) == 1) { insertFeedback.InnerHtml = "<span style='color:green;font-weight:bold;'>Application submitted</span>"; } else { insertFeedback.InnerHtml = "<span style='color:red;font-weight:bold;'>Application submission failed. Please try again.</span>"; } LoadPermits(); } } catch (Exception ex) { this.ReportExceptions(ex, "Error while saving new permit. ", ""); } }
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 int InsertPermitData(BuildingPCollection buildingPCollection) { BuildingP buildingP = buildingPCollection.BuildingPList[0]; using (SqlConnection connection = new SqlConnection(connectionStr)) { connection.Open(); using (SqlCommand command = new SqlCommand(insertStr, connection)) { command.Parameters.Add( new SqlParameter("@ApplicantFirstName", SqlDbType.NVarChar) { Value = buildingP.ApplicantFirstName }); command.Parameters.Add( new SqlParameter("@ApplicantLastName", SqlDbType.NVarChar) { Value = buildingP.ApplicantLastName }); command.Parameters.Add( new SqlParameter("@RemodelOrNewConstruction", SqlDbType.NVarChar) { Value = buildingP .RemodelOrNewConstruction }); command.Parameters.Add( new SqlParameter("@Address", SqlDbType.NVarChar) { Value = buildingP.Address }); command.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar) { Value = buildingP.City }); command.Parameters.Add(new SqlParameter("@Zip", SqlDbType.NVarChar) { Value = buildingP.Zip }); command.Parameters.Add( new SqlParameter("@SquareFeet", SqlDbType.Float) { Value = buildingP.SquareFeet }); command.Parameters.Add(new SqlParameter("@Height", SqlDbType.Float) { Value = buildingP.Height }); command.Parameters.Add( new SqlParameter("@StartDate", SqlDbType.DateTime) { Value = buildingP.ConstructionStartDate }); command.Parameters.Add( new SqlParameter("@EndDate", SqlDbType.DateTime) { Value = buildingP.EstimatedCompletionDate }); rowsInserted = command.ExecuteNonQuery(); command.Dispose(); } connection.Dispose(); } return(rowsInserted); }