private void refresh()
{
tblCategory = adpCategory.GetData();
Cache["tblCategory"] = tblCategory;
grdCategory.DataSource = tblCategory;
grdCategory.DataBind();
}
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();
}
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 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();
}
}
private void RefreshGridView()
{
tblBook = adpBook.GetData(); // get the datatable
grdBook.DataSource = tblBook;
grdBook.DataBind();
tblAuthor = adpAuthor.GetData();
tblCat = adpCat.GetData();
tblPub = adpPub.GetData();
lstAuthor.DataSource = tblAuthor;
lstAuthor.DataTextField = tblAuthor.AuthorNameColumn.ToString();
lstAuthor.DataValueField = tblAuthor.AuthorIdColumn.ToString();
lstAuthor.DataBind();
lstAuthor.Items.Insert(0, new ListItem("Add Author", "-1"));
//lstAuthor.SelectedIndex = 1;
lstPub.DataSource = tblPub;
lstPub.DataTextField = tblPub.PublisherNameColumn.ToString();
lstPub.DataValueField = tblPub.PublisherIdColumn.ToString();
lstPub.DataBind();
lstPub.Items.Insert(0, new ListItem("Add Publisher", "-1"));
//lstPub.SelectedIndex = 1;
lstCat.DataSource = tblCat;
lstCat.DataTextField = tblCat.CategoryNameColumn.ToString();
lstCat.DataValueField = tblCat.CategoryIdColumn.ToString();
lstCat.DataBind();
lstCat.Items.Insert(0, new ListItem("Add Category", "-1"));
//lstCat.SelectedIndex = 1;
}
public IEnumerable <Category> GetallData()
{
// Brand b=new Brand(1,"hjgf");
List <Category> li = new List <Category>();
var data = from c in _category.GetData() select c;
foreach (var item in data)
{
//li.Add(b);
li.Add(new Category
{
CategoryId = item.CategoryId,
CategoryName = item.CategoryName
});
}
return(li);
}
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();
}
private void Refresh()
{
tblCategory = adpCategory.GetData();
Cache["tblCategory"] = tblCategory;
ddlCategory.DataSource = tblCategory;
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CategoryId";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, new ListItem("Select a Category", "-1"));
tblCategProduct = adpCategProduct.GetData();
Cache["tblCategProduct"] = tblCategProduct;
grdCategProduct.DataSource = tblCategProduct;
grdCategProduct.DataBind();
}
private void Refresh()
{
tblOrdercf = adpOrdercf.GetDataMax();
Cache["tblOrderfc"] = tblOrdercf;
createOrder();
txtQuantity.Text = "1";
tblCategory = adpCategory.GetData();
ddlCategoryProd.DataSource = tblCategory;
ddlCategoryProd.DataTextField = "CategoryName";
ddlCategoryProd.DataValueField = "CategoryId";
ddlCategoryProd.DataBind();
ddlCategoryProd.Items.Insert(0, new ListItem("Select a Category", "-1"));
txtSubtotal.Text = subTotal.ToString("C");
txtTax.Text = tax.ToString("C");
txtTotal.Text = total.ToString("C");
}
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));
}
}
}
