private void GetData()
{
ClearRecord();
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
clsdbo_DimScenario.ScenarioKey = System.Convert.ToInt32(Session["ScenarioKey"]);
clsdbo_DimScenario = dbo_DimScenarioDataClass.Select_Record(clsdbo_DimScenario);
if ((clsdbo_DimScenario != null))
{
try {
txtScenarioKey.Text = System.Convert.ToString(clsdbo_DimScenario.ScenarioKey);
if (clsdbo_DimScenario.ScenarioName == null)
{
txtScenarioName.Text = default(string);
}
else
{
txtScenarioName.Text = System.Convert.ToString(clsdbo_DimScenario.ScenarioName);
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Dim Scenario ");
}
}
}
private void InsertRecord()
{
try {
TextBox txtNewScenarioName = (TextBox)grddbo_DimScenario.FooterRow.FindControl("txtNewScenarioName");
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
if (VerifyDataNew() == true)
{
if (string.IsNullOrEmpty(txtNewScenarioName.Text))
{
clsdbo_DimScenario.ScenarioName = null;
}
else
{
clsdbo_DimScenario.ScenarioName = txtNewScenarioName.Text;
}
bool bSucess = false;
bSucess = dbo_DimScenarioDataClass.Add(clsdbo_DimScenario);
if (bSucess == true)
{
Session.Remove("dvdbo_DimScenario");
LoadGriddbo_DimScenario();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Scenario ");
}
}
} catch {
}
}
private void UpdateRecord()
{
dbo_DimScenarioClass oclsdbo_DimScenario = new dbo_DimScenarioClass();
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
oclsdbo_DimScenario.ScenarioKey = System.Convert.ToInt32(Session["ScenarioKey"]);
oclsdbo_DimScenario = dbo_DimScenarioDataClass.Select_Record(oclsdbo_DimScenario);
if (VerifyData() == true)
{
SetData(clsdbo_DimScenario);
bool bSucess = false;
bSucess = dbo_DimScenarioDataClass.Update(oclsdbo_DimScenario, clsdbo_DimScenario);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimScenario");
LoadGriddbo_DimScenario();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Scenario ");
}
}
}
public static bool Update(dbo_DimScenarioClass olddbo_DimScenarioClass,
dbo_DimScenarioClass newdbo_DimScenarioClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[DimScenario] "
+ "SET "
+ " [ScenarioName] = @NewScenarioName "
+ "WHERE "
+ " [ScenarioKey] = @OldScenarioKey "
+ " AND ((@OldScenarioName IS NULL AND [ScenarioName] IS NULL) OR [ScenarioName] = @OldScenarioName) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
if (newdbo_DimScenarioClass.ScenarioName != null)
{
updateCommand.Parameters.AddWithValue("@NewScenarioName", newdbo_DimScenarioClass.ScenarioName);
}
else
{
updateCommand.Parameters.AddWithValue("@NewScenarioName", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@OldScenarioKey", olddbo_DimScenarioClass.ScenarioKey);
if (olddbo_DimScenarioClass.ScenarioName != null)
{
updateCommand.Parameters.AddWithValue("@OldScenarioName", olddbo_DimScenarioClass.ScenarioName);
}
else
{
updateCommand.Parameters.AddWithValue("@OldScenarioName", DBNull.Value);
}
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private void SetData(dbo_DimScenarioClass clsdbo_DimScenario)
{
if (string.IsNullOrEmpty(txtScenarioName.Text))
{
clsdbo_DimScenario.ScenarioName = null;
}
else
{
clsdbo_DimScenario.ScenarioName = txtScenarioName.Text;
}
}
private void Edit()
{
try {
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
Label lblScenarioKey = (Label)grddbo_DimScenario.Rows[grddbo_DimScenario.EditIndex].FindControl("lblScenarioKey");
clsdbo_DimScenario.ScenarioKey = System.Convert.ToInt32(lblScenarioKey.Text);
clsdbo_DimScenario = dbo_DimScenarioDataClass.Select_Record(clsdbo_DimScenario);
LoadGriddbo_DimScenario();
} catch {
}
}
public static bool Add(dbo_DimScenarioClass clsdbo_DimScenario)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[DimScenario] "
+ " ( "
+ " [ScenarioName] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @ScenarioName "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
if (clsdbo_DimScenario.ScenarioName != null)
{
insertCommand.Parameters.AddWithValue("@ScenarioName", clsdbo_DimScenario.ScenarioName);
}
else
{
insertCommand.Parameters.AddWithValue("@ScenarioName", DBNull.Value);
}
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static bool Delete(dbo_DimScenarioClass clsdbo_DimScenario)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[DimScenario] "
+ "WHERE "
+ " [ScenarioKey] = @OldScenarioKey "
+ " AND ((@OldScenarioName IS NULL AND [ScenarioName] IS NULL) OR [ScenarioName] = @OldScenarioName) "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldScenarioKey", clsdbo_DimScenario.ScenarioKey);
if (clsdbo_DimScenario.ScenarioName != null)
{
deleteCommand.Parameters.AddWithValue("@OldScenarioName", clsdbo_DimScenario.ScenarioName);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldScenarioName", DBNull.Value);
}
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static dbo_DimScenarioClass Select_Record(dbo_DimScenarioClass clsdbo_DimScenarioPara)
{
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [ScenarioKey] "
+ " ,[ScenarioName] "
+ "FROM "
+ " [dbo].[DimScenario] "
+ "WHERE "
+ " [ScenarioKey] = @ScenarioKey "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@ScenarioKey", clsdbo_DimScenarioPara.ScenarioKey);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_DimScenario.ScenarioKey = System.Convert.ToInt32(reader["ScenarioKey"]);
clsdbo_DimScenario.ScenarioName = reader["ScenarioName"] is DBNull ? null : reader["ScenarioName"].ToString();
}
else
{
clsdbo_DimScenario = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_DimScenario);
}
finally
{
connection.Close();
}
return(clsdbo_DimScenario);
}
private void DeleteRecord()
{
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
Label lblScenarioKey = (Label)grddbo_DimScenario.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblScenarioKey");
clsdbo_DimScenario.ScenarioKey = System.Convert.ToInt32(lblScenarioKey.Text);
clsdbo_DimScenario = dbo_DimScenarioDataClass.Select_Record(clsdbo_DimScenario);
bool bSucess = false;
bSucess = dbo_DimScenarioDataClass.Delete(clsdbo_DimScenario);
if (bSucess == true)
{
Session.Remove("dvdbo_DimScenario");
LoadGriddbo_DimScenario();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Dim Scenario ");
}
}
private void UpdateRecord()
{
try {
TextBox txtScenarioKey = (TextBox)grddbo_DimScenario.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtScenarioKey");
TextBox txtScenarioName = (TextBox)grddbo_DimScenario.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtScenarioName");
dbo_DimScenarioClass oclsdbo_DimScenario = new dbo_DimScenarioClass();
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
oclsdbo_DimScenario.ScenarioKey = System.Convert.ToInt32(txtScenarioKey.Text);
oclsdbo_DimScenario = dbo_DimScenarioDataClass.Select_Record(oclsdbo_DimScenario);
if (VerifyData() == true)
{
if (string.IsNullOrEmpty(txtScenarioName.Text))
{
clsdbo_DimScenario.ScenarioName = null;
}
else
{
clsdbo_DimScenario.ScenarioName = txtScenarioName.Text;
}
bool bSucess = false;
bSucess = dbo_DimScenarioDataClass.Update(oclsdbo_DimScenario, clsdbo_DimScenario);
if (bSucess == true)
{
Session.Remove("dvdbo_DimScenario");
grddbo_DimScenario.EditIndex = -1;
LoadGriddbo_DimScenario();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Scenario ");
}
}
} catch {
}
}
private void InsertRecord()
{
dbo_DimScenarioClass clsdbo_DimScenario = new dbo_DimScenarioClass();
if (VerifyData() == true)
{
SetData(clsdbo_DimScenario);
bool bSucess = false;
bSucess = dbo_DimScenarioDataClass.Add(clsdbo_DimScenario);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimScenario");
LoadGriddbo_DimScenario();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Scenario ");
}
}
}
