private void FillList()
{
tableDialogs.TableModel.Rows.Clear();
CategoryTableAdapter kategorieTableAdapter = new CategoryTableAdapter(dataBase);
CategoryDataSet ds = new CategoryDataSet();
kategorieTableAdapter.Fill(ds.Category);
// Zuerst der Standard-Dialog
string[] newRow = new string[2];
newRow[0] = "<" + StringTable.Default + ">";
newRow[1] = HasDialog(0) ? StringTable.Yes : StringTable.No;
XPTable.Models.Row newTableRow = new XPTable.Models.Row(newRow);
newTableRow.Tag = null;
tableDialogs.TableModel.Rows.Add(newTableRow);
foreach (CategoryDataSet.CategoryRow row in ds.Category.Rows)
{
newRow[0] = row.Name;
newRow[1] = HasDialog(row.CategoryID) ? StringTable.Yes : StringTable.No;
newTableRow = new XPTable.Models.Row(newRow);
newTableRow.Tag = row;
tableDialogs.TableModel.Rows.Add(newTableRow);
}
}
private void CategoryDetailForm_Load(object sender, EventArgs e)
{
try
{
LocalizedCategoryNameTableAdapter localizedCategoryNameAdapter = new LocalizedCategoryNameTableAdapter();
localizedCategoryNameAdapter.Fill(this.categoryDetailDataSet.LocalizedCategoryName, categoryId, cultureName);
if (categoryId > 0)
{
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
categoryAdapter.Fill(this.categoryDetailDataSet.Category, categoryId);
}
byte[] image = this.categoryDetailDataSet.Category.Rows[0]["Image"] as byte[];
if (image != null)
{
this.pictureBoxImage.Image = ImageEngine.Resize(ImageEngine.FromArray(image), this.pictureBoxImage.Size);
}
EnableButtons();
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
this.DialogResult = DialogResult.Abort;
this.Close();
}
}
public void DataViewDemo()
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
catAdap.Fill(Category);
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataView view = result.AsDataView();
view.Sort = "ProductName desc";
view.RowFilter = "CategoryID = 65985";
GridView7.DataSource = view;
GridView7.DataBind();
DataSet1.ProductsRow row = null;
List <DataSet1.ProductsRow> myList = new List <DataSet1.ProductsRow>();
foreach (DataRowView item in view)
{
row = (DataSet1.ProductsRow)item.Row;
myList.Add(row);
}
GridView8.DataSource = myList;
GridView8.DataBind();
}
public int GetIdByName(string name, bool createIfNew)
{
if (string.IsNullOrEmpty(name))
{
return(0);
}
Category category = GetByName(name);
if (category != null)
{
return(category.CategoryID);
}
else
{
// Nicht vorhanden, also neue Kategorie anlegen
CategoryTableAdapter cta = new CategoryTableAdapter(dataBase);
CategoryDataSet.CategoryDataTable cdt = cta.GetData();
cdt.AddCategoryRow(name, cdt.Rows.Count);
cta.Update(cdt);
int categoryid = (int)(decimal)dataBase.ExecuteScalar("SELECT @@IDENTITY");
dataBase.UpdateCategories();
return(categoryid);
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
FormName formName = new FormName();
formName.Text = StringTable.AddNewCategory;
formName.NameValue = "";
formName.AllowEmpty = false;
formName.ValidateName += delegate(object sender1, ValidateNameEventArgs e1)
{
if (dataBase.AllCategories.Names.Contains(e1.Name) && e1.Name != e1.OriginalName)
{
MessageBox.Show(string.Format(StringTable.CategoryAlreadyExists, e1.Name), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
e1.Cancel = true;
}
};
if (formName.ShowDialog(this) == DialogResult.OK)
{
CategoryTableAdapter cta = new CategoryTableAdapter(dataBase);
CategoryDataSet.CategoryDataTable cdt = cta.GetData();
cdt.AddCategoryRow(formName.NameValue, listBoxCategories.Items.Count + 1);
cta.Update(cdt);
FillList();
}
UpdateWindowState();
}
private void buttonImport_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = StringTable.FilterHitbase;
if (openFileDialog.ShowDialog(this) == DialogResult.OK)
{
DataBase dbImport = new DataBase();
dbImport.Open(openFileDialog.FileName);
CategoryTableAdapter cta = new CategoryTableAdapter(dataBase);
CategoryDataSet.CategoryDataTable cdt = cta.GetData();
int count = listBoxCategories.Items.Count + 1;
foreach (Category category in dbImport.AllCategories)
{
if (dataBase.GetIdByCategory(category.Name) < 0)
{
cdt.AddCategoryRow(category.Name, count++);
}
}
cta.Update(cdt);
dbImport.Close();
FillList();
UpdateWindowState();
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
string categoryName = txtCategory.Text.Trim();
if (string.IsNullOrEmpty(categoryName))
{
txtCategoryValidator.ErrorMessage = "Category cannot be blank";
return;
}
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
int categoryMatches = (int)categoryAdapter.ValidateCategoryName(categoryName);
if (categoryMatches != 0)
{
ErrorMessage = "There's already a category created with that name";
return;
}
categoryAdapter.Insert(StationId, null, categoryName, -1);
InfoMessage = "Category created";
Response.Redirect("~/admin/CategoryList.aspx");
}
private void buttonEdit_Click(object sender, EventArgs e)
{
if (listBoxCategories.SelectedItem == null)
{
return;
}
ListBoxItem item = (ListBoxItem)listBoxCategories.SelectedItem;
FormName formName = new FormName();
formName.Text = StringTable.EditCategory;
formName.NameValue = item.Category.Name;
if (formName.ShowDialog(this) == DialogResult.OK)
{
int oldId = dataBase.GetIdByCategory(item.Category.Name);
CategoryTableAdapter cta = new CategoryTableAdapter(dataBase);
CategoryDataSet.CategoryDataTable cdt = cta.GetDataById(item.Category.CategoryID);
cdt[0].Name = formName.NameValue;
cta.Update(cdt);
listBoxCategories.Items[listBoxCategories.SelectedIndex] = new ListBoxItem(cdt[0]);
UpdateSoundfiles(oldId, item.Category.Name, formName.NameValue, false);
}
UpdateWindowState();
}
void deleteButton_Click(object sender, EventArgs e)
{
categoryId = Int32.Parse(idHidden.Value);
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
try
{
int parentCategoryId = category.ParentCategoryId;
categoryAdapter.Delete(categoryId);
InfoMessage = "Category Deleted";
if (parentCategoryId > 0)
{
Response.Redirect("~/admin/CategoryEdit.aspx?id=" + parentCategoryId);
}
else
{
Response.Redirect("~/admin/CategoryList.aspx");
}
}
catch (SqlException ex)
{
if (ex.Number == 547)
{
ErrorMessage = "Category cannot be deleted because it is assigned to an Advertiser";
}
else
{
throw ex;
}
}
}
private void FormProduct_Load(object sender, EventArgs e)
{
string conn_str = "Server=.;Database=MiniMart;Integrated Security=true;";
SqlConnection conn = new SqlConnection(conn_str);
cate_adapter = new CategoryTableAdapter();
cate_adapter.Connection = conn;
cate_adapter.Fill(invent.Category);
unit_adapter = new UnitTypeTableAdapter();
unit_adapter.Connection = conn;
unit_adapter.Fill(invent.UnitType);
pro_adapter = new ProductTableAdapter();
pro_adapter.Connection = conn;
pro_adapter.Fill(invent.Product);
//bind to controls
cboCategory.DisplayMember = invent.Category.NameColumn.ColumnName;
cboCategory.ValueMember = invent.Category.IDColumn.ColumnName;
cboCategory.DataSource = invent.Category;
cboUnitType.DisplayMember = invent.UnitType.NameColumn.ColumnName;
cboUnitType.ValueMember = invent.UnitType.IDColumn.ColumnName;
cboUnitType.DataSource = invent.UnitType;
dataGridView1.DataSource = invent.Product;
(dataGridView1.Columns[invent.Product.ImageColumn.ColumnName] as DataGridViewImageColumn).ImageLayout = DataGridViewImageCellLayout.Zoom;
lblTotal.Text = "Total: " + invent.Product.Rows.Count.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
catAdap.Fill(Category);
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataTable queriedProducts = result.CopyToDataTable <DataSet1.ProductsRow>();
queriedProducts.TableName = "queriedProducts";
DataSet1 ds = new DataSet1();
ds.Tables.Add(queriedProducts);
//DataView view = result.AsDataView<DataSet1.ProductsRow>();
//view.RowFilter = "CategoryID = 65985";
GridView1.DataSource = ds.Tables["queriedProducts"];
GridView1.DataBind();
}
private void btnCatsFromLocal_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
string connectionPrefix = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
string client = new Uri(dmc.origUrl).Host;
string filename = client + ".mdb";
string app_data = Path.GetDirectoryName(Application.ExecutablePath) + @"\App_data\";
string dest = app_data + filename;
if (!File.Exists(dest))
{
MessageBox.Show("Cannot find data file");
return;
}
string connection = connectionPrefix + dest;
using (CategoryTableAdapter catsda = new CategoryTableAdapter())
{
catsda.SetConnection(new OleDbConnection(connection));
LocalCats.CategoryDataTable cats = new LocalCats.CategoryDataTable();
catsda.Fill(cats);
catsGrid.DataSource = cats;
}
Cursor.Current = Cursors.Default;
return;
}
// this class is used to create objects from the data in the database, using the dataset
private DatabaseController()
{
this.DataSet = new KantoorInrichtingDataSet();
this.TableAdapterManager = new KantoorInrichtingDataSetTableAdapters.TableAdapterManager();
this.CategoryTableAdapter = new KantoorInrichtingDataSetTableAdapters.categoryTableAdapter();
this.ProductTableAdapter = new KantoorInrichtingDataSetTableAdapters.productTableAdapter();
this.PlacementTableAdapter = new KantoorInrichtingDataSetTableAdapters.placementTableAdapter();
this.RoleTableAdapter = new KantoorInrichtingDataSetTableAdapters.roleTableAdapter();
this.SpaceTableAdapter = new KantoorInrichtingDataSetTableAdapters.spaceTableAdapter();
this.StaticPlacementTableAdapter = new KantoorInrichtingDataSetTableAdapters.static_placementTableAdapter();
this.StaticProductTableAdapter = new KantoorInrichtingDataSetTableAdapters.static_productTableAdapter();
this.UserTableAdapter = new KantoorInrichtingDataSetTableAdapters.userTableAdapter();
CategoryTableAdapter.Fill(DataSet.category);
ProductTableAdapter.Fill(DataSet.product);
PlacementTableAdapter.Fill(DataSet.placement);
RoleTableAdapter.Fill(DataSet.role);
SpaceTableAdapter.Fill(DataSet.space);
StaticPlacementTableAdapter.Fill(DataSet.static_placement);
StaticProductTableAdapter.Fill(DataSet.static_product);
UserTableAdapter.Fill(DataSet.user);
GetCategories_FromDatabase();
GetProducts_FromDatabase();
GetStaticProducts_FromDatabase();
GetSpaces_FromDatabase();
}
public void AddNew(string category)
{
// Nicht vorhanden, also neue Kategorie anlegen
CategoryTableAdapter cta = new CategoryTableAdapter(dataBase);
CategoryDataSet.CategoryDataTable cdt = cta.GetData();
cdt.AddCategoryRow(category, GetNextOrder());
cta.Update(cdt);
dataBase.UpdateCategories();
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
DollarSaverDB.CategoryDataTable categories = categoryAdapter.GetPrimaryCategoriesByStation(StationId);
categoryGrid.DataSource = categories.Rows;
categoryGrid.DataBind();
}
private void FormSaveDialog_Load(object sender, EventArgs e)
{
CategoryTableAdapter kategorieTableAdapter = new CategoryTableAdapter(dataBase);
CategoryDataSet ds = new CategoryDataSet();
kategorieTableAdapter.Fill(ds.Category);
foreach (CategoryDataSet.CategoryRow row in ds.Category.Rows)
{
listBoxCategories.Items.Add(new ListBoxItem(row.CategoryID, row.Name));
}
}
public ExperlogixRepository()
{
_seriesAdapter = new SeriesTableAdapter();
_modelAdapter = new ModelTableAdapter();
_categoryAdapter = new CategoryTableAdapter();
_listAdapter = new ListTableAdapter();
_lookupAdapter = new LookupTableAdapter();
_ruleAdapter = new RuleTableAdapter();
_attributeAdapter = new CategoryAttributeTableAdapter();
_formulaAdapter = new FormulaTableAdapter();
_attributeLookupAdapter = new CategoryAttLookupTableAdapter();
}
private void Form1_Load(object sender, EventArgs e)
{
BalanceTableAdapter.Fill(stockDataSet.Остатки);
TaxingTableAdapter.Fill(stockDataSet.Таксировка);
TaxTableAdapter.Fill(stockDataSet.Налоги);
BankTableAdapter.Fill(stockDataSet.Банк);
OrganizationTableAdapter.Fill(stockDataSet.Организация);
InvoiceTableAdapter.Fill(stockDataSet.Накладные);
MoveProductTableAdapter.Fill(stockDataSet.Движение_товара);
DivisionsTableAdapter.Fill(stockDataSet.Подразделения);
ProductTableAdapter.Fill(stockDataSet.Товар);
CategoryTableAdapter.Fill(stockDataSet.Категории_товара);
}
/// <summary>
/// Aktualisiert die Order aus der Liste in die Datenbank.
/// </summary>
private void SetOrderByList()
{
int index = 1;
foreach (ListBoxItem item in listBoxCategories.Items)
{
CategoryTableAdapter cta = new CategoryTableAdapter(dataBase);
CategoryDataSet.CategoryDataTable dt = cta.GetDataById(item.Category.CategoryID);
dt[0].Order = index;
cta.Update(dt);
index++;
}
}
void categoryGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
int categoryId = Int32.Parse(e.CommandArgument.ToString());
if (e.CommandName == "up")
{
categoryAdapter.MoveUp(categoryId);
}
else if (e.CommandName == "down")
{
categoryAdapter.MoveDown(categoryId);
}
}
void saveButton_Click(object sender, EventArgs e)
{
categoryId = Int32.Parse(idHidden.Value);
String name = nameBox.Text.Trim();
if (name == String.Empty)
{
ErrorMessage = "Name cannot be blank";
return;
}
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
if (categoryId > 0)
{
category = categoryAdapter.GetCategory(categoryId)[0];
category.Name = name;
categoryAdapter.Update(category);
parentCategoryId = category.ParentCategoryId;
}
else if (isNew == true && isSubCategory == false && Request.QueryString["parent_id"] == "NEW")
{
categoryAdapter.Insert(StationId, null, name, -1);
}
else
{
parentCategoryId = Int32.Parse(parentIdHidden.Value);
// SeqNo of -1 will assign it the next highest SeqNo for the category
categoryAdapter.Insert(StationId, parentCategoryId, name, -1);
}
InfoMessage = "Category Updated";
if (parentCategoryId > 0)
{
Response.Redirect("~/admin/CategoryEdit.aspx?id=" + parentCategoryId);
}
else
{
Response.Redirect("~/admin/CategoryList.aspx");
}
}
private void FormSale_Load(object sender, EventArgs e)
{
txtCashier.Text = $"{Program.StaffID} : {Program.KHName} : {Program.ENGName}";
//Customer
CustomerTableAdapter cust_adpater = new CustomerTableAdapter();
cust_adpater.Connection = Program.Connection;
cust_adpater.Fill(dataset.Customer);
cboCustomer.DisplayMember = "Name";
cboCustomer.ValueMember = "ID";
cboCustomer.DataSource = dataset.Customer;
cboCustomer.SelectedIndex = -1;
//Category
CategoryTableAdapter cate_adapter = new CategoryTableAdapter();
cate_adapter.Connection = Program.Connection;
cate_adapter.Fill(dataset.Category);
foreach (var cate in dataset.Category)
{
Button btnCategory = new Button();
btnCategory.Text = cate.Name;
btnCategory.Tag = cate.ID;
btnCategory.Width = flowLayoutPanel_Category.Width;
btnCategory.Height = 30;
btnCategory.Click += BtnCategory_Click;
flowLayoutPanel_Category.Controls.Add(btnCategory);
}
//
dataGridView_Purchasing_Items.DataSource = dataset.PurchasingItems;
dataGridView_Purchasing_Items.Columns[0].Visible = false;//ProductID
//add
DataGridViewImageColumn plus = new DataGridViewImageColumn();
//plus.HeaderText = "";
plus.ImageLayout = DataGridViewImageCellLayout.Zoom;
plus.Image = Properties.Resources.Plus_32px;
DataGridViewImageColumn delete = new DataGridViewImageColumn();
//delete.HeaderText = "";
delete.ImageLayout = DataGridViewImageCellLayout.Zoom;
delete.Image = Properties.Resources.Cancel_16px1;
dataGridView_Purchasing_Items.Columns.Add(plus);
dataGridView_Purchasing_Items.Columns.Add(delete);
}
private void popupBalanceR_Load(object sender, EventArgs e)
{
if (this.category != 0)
{
CategoryDataTable data = new CategoryTableAdapter().GetData();
this.ddlAccounts.DataSource = data;
this.ddlAccounts.ValueMember = "Category_ID";
this.ddlAccounts.DisplayMember = "Category_Name";
}
else
{
COA_TDataTable mainAccounts = new COA_TTableAdapter().GetMainAccounts();
this.ddlAccounts.DataSource = mainAccounts;
this.ddlAccounts.ValueMember = "GL_ID";
this.ddlAccounts.DisplayMember = "GL_Name_VC";
}
}
/*public StateReport resultReport;
*
* public enum StateReport
* {
* Close,
* GoReport
* }*/
private void ReportDataForm_Load(object sender, EventArgs e)
{
// TODO: данная строка кода позволяет загрузить данные в таблицу "stockDataSet.Отчет_накладные". При необходимости она может быть перемещена или удалена.
this.WaybillReportTableAdapter.Fill(this.stockDataSet.Отчет_накладные);
// TODO: данная строка кода позволяет загрузить данные в таблицу "stockDataSet.Накладные". При необходимости она может быть перемещена или удалена.
this.WaybillTableAdapter.Fill(this.stockDataSet.Накладные);
// TODO: данная строка кода позволяет загрузить данные в таблицу "stockDataSet.Отчет_остатки_товаров". При необходимости она может быть перемещена или удалена.
this.BalanceReportTableAdapter.Fill(this.stockDataSet.Отчет_остатки_товаров);
TrafficReportTableAdapter.Fill(stockDataSet.Отчет_по_движению_товаров);
ListOrganizationsTableAdapter.Fill(stockDataSet.Организации_поставившие_товар);
TOOTableAdapter.Fill(stockDataSet.ТОО_поставившая_товар);
DivisionsTableAdapter.Fill(stockDataSet.Подразделения);
ShippedTableAdapter.Fill(stockDataSet.Отгруженные_товары);
WealthTableAdapter.Fill(stockDataSet.Материальные_ценности);
ListProductsTableAdapter.Fill(stockDataSet.Пречень_товаров);
CategoryTableAdapter.Fill(stockDataSet.Категории_товара);
}
protected override void OnPreInit(EventArgs e)
{
int categoryId = GetValueFromQueryString("category_id");
if (categoryId > 0)
{
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
DollarSaverDB.CategoryDataTable categories = categoryAdapter.GetCategory(categoryId);
if (categories.Count == 1)
{
category = categories[0];
}
}
base.OnPreInit(e);
}
public void StronglyTypedDataSet()
{
DataSet1.CategoryDataTable CategoryDT = new DataSet1.CategoryDataTable();
CategoryTableAdapter CategoryTBAdapter = new CategoryTableAdapter();
DataSet1.ProductsDataTable ProductsDT = new DataSet1.ProductsDataTable();
ProductsTableAdapter ProductsTBAdapter = new ProductsTableAdapter();
CategoryTBAdapter.Fill(CategoryDT);
ProductsTBAdapter.Fill(ProductsDT);
var result = from cat in CategoryDT
join prod in ProductsDT
on cat.CategoryID equals prod.CategoryID
where cat.CategoryID == 65985
select new { CategoryName = cat.CategoryName, ProductName = prod.ProductName, UnitPrice = prod.UnitPrice };
GridView6.DataSource = result;
GridView6.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
catAdap.Fill(Category);
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataTable queriedProducts = result.CopyToDataTable<DataSet1.ProductsRow>();
queriedProducts.TableName = "queriedProducts";
DataSet1 ds = new DataSet1();
ds.Tables.Add(queriedProducts);
//DataView view = result.AsDataView<DataSet1.ProductsRow>();
//view.RowFilter = "CategoryID = 65985";
GridView1.DataSource = ds.Tables["queriedProducts"];
GridView1.DataBind();
}
private void FillList()
{
listBoxCategories.Items.Clear();
CategoryTableAdapter cta = new CategoryTableAdapter(dataBase);
CategoryDataSet.CategoryDataTable cdt = cta.GetData();
if (checkBoxAutoSort.Checked)
{
foreach (CategoryDataSet.CategoryRow category in cdt.OrderBy(x => x.Name))
{
listBoxCategories.Items.Add(new ListBoxItem(category));
}
}
else
{
foreach (CategoryDataSet.CategoryRow category in cdt.OrderBy(x => x.Order))
{
listBoxCategories.Items.Add(new ListBoxItem(category));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
saveButton.Click += new EventHandler(saveButton_Click);
cancelButton.Click += new EventHandler(cancelButton_Click);
if (Station.SiteTypeId != (int)SiteType.Standard)
{
Response.Redirect("~/admin/Default.aspx");
}
specialTable = specialAdapter.GetStationSpecial(StationId, 1);
if (specialTable.Count == 1)
{
specialOne = specialTable[0];
}
specialTable = specialAdapter.GetStationSpecial(StationId, 2);
if (specialTable.Count == 1)
{
specialTwo = specialTable[0];
}
specialTable = specialAdapter.GetStationSpecial(StationId, 3);
if (specialTable.Count == 1)
{
specialThree = specialTable[0];
}
specialTable = specialAdapter.GetStationSpecial(StationId, 4);
if (specialTable.Count == 1)
{
specialFour = specialTable[0];
}
if (!Page.IsPostBack)
{
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
DollarSaverDB.CategoryDataTable categories = categoryAdapter.GetPrimaryCategoriesByStation(StationId);
CertificateTableAdapter certificateAdapter = new CertificateTableAdapter();
DollarSaverDB.CertificateDataTable certificates = certificateAdapter.GetActive(StationId);
//certificates.DefaultView.Sort
SpecialSettingsTableAdapter specialSettingsAdapter = new SpecialSettingsTableAdapter();
DollarSaverDB.SpecialSettingsDataTable specialSettingsTable = specialSettingsAdapter.GetSpecialSettings(StationId);
if (specialSettingsTable.Count == 1)
{
if (specialSettingsTable[0].DailyHeader)
{
dailyWeeklyList.SelectedValue = "1";
}
else
{
dailyWeeklyList.SelectedValue = "2";
}
}
// Daily/Weekly Special 1
/*
* specialOneCategoryList.DataSource = categories;
* specialOneCategoryList.DataTextField = "Name";
* specialOneCategoryList.DataValueField = "CategoryId";
* specialOneCategoryList.DataBind();
*/
specialOneCertificateList.DataSource = certificates.Rows;
specialOneCertificateList.DataTextField = "AdvertiserAndCertificate";
specialOneCertificateList.DataValueField = "CertificateId";
specialOneCertificateList.DataBind();
if (specialOne != null)
{
if (!specialOne.IsCertificateIdNull())
{
//specialOneCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialOne.CertificateId) != null)
{
specialOneCertificateList.SelectedValue = specialOne.CertificateId.ToString();
}
}
/*
* else if (!specialOne.IsCategoryIdNull()) {
* specialOneCategoryBox.Checked = true;
*
* specialOneCategoryList.SelectedValue = specialOne.CategoryId.ToString();
* } else {
* specialOneRandomBox.Checked = true;
* }
*/
}
// Special 2
specialTwoCategoryList.DataSource = categories;
specialTwoCategoryList.DataTextField = "Name";
specialTwoCategoryList.DataValueField = "CategoryId";
specialTwoCategoryList.DataBind();
specialTwoCertificateList.DataSource = certificates.Rows;
specialTwoCertificateList.DataTextField = "AdvertiserAndCertificate";
specialTwoCertificateList.DataValueField = "CertificateId";
specialTwoCertificateList.DataBind();
if (specialTwo != null)
{
if (!specialTwo.IsCertificateIdNull())
{
specialTwoCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialTwo.CertificateId) != null)
{
specialTwoCertificateList.SelectedValue = specialTwo.CertificateId.ToString();
}
}
else if (!specialTwo.IsCategoryIdNull())
{
specialTwoCategoryBox.Checked = true;
specialTwoCategoryList.SelectedValue = specialTwo.CategoryId.ToString();
}
else
{
specialTwoRandomBox.Checked = true;
}
}
// Special 3
specialThreeCategoryList.DataSource = categories;
specialThreeCategoryList.DataTextField = "Name";
specialThreeCategoryList.DataValueField = "CategoryId";
specialThreeCategoryList.DataBind();
specialThreeCertificateList.DataSource = certificates.Rows;
specialThreeCertificateList.DataTextField = "AdvertiserAndCertificate";
specialThreeCertificateList.DataValueField = "CertificateId";
specialThreeCertificateList.DataBind();
if (specialThree != null)
{
if (!specialThree.IsCertificateIdNull())
{
specialThreeCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialThree.CertificateId) != null)
{
specialThreeCertificateList.SelectedValue = specialThree.CertificateId.ToString();
}
}
else if (!specialThree.IsCategoryIdNull())
{
specialThreeCategoryBox.Checked = true;
specialThreeCategoryList.SelectedValue = specialThree.CategoryId.ToString();
}
else
{
specialThreeRandomBox.Checked = true;
}
}
// Special 4
specialFourCategoryList.DataSource = categories;
specialFourCategoryList.DataTextField = "Name";
specialFourCategoryList.DataValueField = "CategoryId";
specialFourCategoryList.DataBind();
specialFourCertificateList.DataSource = certificates.Rows;
specialFourCertificateList.DataTextField = "AdvertiserAndCertificate";
specialFourCertificateList.DataValueField = "CertificateId";
specialFourCertificateList.DataBind();
if (specialFour != null)
{
if (!specialFour.IsCertificateIdNull())
{
specialFourCertificateBox.Checked = true;
if (certificates.FindByCertificateId(specialFour.CertificateId) != null)
{
specialFourCertificateList.SelectedValue = specialFour.CertificateId.ToString();
}
}
else if (!specialFour.IsCategoryIdNull())
{
specialFourCategoryBox.Checked = true;
specialFourCategoryList.SelectedValue = specialFour.CategoryId.ToString();
}
else
{
specialFourRandomBox.Checked = true;
}
}
}
}
void saveButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
StationTableAdapter stationAdapter = new StationTableAdapter();
String name = nameBox.Text.Trim();
int siteTypeId = Int32.Parse(siteTypeList.SelectedValue);
int stationTypeId = Int32.Parse(stationTypeList.SelectedValue);
String phoneNumber = phoneNumberBox.Text.Trim();
String address1 = address1Box.Text.Trim();
String address2 = address2Box.Text.Trim();
String city = cityBox.Text.Trim();
String stateCode = stateList.SelectedValue;
String zipCode = zipCodeBox.Text.Trim();
int timeZoneId = Int32.Parse(timeZoneList.SelectedValue);
//bool affectedByDST = daylightSavingsBox.Checked;
String stationUrl = stationUrlBox.Text.Trim();
String siteName = siteNameBox.Text.Trim();
String content1 = content1Box.Text.Trim();
String content2 = content2Box.Text.Trim();
//bool isActive = isActiveBox.Checked;
if (name == String.Empty)
{
ErrorMessage = "Name is required";
return;
}
if (phoneNumber == String.Empty)
{
ErrorMessage = "Phone Number is required";
return;
}
if (address1 == String.Empty)
{
ErrorMessage = "Address 1 is required";
return;
}
if (city == String.Empty)
{
ErrorMessage = "City is required";
return;
}
if (zipCode == String.Empty)
{
ErrorMessage = "Zip Code is required";
return;
}
if (stationUrl != String.Empty)
{
stationUrl = stationUrlStart.SelectedValue + stationUrl;
// come up with a better validation...
if (!Uri.IsWellFormedUriString(stationUrl, UriKind.Absolute))
{
ErrorMessage = "Please enter a valid Station Website";
return;
}
}
if (stationUrl.Length > 500)
{
stationUrl = stationUrl.Substring(0, 500);
}
/*
* if (content1 == String.Empty) {
* ErrorMessage = "Content 1 is required";
* return;
* }*/
if (content1.Length > 1000)
{
content1 = content1.Substring(0, 1000);
}
/*
* if (content2 == String.Empty) {
* ErrorMessage = "Content 2 is required";
* return;
* }*/
if (content2.Length > 1000)
{
content2 = content2.Substring(0, 1000);
}
siteName = siteName.Replace("<br />", "");
if (siteName.Length > 500)
{
siteName = siteName.Substring(0, 500);
}
String siteNameCheck = Regex.Replace(siteName, "<[^>]+>", "").Replace(" ", "").Trim();
if (siteNameCheck == String.Empty) // only leftover formatting in site name
{
siteName = String.Empty;
}
if (Station != null)
{
Station.Name = name;
Station.SiteTypeId = Int32.Parse(siteTypeList.SelectedValue);
Station.StationTypeId = Int32.Parse(stationTypeList.SelectedValue);
Station.PhoneNumber = phoneNumber;
Station.Address1 = address1;
Station.Address2 = address2;
Station.City = city;
Station.StateCode = stateList.SelectedValue;
Station.ZipCode = zipCode;
Station.TimeZoneId = Int32.Parse(timeZoneList.SelectedValue);
//Station.AffectedByDST = daylightSavingsBox.Checked;
if (stationUrl != String.Empty)
{
Station.StationUrl = stationUrl;
}
else
{
Station.SetStationUrlNull();
}
if (siteName != String.Empty)
{
Station.SiteName = siteName;
}
else
{
Station.SetSiteNameNull();
}
Station.Content1 = content1;
Station.Content2 = content2;
//Station.IsActive = isActiveBox.Checked;
Station.IsSiteActive = isSiteActiveBox.Checked;
stationAdapter.Update(Station);
InfoMessage = "Station Updated";
}
else
{
if (IsSuperAdmin)
{
String code = codeBox.Text.Trim().ToUpper();
if (code == String.Empty)
{
ErrorMessage = "Code is required";
return;
}
if (code.Length < 3 || code.Length > 20)
{
ErrorMessage = "Code must be between 3 and 20 characters";
return;
}
DollarSaverDB.StationDataTable stationCodeLookup = stationAdapter.GetByCode(code);
if (stationCodeLookup.Count == 1 && (Station == null || stationCodeLookup[0].StationId != Station.StationId))
{
InfoMessage = "Code is already in use";
return;
}
int stationId = Convert.ToInt32(stationAdapter.InsertPK(name, code, stationTypeId, siteTypeId, phoneNumber, address1, address2,
city, stateCode, zipCode, timeZoneId, false, DateTime.Now, DateTime.Now, true,
content1, content2, Globals.ConvertToNull(stationUrl), Globals.ConvertToNull(siteName), isSiteActiveBox.Checked, null));
Station = stationAdapter.GetStation(stationId)[0];
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
categoryAdapter.Insert(stationId, null, "Restaurants & Food", 1);
categoryAdapter.Insert(stationId, null, "Things To Do", 2);
categoryAdapter.Insert(stationId, null, "Home & Garden", 3);
categoryAdapter.Insert(stationId, null, "Health & Beauty", 4);
categoryAdapter.Insert(stationId, null, "Retail", 5);
categoryAdapter.Insert(stationId, null, "Automotive", 6);
StationContentTableAdapter stationContentTableAdapter = new StationContentTableAdapter();
stationContentTableAdapter.Insert(stationId, null, null, null, null, null, null, null, null, null);
DealSettingsTableAdapter dealSettingsAdapter = new DealSettingsTableAdapter();
dealSettingsAdapter.Insert(stationId, 1, 8, 4, 10);
SpecialSettingsTableAdapter specialSettingAdapter = new SpecialSettingsTableAdapter();
specialSettingAdapter.Insert(stationId, true);
if (!Directory.Exists(Request.PhysicalApplicationPath + Station.StationDirUrl))
{
Directory.CreateDirectory(Request.PhysicalApplicationPath + Station.StationDirUrl);
}
if (!Directory.Exists(Request.PhysicalApplicationPath + Station.ImageDirUrl))
{
Directory.CreateDirectory(Request.PhysicalApplicationPath + Station.ImageDirUrl);
}
}
}
RedirectToHomePage();
}
}
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?');";
subCategoryGrid.RowCommand += new GridViewCommandEventHandler(subCategoryGrid_RowCommand);
categoryId = GetIdFromQueryString();
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
if (categoryId != 0)
{
DollarSaverDB.CategoryDataTable categories = categoryAdapter.GetCategory(categoryId);
if (categories.Rows.Count != 1)
{
Response.Redirect("~/admin/CategoryList.aspx");
}
category = categories[0];
if (category.StationId != StationId)
{
Response.Redirect("~/admin/CategoryList.aspx");
}
if (!category.IsParentCategoryIdNull())
{
parentCategoryId = category.ParentCategoryId;
parentCategory = categoryAdapter.GetCategory(parentCategoryId)[0];
}
}
else
{
parentCategoryId = GetParentIdFromQueryString();
DollarSaverDB.CategoryDataTable parentCategories = categoryAdapter.GetCategory(parentCategoryId);
if (parentCategories.Rows.Count != 1)
{
Response.Redirect("~/admin/CategoryList.aspx");
}
parentCategory = parentCategories[0];
if (parentCategory.StationId != StationId)
{
Response.Redirect("~/admin/CategoryList.aspx");
}
isNew = true;
}
if (isNew || !category.IsParentCategoryIdNull())
{
isSubCategory = true;
}
}
public void DataViewDemo()
{
DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable();
CategoryTableAdapter catAdap = new CategoryTableAdapter();
catAdap.Fill(Category);
DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable();
ProductsTableAdapter prodAdap = new ProductsTableAdapter();
prodAdap.Fill(Products);
var result = from item in Products
select item;
DataView view = result.AsDataView();
view.Sort = "ProductName desc";
view.RowFilter = "CategoryID = 65985";
GridView7.DataSource = view;
GridView7.DataBind();
DataSet1.ProductsRow row = null;
List<DataSet1.ProductsRow> myList = new List<DataSet1.ProductsRow>();
foreach (DataRowView item in view)
{
row = (DataSet1.ProductsRow)item.Row;
myList.Add(row);
}
GridView8.DataSource = myList;
GridView8.DataBind();
}
public void StronglyTypedDataSet()
{
DataSet1.CategoryDataTable CategoryDT = new DataSet1.CategoryDataTable();
CategoryTableAdapter CategoryTBAdapter = new CategoryTableAdapter();
DataSet1.ProductsDataTable ProductsDT = new DataSet1.ProductsDataTable();
ProductsTableAdapter ProductsTBAdapter = new ProductsTableAdapter();
CategoryTBAdapter.Fill(CategoryDT);
ProductsTBAdapter.Fill(ProductsDT);
var result = from cat in CategoryDT
join prod in ProductsDT
on cat.CategoryID equals prod.CategoryID
where cat.CategoryID == 65985
select new { CategoryName = cat.CategoryName, ProductName = prod.ProductName, UnitPrice = prod.UnitPrice };
GridView6.DataSource = result;
GridView6.DataBind();
}
private void buttonOk_Click(object sender, EventArgs e)
{
try
{
this.BindingContext[this.categoryDetailDataSet, CATEGORY].EndCurrentEdit();
this.BindingContext[this.categoryDetailDataSet, LOCALIZED_CATEGORY_NAME].EndCurrentEdit();
DataRowView view = this.BindingContext[categoryDetailDataSet, CATEGORY].Current as DataRowView;
CategoryDetailDataSet.CategoryRow row = view.Row as CategoryDetailDataSet.CategoryRow;
if (row.IsImageNull())
{
this.DialogResult = DialogResult.None;
// Initializes the variables to pass to the MessageBox.Show method.
string message = Resources.ImageNotSetMessage;
string caption = Resources.ErrorCaption;
// Displays the MessageBox.
MessageBox.Show(this, message, caption, MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
foreach (CategoryDetailDataSet.LocalizedCategoryNameRow localizedNameRow in this.categoryDetailDataSet.LocalizedCategoryName.Rows)
{
if (localizedNameRow.CultureName == this.cultureName)
{
if (localizedNameRow.IsNameNull() || localizedNameRow.Name.Trim().Length == 0)
{
this.DialogResult = DialogResult.None;
// Initializes the variables to pass to the MessageBox.Show method.
string message = string.Format(Resources.CannotBeEmptyMessage, localizedNameRow.Language);
string caption = Resources.ErrorCaption;
// Displays the MessageBox.
MessageBox.Show(this, message, caption, MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
break;
}
}
CategoryDetailDataSet changes = (CategoryDetailDataSet)categoryDetailDataSet.GetChanges();
if (changes != null)
{
CategoryTableAdapter categoryAdapter = new CategoryTableAdapter();
categoryAdapter.Connection.Open();
categoryAdapter.Update(changes);
SqlCommand sqlUpdateCommand = new SqlCommand();
sqlUpdateCommand.Connection = categoryAdapter.Connection;
sqlUpdateCommand.CommandText = @"UPDATE Resource SET [Text] = @Text "
+ "WHERE (ResourceId = @ResourceId AND CultureId = @CultureId) ";
sqlUpdateCommand.Parameters.Add(new SqlParameter("@Text", System.Data.SqlDbType.NText, 0, "Text"));
sqlUpdateCommand.Parameters.Add(new SqlParameter("@ResourceId", System.Data.SqlDbType.UniqueIdentifier, 0, "ResourceId"));
sqlUpdateCommand.Parameters.Add(new SqlParameter("@CultureId", System.Data.SqlDbType.Int, 0, "CultureId"));
SqlCommand sqlInsertCommand = new SqlCommand();
sqlInsertCommand.Connection = categoryAdapter.Connection;
sqlInsertCommand.CommandText = @"INSERT INTO Resource([Text], ResourceId, CultureId) VALUES(@Text, @ResourceId, @CultureId) ";
sqlInsertCommand.Parameters.Add(new SqlParameter("@Text", System.Data.SqlDbType.NText, 0, "Text"));
sqlInsertCommand.Parameters.Add(new SqlParameter("@ResourceId", System.Data.SqlDbType.UniqueIdentifier, 0, "ResourceId"));
sqlInsertCommand.Parameters.Add(new SqlParameter("@CultureId", System.Data.SqlDbType.Int, 0, "CultureId"));
Guid resourceId = row.Name;
DataRow[] rows = this.categoryDetailDataSet.LocalizedCategoryName.Select("", "", DataViewRowState.ModifiedCurrent);
foreach (DataRow modifiedRow in rows)
{
if (modifiedRow.IsNull("ResourceId"))
{
sqlInsertCommand.Parameters["@Text"].Value = modifiedRow["Name"];
sqlInsertCommand.Parameters["@ResourceId"].Value = resourceId;
sqlInsertCommand.Parameters["@CultureId"].Value = modifiedRow["CultureId"];
sqlInsertCommand.ExecuteNonQuery();
}
else
{
sqlUpdateCommand.Parameters["@Text"].Value = modifiedRow["Name"];
sqlUpdateCommand.Parameters["@ResourceId"].Value = resourceId;
sqlUpdateCommand.Parameters["@CultureId"].Value = modifiedRow["CultureId"];
sqlUpdateCommand.ExecuteNonQuery();
}
}
categoryAdapter.Connection.Close();
}
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
this.DialogResult = DialogResult.Cancel;
}
}
