private void InsertRecord()
{
try {
TextBox txtNewCurrencyAlternateKey = (TextBox)grddbo_DimCurrency.FooterRow.FindControl("txtNewCurrencyAlternateKey");
TextBox txtNewCurrencyName = (TextBox)grddbo_DimCurrency.FooterRow.FindControl("txtNewCurrencyName");
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
if (VerifyDataNew() == true)
{
clsdbo_DimCurrency.CurrencyAlternateKey = System.Convert.ToString(txtNewCurrencyAlternateKey.Text);
clsdbo_DimCurrency.CurrencyName = System.Convert.ToString(txtNewCurrencyName.Text);
bool bSucess = false;
bSucess = dbo_DimCurrencyDataClass.Add(clsdbo_DimCurrency);
if (bSucess == true)
{
Session.Remove("dvdbo_DimCurrency");
LoadGriddbo_DimCurrency();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Currency ");
}
}
} catch {
}
}
private void UpdateRecord()
{
try {
TextBox txtCurrencyKey = (TextBox)grddbo_DimCurrency.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCurrencyKey");
TextBox txtCurrencyAlternateKey = (TextBox)grddbo_DimCurrency.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCurrencyAlternateKey");
TextBox txtCurrencyName = (TextBox)grddbo_DimCurrency.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCurrencyName");
dbo_DimCurrencyClass oclsdbo_DimCurrency = new dbo_DimCurrencyClass();
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
oclsdbo_DimCurrency.CurrencyKey = System.Convert.ToInt32(txtCurrencyKey.Text);
oclsdbo_DimCurrency = dbo_DimCurrencyDataClass.Select_Record(oclsdbo_DimCurrency);
if (VerifyData() == true)
{
clsdbo_DimCurrency.CurrencyAlternateKey = System.Convert.ToString(txtCurrencyAlternateKey.Text);
clsdbo_DimCurrency.CurrencyName = System.Convert.ToString(txtCurrencyName.Text);
bool bSucess = false;
bSucess = dbo_DimCurrencyDataClass.Update(oclsdbo_DimCurrency, clsdbo_DimCurrency);
if (bSucess == true)
{
Session.Remove("dvdbo_DimCurrency");
grddbo_DimCurrency.EditIndex = -1;
LoadGriddbo_DimCurrency();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Currency ");
}
}
} catch {
}
}
private void UpdateRecord()
{
dbo_DimCurrencyClass oclsdbo_DimCurrency = new dbo_DimCurrencyClass();
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
oclsdbo_DimCurrency.CurrencyKey = System.Convert.ToInt32(Session["CurrencyKey"]);
oclsdbo_DimCurrency = dbo_DimCurrencyDataClass.Select_Record(oclsdbo_DimCurrency);
if (VerifyData() == true)
{
SetData(clsdbo_DimCurrency);
bool bSucess = false;
bSucess = dbo_DimCurrencyDataClass.Update(oclsdbo_DimCurrency, clsdbo_DimCurrency);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimCurrency");
LoadGriddbo_DimCurrency();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Currency ");
}
}
}
private void Edit()
{
try {
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
Label lblCurrencyKey = (Label)grddbo_DimCurrency.Rows[grddbo_DimCurrency.EditIndex].FindControl("lblCurrencyKey");
clsdbo_DimCurrency.CurrencyKey = System.Convert.ToInt32(lblCurrencyKey.Text);
clsdbo_DimCurrency = dbo_DimCurrencyDataClass.Select_Record(clsdbo_DimCurrency);
LoadGriddbo_DimCurrency();
} catch {
}
}
public static bool Update(dbo_DimCurrencyClass olddbo_DimCurrencyClass,
dbo_DimCurrencyClass newdbo_DimCurrencyClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[DimCurrency] "
+ "SET "
+ " [CurrencyAlternateKey] = @NewCurrencyAlternateKey "
+ " ,[CurrencyName] = @NewCurrencyName "
+ "WHERE "
+ " [CurrencyKey] = @OldCurrencyKey "
+ " AND [CurrencyAlternateKey] = @OldCurrencyAlternateKey "
+ " AND [CurrencyName] = @OldCurrencyName "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewCurrencyAlternateKey", newdbo_DimCurrencyClass.CurrencyAlternateKey);
updateCommand.Parameters.AddWithValue("@NewCurrencyName", newdbo_DimCurrencyClass.CurrencyName);
updateCommand.Parameters.AddWithValue("@OldCurrencyKey", olddbo_DimCurrencyClass.CurrencyKey);
updateCommand.Parameters.AddWithValue("@OldCurrencyAlternateKey", olddbo_DimCurrencyClass.CurrencyAlternateKey);
updateCommand.Parameters.AddWithValue("@OldCurrencyName", olddbo_DimCurrencyClass.CurrencyName);
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static dbo_DimCurrencyClass Select_Record(dbo_DimCurrencyClass clsdbo_DimCurrencyPara)
{
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [CurrencyKey] "
+ " ,[CurrencyAlternateKey] "
+ " ,[CurrencyName] "
+ "FROM "
+ " [dbo].[DimCurrency] "
+ "WHERE "
+ " [CurrencyKey] = @CurrencyKey "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@CurrencyKey", clsdbo_DimCurrencyPara.CurrencyKey);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_DimCurrency.CurrencyKey = System.Convert.ToInt32(reader["CurrencyKey"]);
clsdbo_DimCurrency.CurrencyAlternateKey = System.Convert.ToString(reader["CurrencyAlternateKey"]);
clsdbo_DimCurrency.CurrencyName = System.Convert.ToString(reader["CurrencyName"]);
}
else
{
clsdbo_DimCurrency = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_DimCurrency);
}
finally
{
connection.Close();
}
return(clsdbo_DimCurrency);
}
public static bool Add(dbo_DimCurrencyClass clsdbo_DimCurrency)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[DimCurrency] "
+ " ( "
+ " [CurrencyAlternateKey] "
+ " ,[CurrencyName] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @CurrencyAlternateKey "
+ " ,@CurrencyName "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@CurrencyAlternateKey", clsdbo_DimCurrency.CurrencyAlternateKey);
insertCommand.Parameters.AddWithValue("@CurrencyName", clsdbo_DimCurrency.CurrencyName);
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private void DeleteRecord()
{
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
Label lblCurrencyKey = (Label)grddbo_DimCurrency.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblCurrencyKey");
clsdbo_DimCurrency.CurrencyKey = System.Convert.ToInt32(lblCurrencyKey.Text);
clsdbo_DimCurrency = dbo_DimCurrencyDataClass.Select_Record(clsdbo_DimCurrency);
bool bSucess = false;
bSucess = dbo_DimCurrencyDataClass.Delete(clsdbo_DimCurrency);
if (bSucess == true)
{
Session.Remove("dvdbo_DimCurrency");
LoadGriddbo_DimCurrency();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Dim Currency ");
}
}
public static bool Delete(dbo_DimCurrencyClass clsdbo_DimCurrency)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[DimCurrency] "
+ "WHERE "
+ " [CurrencyKey] = @OldCurrencyKey "
+ " AND [CurrencyAlternateKey] = @OldCurrencyAlternateKey "
+ " AND [CurrencyName] = @OldCurrencyName "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldCurrencyKey", clsdbo_DimCurrency.CurrencyKey);
deleteCommand.Parameters.AddWithValue("@OldCurrencyAlternateKey", clsdbo_DimCurrency.CurrencyAlternateKey);
deleteCommand.Parameters.AddWithValue("@OldCurrencyName", clsdbo_DimCurrency.CurrencyName);
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private void GetData()
{
ClearRecord();
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
clsdbo_DimCurrency.CurrencyKey = System.Convert.ToInt32(Session["CurrencyKey"]);
clsdbo_DimCurrency = dbo_DimCurrencyDataClass.Select_Record(clsdbo_DimCurrency);
if ((clsdbo_DimCurrency != null))
{
try {
txtCurrencyKey.Text = System.Convert.ToString(clsdbo_DimCurrency.CurrencyKey);
txtCurrencyAlternateKey.Text = System.Convert.ToString(clsdbo_DimCurrency.CurrencyAlternateKey);
txtCurrencyName.Text = System.Convert.ToString(clsdbo_DimCurrency.CurrencyName);
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Dim Currency ");
}
}
}
private void InsertRecord()
{
dbo_DimCurrencyClass clsdbo_DimCurrency = new dbo_DimCurrencyClass();
if (VerifyData() == true)
{
SetData(clsdbo_DimCurrency);
bool bSucess = false;
bSucess = dbo_DimCurrencyDataClass.Add(clsdbo_DimCurrency);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimCurrency");
LoadGriddbo_DimCurrency();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Currency ");
}
}
}
private void SetData(dbo_DimCurrencyClass clsdbo_DimCurrency)
{
clsdbo_DimCurrency.CurrencyAlternateKey = System.Convert.ToString(txtCurrencyAlternateKey.Text);
clsdbo_DimCurrency.CurrencyName = System.Convert.ToString(txtCurrencyName.Text);
}
