private bool Validate(out string errorMessage)
{
errorMessage = "";
if (txtGameTitle.Text.Length < CVGS_Shared.MINIMUM_STRING_LENGTH)
{
errorMessage += "Game Title must be at least " + CVGS_Shared.MINIMUM_STRING_LENGTH + " in length\r\n";
}
if (!CVGS_Function.IsNumber(txtPrice.Text))
{
errorMessage += "Price must be a number";
}
return(errorMessage == "");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string errorMessage;
if (Valadate(out errorMessage))
{
try
{
DateTime releaseDate;
try
{
releaseDate = new DateTime(
int.Parse(ddlReleaseYear.Text),
int.Parse(ddlReleaseMonth.SelectedValue),
int.Parse(ddlReleaseDay.Text));
}
catch
{
releaseDate = new DateTime();
}
CVGS_DAL.ProductDAL_SQL productDAL_SQL = new CVGS_DAL.ProductDAL_SQL();
productDAL_SQL.Insert(
CVGS_Function.sqlEscape(txtGameTitle.Text),
int.Parse(ddlPlatform.SelectedValue),
int.Parse(ddlPublisher.SelectedValue),
decimal.Parse(txtPrice.Text.ToString()),
int.Parse(ddlCategory.SelectedValue),
int.Parse(ddlRating.SelectedValue),
releaseDate,
"");
MessageBox.Show("Game Added");
}
catch (Exception exception)
{
MessageBox.Show("Failed to add game\r\n" + exception.Message);
}
}
else
{
MessageBox.Show(errorMessage);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
bool updateSuccessful = false;
try
{
DateTime releaseDate;
try
{
releaseDate = new DateTime(
int.Parse(ddlReleaseYear.Text),
int.Parse(ddlReleaseMonth.Text),
int.Parse(ddlReleaseDay.Text));
}
catch
{
releaseDate = new DateTime();
}
CVGS_DAL.ProductDAL_SQL productDAL = new CVGS_DAL.ProductDAL_SQL();
productDAL.Update(
int.Parse(Request.QueryString["id"]),
CVGS_Function.sqlEscape(txtGameTitle.Text),
int.Parse(ddlPlatform.SelectedValue),
int.Parse(ddlPublisher.SelectedValue),
decimal.Parse(txtPrice.Text),
int.Parse(ddlCategory.SelectedValue),
int.Parse(ddlRating.SelectedValue),
releaseDate,
txtDecription.Text);
updateSuccessful = true;
}
catch (Exception exception)
{
MessageBox.Show("Failed to update Game \r\n" + exception.Message);
}
if (updateSuccessful)
{
MessageBox.Show("Update Successful");
Response.Redirect("./createReport.aspx");
}
}