public MainWindow()
{
InitializeComponent();
SalesPersonTableAdapter salesPersonDataAdapter = new SalesPersonTableAdapter();
// Binds the pivot grid to data.
pivotGridControl1.DataSource = salesPersonDataAdapter.GetData();
// Creates a group and adds two fields to it.
PivotGridGroup OrderDateGroup = pivotGridControl1.Groups.Add(pivotGridControl1.Fields[2],
pivotGridControl1.Fields[3]);
// Locks the PivotGroupFilterValues object by disabling visual updates.
OrderDateGroup.FilterValues.BeginUpdate();
// Sets a filter type.
// It specifies that the PivotGridControl should display only filter values.
OrderDateGroup.FilterValues.FilterType = FieldFilterType.Included;
// Creates a filter value and adds it to the PivotGroupFilterValues.Values collection.
OrderDateGroup.FilterValues.Values.Add(1994);
// Creates a filter value and adds it to the PivotGroupFilterValues.Values collection.
// Then creates a child value of the filter value and adds it to the parent value
// collection.
OrderDateGroup.FilterValues.Values.Add(1995).ChildValues.Add(1);
// Unlocks the PivotGroupFilterValues object.
OrderDateGroup.FilterValues.EndUpdate();
}
public MainWindow()
{
InitializeComponent();
SalesPersonTableAdapter salesPersonDataAdapter = new SalesPersonTableAdapter();
pivotGridControl1.DataSource = salesPersonDataAdapter.GetData();
}
protected void Page_Load(object sender, EventArgs e)
{
saveButton.Click += new EventHandler(saveButton_Click);
cancelButton.Click += new EventHandler(cancelButton_Click);
deleteButton.Click += new EventHandler(deleteButton_Click);
deleteButton.Attributes["onclick"] = "javascript: return confirm('Are you sure want to delete this item?');";
int salesPersonId = GetIdFromQueryString();
if (!Page.IsPostBack)
{
if (salesPersonId > 0)
{
createEditLabel.Text = "Edit";
SalesPersonTableAdapter salesPersonAdapter = new SalesPersonTableAdapter();
DollarSaverDB.SalesPersonDataTable salesPeople = salesPersonAdapter.GetSalesPerson(salesPersonId);
if (salesPeople.Count != 1)
{
Response.Redirect("~/admin/SalesPersonList.aspx");
}
DollarSaverDB.SalesPersonRow salesPerson = salesPeople[0];
if (salesPerson.StationId != StationId)
{
Response.Redirect("~/admin/SalesPersonList.aspx");
}
idHidden.Value = salesPersonId.ToString();
firstNameBox.Text = salesPerson.FirstName;
lastNameBox.Text = salesPerson.LastName;
isActiveBox.Checked = salesPerson.IsActive;
if (!salesPerson.IsEmailAddressNull())
{
emailBox.Text = salesPerson.EmailAddress;
}
if (!salesPerson.IsMobilePhoneNull())
{
mobilePhoneBox.Text = salesPerson.MobilePhone;
}
if (!salesPerson.IsWorkPhoneNull())
{
workPhoneBox.Text = salesPerson.WorkPhone;
}
}
else
{
deleteButton.Visible = false;
saveButton.Text = "Create";
createEditLabel.Text = "Create";
}
}
}
void deleteButton_Click(object sender, EventArgs e)
{
SalesPersonTableAdapter salesPersonAdapter = new SalesPersonTableAdapter();
if (idHidden.Value != String.Empty)
{
//SalesPersonController sc = new SalesPersonController();
//SalesPerson salesPerson = sc.GetSalesPerson(Int32.Parse(idHidden.Value));
try {
salesPersonAdapter.Delete(Int32.Parse(idHidden.Value));
} catch (SqlException ex) {
if (ex.Number == 547)
{
ErrorMessage = "Sales Person cannot be deleted because they are assigned to an advertiser";
}
else
{
throw ex;
}
}
}
Response.Redirect("~/admin/SalesPersonList.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
salesPeopleGrid.RowDataBound += new GridViewRowEventHandler(salesPeopleGrid_RowDataBound);
SalesPersonTableAdapter salesPersonAdapter = new SalesPersonTableAdapter();
DollarSaverDB.SalesPersonDataTable salesPeople = salesPersonAdapter.GetByStation(StationId);
if (salesPeople.Count > 0)
{
salesPeopleHolder.Visible = true;
noDataFoundHolder.Visible = false;
salesPeopleGrid.DataSource = salesPeople.Rows;
salesPeopleGrid.DataBind();
if (ReadOnly)
{
newLink.Visible = false;
salesPeopleGrid.Columns[0].Visible = false;
salesPeopleGrid.Columns[1].Visible = true;
}
else
{
newLink.Visible = true;
salesPeopleGrid.Columns[0].Visible = true;
salesPeopleGrid.Columns[1].Visible = false;
}
}
else
{
salesPeopleHolder.Visible = false;
noDataFoundHolder.Visible = true;
}
}
void saveButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
//SalesPersonController sc = new SalesPersonController();
String firstName = firstNameBox.Text.Trim();
if (firstName == String.Empty)
{
ErrorMessage = "First Name is required";
return;
}
String lastName = lastNameBox.Text.Trim();
if (lastName == String.Empty)
{
ErrorMessage = "Last Name is required";
return;
}
bool isActive = isActiveBox.Checked;
String emailAddress = emailBox.Text.Trim();
emailAddress = Globals.ConvertToNull(emailAddress);
if (emailAddress != null && !Regex.IsMatch(emailAddress, @"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$"))
{
ErrorMessage = "E-mail address is not valid";
return;
}
String mobilePhone = mobilePhoneBox.Text.Trim();
String workPhone = workPhoneBox.Text.Trim();
mobilePhone = Globals.ConvertToNull(mobilePhone);
workPhone = Globals.ConvertToNull(workPhone);
SalesPersonTableAdapter salesPersonAdapter = new SalesPersonTableAdapter();
if (idHidden.Value != String.Empty)
{
DollarSaverDB.SalesPersonRow salesPerson = salesPersonAdapter.GetSalesPerson(Int32.Parse(idHidden.Value))[0];
salesPerson.FirstName = firstName;
salesPerson.LastName = lastName;
salesPerson.IsActive = isActive;
if (emailAddress == null)
{
salesPerson.SetEmailAddressNull();
}
else
{
salesPerson.EmailAddress = emailAddress;
}
if (mobilePhone == null)
{
salesPerson.SetMobilePhoneNull();
}
else
{
salesPerson.MobilePhone = mobilePhone;
}
if (mobilePhone == null)
{
salesPerson.SetMobilePhoneNull();
}
else
{
salesPerson.MobilePhone = mobilePhone;
}
if (workPhone == null)
{
salesPerson.SetWorkPhoneNull();
}
else
{
salesPerson.WorkPhone = workPhone;
}
salesPersonAdapter.Update(salesPerson);
}
else
{
//sc.Insert(StationId, firstName, lastName, isActive);
salesPersonAdapter.Insert(StationId, firstName, lastName, mobilePhone, workPhone, emailAddress, isActive);
}
Response.Redirect("~/admin/SalesPersonList.aspx");
}
}
private void SalesDashboard_DashboardLoading(object sender, EventArgs e)
{
SalesPersonTableAdapter categories = new SalesPersonTableAdapter();
categories.Fill(this.nwindDataSet1.SalesPerson);
}
