private void InsertRecord()
{
try {
TextBox txtNewSalesReasonAlternateKey = (TextBox)grddbo_DimSalesReason.FooterRow.FindControl("txtNewSalesReasonAlternateKey");
TextBox txtNewSalesReasonName = (TextBox)grddbo_DimSalesReason.FooterRow.FindControl("txtNewSalesReasonName");
TextBox txtNewSalesReasonReasonType = (TextBox)grddbo_DimSalesReason.FooterRow.FindControl("txtNewSalesReasonReasonType");
dbo_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
if (VerifyDataNew() == true)
{
clsdbo_DimSalesReason.SalesReasonAlternateKey = System.Convert.ToInt32(txtNewSalesReasonAlternateKey.Text);
clsdbo_DimSalesReason.SalesReasonName = System.Convert.ToString(txtNewSalesReasonName.Text);
clsdbo_DimSalesReason.SalesReasonReasonType = System.Convert.ToString(txtNewSalesReasonReasonType.Text);
bool bSucess = false;
bSucess = dbo_DimSalesReasonDataClass.Add(clsdbo_DimSalesReason);
if (bSucess == true)
{
Session.Remove("dvdbo_DimSalesReason");
LoadGriddbo_DimSalesReason();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Sales Reason ");
}
}
} catch {
}
}
private void UpdateRecord()
{
try {
TextBox txtSalesReasonKey = (TextBox)grddbo_DimSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesReasonKey");
TextBox txtSalesReasonAlternateKey = (TextBox)grddbo_DimSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesReasonAlternateKey");
TextBox txtSalesReasonName = (TextBox)grddbo_DimSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesReasonName");
TextBox txtSalesReasonReasonType = (TextBox)grddbo_DimSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesReasonReasonType");
dbo_DimSalesReasonClass oclsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
dbo_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
oclsdbo_DimSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.Text);
oclsdbo_DimSalesReason = dbo_DimSalesReasonDataClass.Select_Record(oclsdbo_DimSalesReason);
if (VerifyData() == true)
{
clsdbo_DimSalesReason.SalesReasonAlternateKey = System.Convert.ToInt32(txtSalesReasonAlternateKey.Text);
clsdbo_DimSalesReason.SalesReasonName = System.Convert.ToString(txtSalesReasonName.Text);
clsdbo_DimSalesReason.SalesReasonReasonType = System.Convert.ToString(txtSalesReasonReasonType.Text);
bool bSucess = false;
bSucess = dbo_DimSalesReasonDataClass.Update(oclsdbo_DimSalesReason, clsdbo_DimSalesReason);
if (bSucess == true)
{
Session.Remove("dvdbo_DimSalesReason");
grddbo_DimSalesReason.EditIndex = -1;
LoadGriddbo_DimSalesReason();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Sales Reason ");
}
}
} catch {
}
}
private void UpdateRecord()
{
dbo_DimSalesReasonClass oclsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
dbo_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
oclsdbo_DimSalesReason.SalesReasonKey = System.Convert.ToInt32(Session["SalesReasonKey"]);
oclsdbo_DimSalesReason = dbo_DimSalesReasonDataClass.Select_Record(oclsdbo_DimSalesReason);
if (VerifyData() == true)
{
SetData(clsdbo_DimSalesReason);
bool bSucess = false;
bSucess = dbo_DimSalesReasonDataClass.Update(oclsdbo_DimSalesReason, clsdbo_DimSalesReason);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimSalesReason");
LoadGriddbo_DimSalesReason();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Sales Reason ");
}
}
}
private void Edit()
{
try {
dbo_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
Label lblSalesReasonKey = (Label)grddbo_DimSalesReason.Rows[grddbo_DimSalesReason.EditIndex].FindControl("lblSalesReasonKey");
clsdbo_DimSalesReason.SalesReasonKey = System.Convert.ToInt32(lblSalesReasonKey.Text);
clsdbo_DimSalesReason = dbo_DimSalesReasonDataClass.Select_Record(clsdbo_DimSalesReason);
LoadGriddbo_DimSalesReason();
} catch {
}
}
public static bool Update(dbo_DimSalesReasonClass olddbo_DimSalesReasonClass,
dbo_DimSalesReasonClass newdbo_DimSalesReasonClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[DimSalesReason] "
+ "SET "
+ " [SalesReasonAlternateKey] = @NewSalesReasonAlternateKey "
+ " ,[SalesReasonName] = @NewSalesReasonName "
+ " ,[SalesReasonReasonType] = @NewSalesReasonReasonType "
+ "WHERE "
+ " [SalesReasonKey] = @OldSalesReasonKey "
+ " AND [SalesReasonAlternateKey] = @OldSalesReasonAlternateKey "
+ " AND [SalesReasonName] = @OldSalesReasonName "
+ " AND [SalesReasonReasonType] = @OldSalesReasonReasonType "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewSalesReasonAlternateKey", newdbo_DimSalesReasonClass.SalesReasonAlternateKey);
updateCommand.Parameters.AddWithValue("@NewSalesReasonName", newdbo_DimSalesReasonClass.SalesReasonName);
updateCommand.Parameters.AddWithValue("@NewSalesReasonReasonType", newdbo_DimSalesReasonClass.SalesReasonReasonType);
updateCommand.Parameters.AddWithValue("@OldSalesReasonKey", olddbo_DimSalesReasonClass.SalesReasonKey);
updateCommand.Parameters.AddWithValue("@OldSalesReasonAlternateKey", olddbo_DimSalesReasonClass.SalesReasonAlternateKey);
updateCommand.Parameters.AddWithValue("@OldSalesReasonName", olddbo_DimSalesReasonClass.SalesReasonName);
updateCommand.Parameters.AddWithValue("@OldSalesReasonReasonType", olddbo_DimSalesReasonClass.SalesReasonReasonType);
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_DimSalesReasonClass Select_Record(dbo_DimSalesReasonClass clsdbo_DimSalesReasonPara)
{
dbo_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [SalesReasonKey] "
+ " ,[SalesReasonAlternateKey] "
+ " ,[SalesReasonName] "
+ " ,[SalesReasonReasonType] "
+ "FROM "
+ " [dbo].[DimSalesReason] "
+ "WHERE "
+ " [SalesReasonKey] = @SalesReasonKey "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@SalesReasonKey", clsdbo_DimSalesReasonPara.SalesReasonKey);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_DimSalesReason.SalesReasonKey = System.Convert.ToInt32(reader["SalesReasonKey"]);
clsdbo_DimSalesReason.SalesReasonAlternateKey = System.Convert.ToInt32(reader["SalesReasonAlternateKey"]);
clsdbo_DimSalesReason.SalesReasonName = System.Convert.ToString(reader["SalesReasonName"]);
clsdbo_DimSalesReason.SalesReasonReasonType = System.Convert.ToString(reader["SalesReasonReasonType"]);
}
else
{
clsdbo_DimSalesReason = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_DimSalesReason);
}
finally
{
connection.Close();
}
return(clsdbo_DimSalesReason);
}
public static bool Add(dbo_DimSalesReasonClass clsdbo_DimSalesReason)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[DimSalesReason] "
+ " ( "
+ " [SalesReasonAlternateKey] "
+ " ,[SalesReasonName] "
+ " ,[SalesReasonReasonType] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @SalesReasonAlternateKey "
+ " ,@SalesReasonName "
+ " ,@SalesReasonReasonType "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@SalesReasonAlternateKey", clsdbo_DimSalesReason.SalesReasonAlternateKey);
insertCommand.Parameters.AddWithValue("@SalesReasonName", clsdbo_DimSalesReason.SalesReasonName);
insertCommand.Parameters.AddWithValue("@SalesReasonReasonType", clsdbo_DimSalesReason.SalesReasonReasonType);
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_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
Label lblSalesReasonKey = (Label)grddbo_DimSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSalesReasonKey");
clsdbo_DimSalesReason.SalesReasonKey = System.Convert.ToInt32(lblSalesReasonKey.Text);
clsdbo_DimSalesReason = dbo_DimSalesReasonDataClass.Select_Record(clsdbo_DimSalesReason);
bool bSucess = false;
bSucess = dbo_DimSalesReasonDataClass.Delete(clsdbo_DimSalesReason);
if (bSucess == true)
{
Session.Remove("dvdbo_DimSalesReason");
LoadGriddbo_DimSalesReason();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Dim Sales Reason ");
}
}
public static bool Delete(dbo_DimSalesReasonClass clsdbo_DimSalesReason)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[DimSalesReason] "
+ "WHERE "
+ " [SalesReasonKey] = @OldSalesReasonKey "
+ " AND [SalesReasonAlternateKey] = @OldSalesReasonAlternateKey "
+ " AND [SalesReasonName] = @OldSalesReasonName "
+ " AND [SalesReasonReasonType] = @OldSalesReasonReasonType "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldSalesReasonKey", clsdbo_DimSalesReason.SalesReasonKey);
deleteCommand.Parameters.AddWithValue("@OldSalesReasonAlternateKey", clsdbo_DimSalesReason.SalesReasonAlternateKey);
deleteCommand.Parameters.AddWithValue("@OldSalesReasonName", clsdbo_DimSalesReason.SalesReasonName);
deleteCommand.Parameters.AddWithValue("@OldSalesReasonReasonType", clsdbo_DimSalesReason.SalesReasonReasonType);
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_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
clsdbo_DimSalesReason.SalesReasonKey = System.Convert.ToInt32(Session["SalesReasonKey"]);
clsdbo_DimSalesReason = dbo_DimSalesReasonDataClass.Select_Record(clsdbo_DimSalesReason);
if ((clsdbo_DimSalesReason != null))
{
try {
txtSalesReasonKey.Text = System.Convert.ToString(clsdbo_DimSalesReason.SalesReasonKey);
txtSalesReasonAlternateKey.Text = System.Convert.ToString(clsdbo_DimSalesReason.SalesReasonAlternateKey);
txtSalesReasonName.Text = System.Convert.ToString(clsdbo_DimSalesReason.SalesReasonName);
txtSalesReasonReasonType.Text = System.Convert.ToString(clsdbo_DimSalesReason.SalesReasonReasonType);
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Dim Sales Reason ");
}
}
}
private void InsertRecord()
{
dbo_DimSalesReasonClass clsdbo_DimSalesReason = new dbo_DimSalesReasonClass();
if (VerifyData() == true)
{
SetData(clsdbo_DimSalesReason);
bool bSucess = false;
bSucess = dbo_DimSalesReasonDataClass.Add(clsdbo_DimSalesReason);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimSalesReason");
LoadGriddbo_DimSalesReason();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Sales Reason ");
}
}
}
private void SetData(dbo_DimSalesReasonClass clsdbo_DimSalesReason)
{
clsdbo_DimSalesReason.SalesReasonAlternateKey = System.Convert.ToInt32(txtSalesReasonAlternateKey.Text);
clsdbo_DimSalesReason.SalesReasonName = System.Convert.ToString(txtSalesReasonName.Text);
clsdbo_DimSalesReason.SalesReasonReasonType = System.Convert.ToString(txtSalesReasonReasonType.Text);
}
