private void CboCategory_SelectionChangeCommitted(object sender, EventArgs e)
{
AlmacenDisecWS.category c = (AlmacenDisecWS.category)cboCategory.SelectedItem;
cboFamily.DataSource = serviceDA.queryAllFamily(c.category_id);
cboFamily.DisplayMember = "name_family";
cboFamily.ValueMember = "id_family";
}
private void BtnDataG_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtName.Text) || String.IsNullOrEmpty(txtPrice.Text) || cboBrand.SelectedIndex == -1 ||
cboCategory.SelectedIndex == -1 || cboFamily.SelectedIndex == -1 || cboSupplier.SelectedIndex == -1 ||
cboMoney.SelectedIndex == -1)
{
frmMessageBoxFillNull frm = new frmMessageBoxFillNull();
frm.ShowDialog();
}
else
{
if (flag == 1)
{
/*
* btnDataG.Enabled = true;
* txtName.Enabled = false;
* txtPrice.Enabled = false;
*
* cboCategory.Enabled = false;
* cboFamily.Enabled = false;
* cboBrand.Enabled = false;
*
* cboSupplier.Enabled = false;
* cboMoney.Enabled = false;
*/
AlmacenDisecWS.category c = (AlmacenDisecWS.category)cboCategory.SelectedValue;
AlmacenDisecWS.family f = (AlmacenDisecWS.family)cboFamily.SelectedValue;
AlmacenDisecWS.brand b = (AlmacenDisecWS.brand)cboBrand.SelectedValue;
AlmacenDisecWS.supplier sup = (AlmacenDisecWS.supplier)cboSupplier.SelectedValue;
AlmacenDisecWS.storehouse store = (AlmacenDisecWS.storehouse)cboStorehouse.SelectedValue;
string name = txtName.Text;
double price = double.Parse(txtPrice.Text);
AlmacenDisecWS.tool t = new AlmacenDisecWS.tool();
t.brand.brand_id = b.brand_id;
t.name_item = name;
t.price = price;
t.family.id_family = f.id_family;
t.suppliers.id_supplier = sup.id_supplier;
t.stock.storehouse.id_storehouse = store.id_storehouse;
int a = 0;
if (cboMoney.Text == "SOLES")
{
a = 1;
}
else
{
a = 2;
}
string waytopay = cboWayofPay.Text;
int result = serviceDA.insertTool(t, a, waytopay);
}
else
{
frmMessageBoxNew frm = new frmMessageBoxNew();
frm.ShowDialog();
}
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtName.Text))
{
frmMessageBoxFillNull frm = new frmMessageBoxFillNull();
frm.ShowDialog();
}
else
{
if (flag == true)
{
frmMessageBoxSave frm = new frmMessageBoxSave();
if (frm.ShowDialog() == DialogResult.OK)
{
String name = txtName.Text;
AlmacenDisecWS.category c = new AlmacenDisecWS.category();
c.category_name = name;
serviceDA.insertCategory(c);
dgvSearch.AutoGenerateColumns = false;
dgvSearch.DataSource = serviceDA.queryAllCategory();
reiniciar();
btnModify.Enabled = true;
operation = true;
}
}
else
{
if (String.IsNullOrEmpty(txtId.Text))
{
frmMessageBoxFillNull frm2 = new frmMessageBoxFillNull();
frm2.ShowDialog();
}
else
{
frmMessageBoxSave frm = new frmMessageBoxSave();
if (frm.ShowDialog() == DialogResult.OK)
{
int id = Int32.Parse(txtId.Text);
String name = txtName.Text;
AlmacenDisecWS.category c = new AlmacenDisecWS.category();
c.category_name = name;
c.category_id = id;
serviceDA.updateCategory(c);
dgvSearch.AutoGenerateColumns = false;
dgvSearch.DataSource = serviceDA.queryAllCategory();
reiniciar();
operation = true;
btnModify.Enabled = true;
}
}
}
}
}
private void btnSearch_Click_1(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(cmbSearch.Text))
{
//Insertar el codigo de busqueda
frmMessageBoxFillNull frm = new frmMessageBoxFillNull();
frm.ShowDialog();
}
else
{
String nameC = cmbSearch.Text;
dgvSearch.AutoGenerateColumns = false;
AlmacenDisecWS.category c = serviceDA.queryAllCategoryByName(nameC);
dgvSearch.DataSource = serviceDA.queryAllFamily(c.category_id);
btnModify.Enabled = true;
operation = true;
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtId.Text) || String.IsNullOrEmpty(cboCategory.Text))
{
frmMessageBoxFillNull frm = new frmMessageBoxFillNull();
frm.ShowDialog();
}
else
{
frmMessageBoxDelete frm = new frmMessageBoxDelete();
if (frm.ShowDialog() == DialogResult.OK)
{
int id = Int32.Parse(txtId.Text);
String name = txtName.Text;
int result = serviceDA.deleteFamily(id);
dgvSearch.AutoGenerateColumns = false;
AlmacenDisecWS.category c = (AlmacenDisecWS.category)cboCategory.SelectedItem;
dgvSearch.DataSource = serviceDA.queryAllFamily(c.category_id);
reiniciar();
btnModify.Enabled = true;
}
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
{
if (String.IsNullOrEmpty(txtName.Text) || String.IsNullOrEmpty(txtMinQuantity.Text) || String.IsNullOrEmpty(txtSerie.Text) ||
String.IsNullOrEmpty(txtPrice.Text) || cboBrand.SelectedIndex == -1 || cboCategory.SelectedIndex == -1 ||
cboFamily.SelectedIndex == -1 || cboUnit.SelectedIndex == -1 || cboStatus.SelectedIndex == -1 ||
cboSupplier.SelectedIndex == -1 || cboMoney.SelectedIndex == -1)
{
frmMessageBoxFillNull frm = new frmMessageBoxFillNull();
frm.ShowDialog();
}
else
{
if (flag == 2)
{
if (String.IsNullOrEmpty(txtCode.Text))
{
frmMessageBoxSave frm = new frmMessageBoxSave();
if (frm.ShowDialog() == DialogResult.OK)
{
String name = txtName.Text;
//Category cat = new category(name,1);
//Se llama al insert
frmMessageBoxAdd frm2 = new frmMessageBoxAdd();
if (frm2.ShowDialog() == DialogResult.OK)
{
int id_c = 0;
AlmacenDisecWS.materialDetail detail = new AlmacenDisecWS.materialDetail();
AlmacenDisecWS.material m = new AlmacenDisecWS.material();
AlmacenDisecWS.category c = new AlmacenDisecWS.category();
detail.measure = (AlmacenDisecWS.measureUnit)cboUnit.SelectedItem;
detail.serie_material = txtSerie.Text;
m.min_quantity = Int32.Parse(txtMinQuantity.Text);
m.brand = (AlmacenDisecWS.brand)cboUnit.SelectedItem;
m.family = (AlmacenDisecWS.family)cboFamily.SelectedItem;
c = (AlmacenDisecWS.category)cboCategory.SelectedItem;
/// m.supplier = (AlmacenDisecWS.supplier)cbosupplier.SelectedItem
m.price = Double.Parse(txtPrice.Text);
m.name_item = txtName.Text;
// m.material_details. = detail;
if (cboMoney.SelectedItem.ToString() == "SOLES")
{
id_c = 1;
}
else
{
if (cboMoney.SelectedItem.ToString() == "DOLARES")
{
id_c = 2;
}
}
m.family.category.category_id = c.category_id;
m.family.category.category_name = c.category_name;
// int result = serviceDA.insertMaterial(m,id_c) ;
txtCode.Clear();
txtSerie.Clear();
cboStatus.SelectedIndex = -1;
}
else
{
reiniciar();
}
}
}
}
else
{
if (flag == 0)
{
if (String.IsNullOrEmpty(txtCode.Text))
{
frmMessageBoxNew frm2 = new frmMessageBoxNew();
frm2.ShowDialog();
}
else
{
frmMessageBoxSave frm = new frmMessageBoxSave();
if (frm.ShowDialog() == DialogResult.OK)
{
// int id = Int32.Parse(txtId.Text);
String name = txtName.Text;
// Category cat = (Category)cboCategory.SelectedIndex;
//Category cat = new category(name,0);
//Se llama al update
reiniciar();
}
}
}
else
{
if (flag == 1)
{
frmMessageBoxDataGeneral frm2 = new frmMessageBoxDataGeneral();
frm2.ShowDialog();
}
}
}
}
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtName.Text))
{
frmMessageBoxFillNull frm = new frmMessageBoxFillNull();
frm.ShowDialog();
}
else
{
if (flag == true)
{
if ((cboCategory.SelectedIndex == -1) || (cboType.SelectedIndex == -1))
{
frmMessageBoxCategory frm = new frmMessageBoxCategory();
frm.ShowDialog();
}
else
{
frmMessageBoxSave frm = new frmMessageBoxSave();
if (frm.ShowDialog() == DialogResult.OK)
{
String name = txtName.Text;
AlmacenDisecWS.category c = (AlmacenDisecWS.category)cboCategory.SelectedItem;
AlmacenDisecWS.family f = new AlmacenDisecWS.family();
f.name_family = name;
f.category = c;
btnModify.Enabled = true;
operation = true;
dgvSearch.AutoGenerateColumns = false;
int a = 0;
string a1 = cboType.SelectedItem.ToString();
if (cboType.SelectedItem.ToString() == "MATERIAL")
{
a = 1;
}
else if (cboType.SelectedItem.ToString() == "HERRAMIENTA")
{
a = 2;
}
int result = serviceDA.insertFamily(f, a);
dgvSearch.DataSource = serviceDA.queryAllFamily(c.category_id);
cmbSearch.Text = cboCategory.Text;
reiniciar();
}
}
}
else
{
if (String.IsNullOrEmpty(txtId.Text) || String.IsNullOrEmpty(cboCategory.Text))
{
frmMessageBoxFillNull frm2 = new frmMessageBoxFillNull();
frm2.ShowDialog();
}
else
{
frmMessageBoxSave frm = new frmMessageBoxSave();
if (frm.ShowDialog() == DialogResult.OK)
{
int id = Int32.Parse(txtId.Text);
String name = txtName.Text;
AlmacenDisecWS.category c = (AlmacenDisecWS.category)cboCategory.SelectedItem;
AlmacenDisecWS.family f = new AlmacenDisecWS.family();
f.id_family = id;
f.name_family = name;
f.category = c;
int result = serviceDA.updateFamily(f);
dgvSearch.AutoGenerateColumns = false;
dgvSearch.DataSource = serviceDA.queryAllFamily(c.category_id);
cmbSearch.Text = cboCategory.Text;
reiniciar();
operation = true;
btnModify.Enabled = true;
}
}
}
}
}
