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 int UpdatePermitData(BuildPCollection buildingPCollection)
{
using (SqlConnection connection = new SqlConnection(connectionStr))
{
SqlTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
foreach (BuildingP buildingP in buildingPCollection.BuildingPList)
{
using (SqlCommand command = new SqlCommand(updateStr, connection, transaction))
{
command.Parameters.Add(
new SqlParameter("@PermitID", SqlDbType.Int)
{
Value = buildingP.PermitId
});
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.StartDate
});
command.Parameters.Add(
new SqlParameter("@EndDate", SqlDbType.DateTime)
{
Value = buildingP.EndDate
});
rowsUpdated = command.ExecuteNonQuery();
command.Dispose();
}
}
transaction.Commit();
}
catch (Exception Ex)
{
if (transaction != null)
{
transaction.Rollback();
}
return(-1);
}
connection.Dispose();
}
return(rowsUpdated);
}
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(BuildPCollection 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.StartDate
});
command.Parameters.Add(
new SqlParameter("@EndDate", SqlDbType.DateTime)
{
Value = buildingP.EndDate
});
rowsInserted = command.ExecuteNonQuery();
command.Dispose();
}
connection.Dispose();
}
return(rowsInserted);
}
