private void DeleteRecord()
{
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
Label lblSalesOrderNumber = (Label)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSalesOrderNumber");
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(lblSalesOrderNumber.Text);
Label lblSalesOrderLineNumber = (Label)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSalesOrderLineNumber");
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(lblSalesOrderLineNumber.Text);
Label lblSalesReasonKey = (Label)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblSalesReasonKey");
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(lblSalesReasonKey.Text);
clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason);
bool bSucess = false;
bSucess = dbo_FactInternetSalesReasonDataClass.Delete(clsdbo_FactInternetSalesReason);
if (bSucess == true)
{
Session.Remove("dvdbo_FactInternetSalesReason");
LoadGriddbo_FactInternetSalesReason();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Fact Internet Sales Reason ");
}
}
private void DeleteRecord()
{
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(Session["SalesOrderNumber"]);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(Session["SalesOrderLineNumber"]);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(Session["SalesReasonKey"]);
SetData(clsdbo_FactInternetSalesReason);
bool bSucess = false;
bSucess = dbo_FactInternetSalesReasonDataClass.Delete(clsdbo_FactInternetSalesReason);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
pnlDelete.Visible = false;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactInternetSalesReason");
LoadGriddbo_FactInternetSalesReason();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Fact Internet Sales Reason ");
}
}
private void UpdateRecord()
{
try {
DropDownList txtSalesOrderNumber = (DropDownList)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesOrderNumber");
DropDownList txtSalesOrderLineNumber = (DropDownList)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesOrderLineNumber");
DropDownList txtSalesReasonKey = (DropDownList)grddbo_FactInternetSalesReason.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSalesReasonKey");
dbo_FactInternetSalesReasonClass oclsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
oclsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.Text);
oclsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.Text);
oclsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.Text);
oclsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(oclsdbo_FactInternetSalesReason);
if (VerifyData() == true)
{
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.SelectedValue);
bool bSucess = false;
bSucess = dbo_FactInternetSalesReasonDataClass.Update(oclsdbo_FactInternetSalesReason, clsdbo_FactInternetSalesReason);
if (bSucess == true)
{
Session.Remove("dvdbo_FactInternetSalesReason");
grddbo_FactInternetSalesReason.EditIndex = -1;
LoadGriddbo_FactInternetSalesReason();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Fact Internet Sales Reason ");
}
}
} catch {
}
}
private void InsertRecord()
{
try {
DropDownList txtNewSalesOrderNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderNumber");
DropDownList txtNewSalesOrderLineNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderLineNumber");
DropDownList txtNewSalesReasonKey = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesReasonKey");
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
if (VerifyDataNew() == true)
{
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtNewSalesOrderNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtNewSalesOrderLineNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtNewSalesReasonKey.SelectedValue);
bool bSucess = false;
bSucess = dbo_FactInternetSalesReasonDataClass.Add(clsdbo_FactInternetSalesReason);
if (bSucess == true)
{
Session.Remove("dvdbo_FactInternetSalesReason");
LoadGriddbo_FactInternetSalesReason();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Internet Sales Reason ");
}
}
} catch {
}
}
public static dbo_FactInternetSalesReasonClass Select_Record(dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReasonPara)
{
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [SalesOrderNumber] "
+ " ,[SalesOrderLineNumber] "
+ " ,[SalesReasonKey] "
+ "FROM "
+ " [dbo].[FactInternetSalesReason] "
+ "WHERE "
+ " [SalesOrderNumber] = @SalesOrderNumber "
+ " AND [SalesOrderLineNumber] = @SalesOrderLineNumber "
+ " AND [SalesReasonKey] = @SalesReasonKey "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@SalesOrderNumber", clsdbo_FactInternetSalesReasonPara.SalesOrderNumber);
selectCommand.Parameters.AddWithValue("@SalesOrderLineNumber", clsdbo_FactInternetSalesReasonPara.SalesOrderLineNumber);
selectCommand.Parameters.AddWithValue("@SalesReasonKey", clsdbo_FactInternetSalesReasonPara.SalesReasonKey);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(reader["SalesOrderNumber"]);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(reader["SalesOrderLineNumber"]);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(reader["SalesReasonKey"]);
}
else
{
clsdbo_FactInternetSalesReason = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_FactInternetSalesReason);
}
finally
{
connection.Close();
}
return(clsdbo_FactInternetSalesReason);
}
public static bool Update(dbo_FactInternetSalesReasonClass olddbo_FactInternetSalesReasonClass,
dbo_FactInternetSalesReasonClass newdbo_FactInternetSalesReasonClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[FactInternetSalesReason] "
+ "SET "
+ " [SalesOrderNumber] = @NewSalesOrderNumber "
+ " ,[SalesOrderLineNumber] = @NewSalesOrderLineNumber "
+ " ,[SalesReasonKey] = @NewSalesReasonKey "
+ "WHERE "
+ " [SalesOrderNumber] = @OldSalesOrderNumber "
+ " AND [SalesOrderLineNumber] = @OldSalesOrderLineNumber "
+ " AND [SalesReasonKey] = @OldSalesReasonKey "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewSalesOrderNumber", newdbo_FactInternetSalesReasonClass.SalesOrderNumber);
updateCommand.Parameters.AddWithValue("@NewSalesOrderLineNumber", newdbo_FactInternetSalesReasonClass.SalesOrderLineNumber);
updateCommand.Parameters.AddWithValue("@NewSalesReasonKey", newdbo_FactInternetSalesReasonClass.SalesReasonKey);
updateCommand.Parameters.AddWithValue("@OldSalesOrderNumber", olddbo_FactInternetSalesReasonClass.SalesOrderNumber);
updateCommand.Parameters.AddWithValue("@OldSalesOrderLineNumber", olddbo_FactInternetSalesReasonClass.SalesOrderLineNumber);
updateCommand.Parameters.AddWithValue("@OldSalesReasonKey", olddbo_FactInternetSalesReasonClass.SalesReasonKey);
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static bool Add(dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[FactInternetSalesReason] "
+ " ( "
+ " [SalesOrderNumber] "
+ " ,[SalesOrderLineNumber] "
+ " ,[SalesReasonKey] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @SalesOrderNumber "
+ " ,@SalesOrderLineNumber "
+ " ,@SalesReasonKey "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@SalesOrderNumber", clsdbo_FactInternetSalesReason.SalesOrderNumber);
insertCommand.Parameters.AddWithValue("@SalesOrderLineNumber", clsdbo_FactInternetSalesReason.SalesOrderLineNumber);
insertCommand.Parameters.AddWithValue("@SalesReasonKey", clsdbo_FactInternetSalesReason.SalesReasonKey);
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private Boolean VerifyDataNew()
{
DropDownList txtNewSalesOrderNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderNumber");
DropDownList txtNewSalesOrderLineNumber = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesOrderLineNumber");
DropDownList txtNewSalesReasonKey = (DropDownList)grddbo_FactInternetSalesReason.FooterRow.FindControl("txtNewSalesReasonKey");
if (txtNewSalesOrderNumber.Text == "")
{
ec.ShowMessage(" Sales Order Number is Required. ", " Dbo. Fact Internet Sales Reason ");
txtNewSalesOrderNumber.Focus();
return(false);
}
if (txtNewSalesOrderLineNumber.Text == "")
{
ec.ShowMessage(" Sales Order Line Number is Required. ", " Dbo. Fact Internet Sales Reason ");
txtNewSalesOrderLineNumber.Focus();
return(false);
}
if (txtNewSalesReasonKey.Text == "")
{
ec.ShowMessage(" Sales Reason Key is Required. ", " Dbo. Fact Internet Sales Reason ");
txtNewSalesReasonKey.Focus();
return(false);
}
if (
txtNewSalesOrderNumber.SelectedIndex != -1 &&
txtNewSalesOrderLineNumber.SelectedIndex != -1 &&
txtNewSalesReasonKey.SelectedIndex != -1
)
{
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtNewSalesOrderNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtNewSalesOrderLineNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtNewSalesReasonKey.SelectedValue);
clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason);
if (clsdbo_FactInternetSalesReason != null)
{
ec.ShowMessage(" Record already exists. ", " Dbo. Fact Internet Sales Reason ");
txtNewSalesOrderNumber.Focus();
return(false);
}
}
return(true);
}
private void Edit()
{
try {
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
Label lblSalesOrderNumber = (Label)grddbo_FactInternetSalesReason.Rows[grddbo_FactInternetSalesReason.EditIndex].FindControl("lblSalesOrderNumber");
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(lblSalesOrderNumber.Text);
Label lblSalesOrderLineNumber = (Label)grddbo_FactInternetSalesReason.Rows[grddbo_FactInternetSalesReason.EditIndex].FindControl("lblSalesOrderLineNumber");
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(lblSalesOrderLineNumber.Text);
Label lblSalesReasonKey = (Label)grddbo_FactInternetSalesReason.Rows[grddbo_FactInternetSalesReason.EditIndex].FindControl("lblSalesReasonKey");
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(lblSalesReasonKey.Text);
clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason);
Session["SalesOrderNumber_SelectedValue"] = clsdbo_FactInternetSalesReason.SalesOrderNumber;
Session["SalesOrderLineNumber_SelectedValue"] = clsdbo_FactInternetSalesReason.SalesOrderLineNumber;
Session["SalesReasonKey_SelectedValue"] = clsdbo_FactInternetSalesReason.SalesReasonKey;
LoadGriddbo_FactInternetSalesReason();
} catch {
}
}
private Boolean VerifyData()
{
if (txtSalesOrderNumber.Text == "")
{
ec.ShowMessage(" Sales Order Number is Required. ", " Dbo. Fact Internet Sales Reason ");
txtSalesOrderNumber.Focus();
return(false);
}
if (txtSalesOrderLineNumber.Text == "")
{
ec.ShowMessage(" Sales Order Line Number is Required. ", " Dbo. Fact Internet Sales Reason ");
txtSalesOrderLineNumber.Focus();
return(false);
}
if (txtSalesReasonKey.Text == "")
{
ec.ShowMessage(" Sales Reason Key is Required. ", " Dbo. Fact Internet Sales Reason ");
txtSalesReasonKey.Focus();
return(false);
}
if (
txtSalesOrderNumber.SelectedIndex != -1 &&
txtSalesOrderLineNumber.SelectedIndex != -1 &&
txtSalesReasonKey.SelectedIndex != -1
)
{
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.SelectedValue);
clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason);
if (clsdbo_FactInternetSalesReason != null && (String)Session["Mode"] == "Add")
{
ec.ShowMessage(" Record already exists. ", " Dbo. Fact Internet Sales Reason ");
txtSalesOrderNumber.Focus();
return(false);
}
}
return(true);
}
public static bool Delete(dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[FactInternetSalesReason] "
+ "WHERE "
+ " [SalesOrderNumber] = @OldSalesOrderNumber "
+ " AND [SalesOrderLineNumber] = @OldSalesOrderLineNumber "
+ " AND [SalesReasonKey] = @OldSalesReasonKey "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldSalesOrderNumber", clsdbo_FactInternetSalesReason.SalesOrderNumber);
deleteCommand.Parameters.AddWithValue("@OldSalesOrderLineNumber", clsdbo_FactInternetSalesReason.SalesOrderLineNumber);
deleteCommand.Parameters.AddWithValue("@OldSalesReasonKey", clsdbo_FactInternetSalesReason.SalesReasonKey);
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private void InsertRecord()
{
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
if (VerifyData() == true)
{
SetData(clsdbo_FactInternetSalesReason);
bool bSucess = false;
bSucess = dbo_FactInternetSalesReasonDataClass.Add(clsdbo_FactInternetSalesReason);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactInternetSalesReason");
LoadGriddbo_FactInternetSalesReason();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Internet Sales Reason ");
}
}
}
private void GetData()
{
ClearRecord();
dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason = new dbo_FactInternetSalesReasonClass();
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(Session["SalesOrderNumber"]);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(Session["SalesOrderLineNumber"]);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(Session["SalesReasonKey"]);
clsdbo_FactInternetSalesReason = dbo_FactInternetSalesReasonDataClass.Select_Record(clsdbo_FactInternetSalesReason);
if ((clsdbo_FactInternetSalesReason != null))
{
try {
txtSalesOrderNumber.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSalesReason.SalesOrderNumber);
txtSalesOrderLineNumber.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSalesReason.SalesOrderLineNumber);
txtSalesReasonKey.SelectedValue = System.Convert.ToString(clsdbo_FactInternetSalesReason.SalesReasonKey);
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Fact Internet Sales Reason ");
}
}
}
private void SetData(dbo_FactInternetSalesReasonClass clsdbo_FactInternetSalesReason)
{
clsdbo_FactInternetSalesReason.SalesOrderNumber = System.Convert.ToString(txtSalesOrderNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesOrderLineNumber = System.Convert.ToByte(txtSalesOrderLineNumber.SelectedValue);
clsdbo_FactInternetSalesReason.SalesReasonKey = System.Convert.ToInt32(txtSalesReasonKey.SelectedValue);
}
