protected void btnSave_Click(object sender, EventArgs e)
{
string _patchTitle = txtPatchTitle.Text;
string _patchDesc = txtPatchDesc.Text;
string _patchNumber = txtPatchNumber.Text;
string _patchDeployedBy = txtPatchDeployedBy.Text;
int _patchQATested = checkIsQAPassedYes.Checked == true ? 1 : 0;
_patchQATested = checkIsQAPassedNo.Checked == true ? 0 : 1;
string _patchDependency = txtPatchDependency.Text;
int _patchClientID = Convert.ToInt32(dropPatchClientName.SelectedItem.Value);
int _patchProductID = Convert.ToInt32(dropProductName.SelectedItem.Value);
int _patchEnvironmentID = Convert.ToInt32(dropEnvironmentType.SelectedItem.Value);
Debug.WriteLine("Patch Title: " + _patchTitle);
Debug.WriteLine("Patch Description: " + _patchDesc);
Debug.WriteLine("Patch Number: " + _patchNumber);
Debug.WriteLine("Patch Deployed By: " + _patchDeployedBy);
Debug.WriteLine("Patch QA Passed " + _patchQATested);
Debug.WriteLine("Patch Dependency " + _patchDependency);
Debug.WriteLine("Patch Client ID " + _patchClientID);
Debug.WriteLine("Patch Product ID: " + _patchProductID);
Debug.WriteLine("Patch Environment ID: " + _patchEnvironmentID);
DatabaseConnectivity db = new DatabaseConnectivity();
int res = db.insertPatch(_patchTitle, _patchDesc, _patchNumber, _patchDeployedBy, Convert.ToDateTime(txtPatchCreatedDate.Text), Convert.ToDateTime(txtPatchDeployedDate.Text), _patchQATested, _patchDependency, _patchClientID, _patchProductID, _patchEnvironmentID);
Debug.WriteLine("Query Result: " + res);
rowPatchTitle.Visible = false;
rowPatchDesc.Visible = false;
rowPatchNumber.Visible = false;
rowPatchDeployedBy.Visible = false;
rowPatchCreatedDate.Visible = false;
rowPatchDeployedDate.Visible = false;
rowPatchIsQAPassed.Visible = false;
rowPatchDependency.Visible = false;
rowPatchClientName.Visible = false;
rowProductName.Visible = false;
rowEnvironmentType.Visible = false;
rowSubmit.Visible = false;
lblSubmission.Visible = true;
lblSubmission.Text = "Release has been saved with the Response Code: " + (res == 1 ? "0200 OK." : "0500 Error.");
}