protected void btnSubmit_Click(object sender, EventArgs e)
{
CruxDB DBObject = new CruxDB();
int numberLots = 0;// = Int32.Parse(txtNumberOfLots.Text);
if (txtNumberOfLots.Text == "")
{
}
else
{
numberLots = Int32.Parse(txtNumberOfLots.Text);
}
string locationNotes = "";
decimal acquisitionPrice;
decimal improvementCost;
decimal.TryParse(txtAcquisitionPrice.Text, NumberStyles.Currency, NumberFormatInfo.InvariantInfo, out acquisitionPrice);
decimal.TryParse(txtImprovementCosts.Text, NumberStyles.Currency, NumberFormatInfo.InvariantInfo, out improvementCost);
try
{
if (((DataBucket)Session["UserData"])._userID > 0)
{
//We need to add validation here, currently a user can enter an empty project
if (txtProjectName.Text == "" || txtFirstStreet.Text == "" || txtSecondStreet.Text == "" || txtCity.Text == "" || txtState.Text == "" || txtCardinal.Text == "" || txtAcquisitionPrice.Text == "" || txtImprovementCosts.Text == "")
{
lblDataInserted.Visible = true;
lblDataInserted.ForeColor = System.Drawing.Color.Red;
lblDataInserted.Text = "Please fill in all fields";
}
else
{
DBObject.insertProject(LotBankingCrux_v_1.Crux.CruxDB.dbID, txtProjectName.Text, txtFirstStreet.Text, txtSecondStreet.Text, txtCity.Text, txtState.Text, txtCardinal.Text, locationNotes, acquisitionPrice, improvementCost, numberLots);
lblDataInserted.Visible = true;
lblDataInserted.ForeColor = System.Drawing.Color.Green;
lblDataInserted.Text = "Data Inserted";
}
}
else
Response.Redirect("Login.aspx");
if (dbObject.GetReqFinInfoChecked(((DataBucket)Session["UserData"])._userID) > 0)
{
lblAddInfoReq.Visible = true;
}
resetControls();
}
catch (MySqlException ex)
{
lblDataInserted.Text = ex.Message;
}
//else
//{
// DataInserted.ForeColor = System.Drawing.Color.Red;
// DataInserted.Text = "Error!";
// DataInserted.Visible = true;
//}
}
