private void btnAdd_Click(object sender, EventArgs e) { try { int iValue = 0; if (ObjBArticle == null) { ObjBArticle = new BArticles(); } if (ObjEArticle == null) { ObjEArticle = new EArticles(); } ParseRabattDetails(); ObjEArticle = ObjBArticle.SaveRabatt(ObjEArticle); iValue = ObjEArticle.RabattID; BindRabattData(); Utility.Setfocus(gvRabatt, "RabattID", iValue); ObjEArticle.RabattID = -1; if (Utility._IsGermany == true) { frmOTTOPro.UpdateStatus("Vorgang abgeschlossen: Speichern der Rabattgruppe(n)"); } else { frmOTTOPro.UpdateStatus("Rabatt group Saved Successfully"); } } catch (Exception ex) { Utility.ShowError(ex); } }
private void frmRabattGroup_Load(object sender, EventArgs e) { try { if (Utility.ArticleDataAccess == "7") { btnAdd.Enabled = false; } if (ObjEArticle == null) { ObjEArticle = new EArticles(); } if (ObjBArticle == null) { ObjBArticle = new BArticles(); } ObjEArticle = ObjBArticle.GetRabatt(ObjEArticle); BindRabattData(); dateEditValidityDate.DateTime = DateTime.Now; dateEditValidityDate.Properties.MinValue = DateTime.Now; txtMulti1.Text = "1"; txtMulti2.Text = "1"; txtMulti3.Text = "1"; txtMulti4.Text = "1"; } catch (Exception ex) { Utility.ShowError(ex); } }
private void btnAddtype_Click(object sender, EventArgs e) { try { frmTypList Obj = new frmTypList(); Obj.ShowDialog(); if (Obj.IScontinue) { ObjEArticle = new EArticles(); DArticles ObjDArticles = new DArticles();; int ivalue = 0; if (int.TryParse(Convert.ToString(gvRabatt.GetFocusedRowCellValue("RabattID")), out ivalue)) { ObjEArticle.RabattID = ivalue; ObjEArticle.TypID = Obj.TypID; ObjEArticle = ObjDArticles.SaveTypRabattMapping(ObjEArticle); gcTyp.DataSource = ObjEArticle.dtTypID; gvTyp.Columns["RabattTypMapID"].Visible = false; Utility.Setfocus(gvTyp, "RabattTypMapID", ObjEArticle.RabattTypID); ObjEArticle.RabattTypID = -1; } } } catch (Exception ex) { Utility.ShowError(ex); } }
private void gvWGWA_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { try { if (_IsNew) { return; } int _IDValue = 0; if (gvWGWA.FocusedColumn != null && gvWGWA.GetFocusedRowCellValue("WGID") != null) { if (int.TryParse(gvWGWA.GetFocusedRowCellValue("WGID").ToString(), out _IDValue)) { if (ObjEArticle == null) { ObjEArticle = new EArticles(); } ObjEArticle.WGID = _IDValue; txtWG.Text = gvWGWA.GetFocusedRowCellValue("WG") == DBNull.Value ? "" : gvWGWA.GetFocusedRowCellValue("WG").ToString(); txtWA.Text = gvWGWA.GetFocusedRowCellValue("WA") == DBNull.Value ? "" : gvWGWA.GetFocusedRowCellValue("WA").ToString(); txtWGDescription.Text = gvWGWA.GetFocusedRowCellValue("WGDescription") == DBNull.Value ? "" : gvWGWA.GetFocusedRowCellValue("WGDescription").ToString(); txtWADescription.Text = gvWGWA.GetFocusedRowCellValue("WADescription") == DBNull.Value ? "" : gvWGWA.GetFocusedRowCellValue("WADescription").ToString(); BindWIData(_IDValue); gvWI_FocusedRowChanged(null, null); } } } catch (Exception ex) { Utility.ShowError(ex); } }
private void gvRabatt_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { try { int _IDValue = -1; if (gvRabatt.FocusedColumn != null && gvRabatt.GetFocusedRowCellValue("RabattID") != null) { if (int.TryParse(Convert.ToString(gvRabatt.GetFocusedRowCellValue("RabattID")), out _IDValue)) { if (ObjEArticle == null) { ObjEArticle = new EArticles(); } ObjEArticle.RID = _IDValue; string stRabatt = Convert.ToString(gvRabatt.GetFocusedRowCellValue("Rabatt")); lblTypName.Text = "Typs Associated with Rabbat : " + stRabatt; ObjEArticle = ObjBArticle.GetTypByRabatt(ObjEArticle); gcTyp.DataSource = ObjEArticle.dtTypID; gvTyp.Columns["RabattTypMapID"].Visible = false; gvTyp.BestFitColumns(); } } } catch (Exception ex) { Utility.ShowError(ex); } }
private void gvDimensions_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { if (gvDimensions.GetFocusedRowCellValue("DimensionID") != null) { if (ObjEArticle == null) { ObjEArticle = new EArticles(); } if (ObjDArticle == null) { ObjDArticle = new DArticles(); } int IValue = 0; decimal dMins = 0; decimal dListPrice = 0; if (int.TryParse(Convert.ToString(gvDimensions.GetFocusedRowCellValue("DimensionID")), out IValue)) { ObjEArticle.DimensionID = IValue; } if (decimal.TryParse(Convert.ToString(gvDimensions.GetFocusedRowCellValue("Minuten")), out dMins)) { ObjEArticle.Minuten = dMins; } if (decimal.TryParse(Convert.ToString(gvDimensions.GetFocusedRowCellValue("ListPrice")), out dListPrice)) { ObjEArticle.ListPrice = dListPrice; } ObjDArticle.UpdateDimension(ObjEArticle); gvWI_FocusedRowChanged(null, null); } } catch (Exception ex) { Utility.ShowError(ex); } }
private void frmArticlesData_Load(object sender, EventArgs e) { try { if (Utility.ArticleDataAccess == "7") { btnNew.Enabled = false; btnSave.Enabled = false; btnSaveAs.Enabled = false; btnCancel.Enabled = false; btnAddDimension.Enabled = false; chkIsNew.Enabled = false; } if (ObjEArticle == null) { ObjEArticle = new EArticles(); } if (ObjBArticle == null) { ObjBArticle = new BArticles(); } cmbME.SelectedIndex = cmbME.Properties.Items.IndexOf("h"); ObjBArticle.GetArticle(ObjEArticle); BindWGdata(); } catch (Exception ex) { Utility.ShowError(ex); } }
/// <summary> /// Code to add or edit rabatt from rabatt master /// </summary> /// <param name="xml"></param> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles SaveRabatt(EArticles ObjEArticle) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/Rabatt"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "RabattID", ObjEArticle.RabattID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Rabatt", ObjEArticle.Rabatt.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TypeID", ObjEArticle.TypID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi1", ObjEArticle.Multi1.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi2", ObjEArticle.Multi2.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi3", ObjEArticle.Multi3.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi4", ObjEArticle.Multi4.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ValidityDate", ObjEArticle.ValidityDate.ToString("yyyy-MM-dd")); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CreatedBy", ObjEArticle.CreatedBy.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LastUpdatedBy", ObjEArticle.LastUpdatedBy.ToString()); if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjEArticle = ObjDArticles.SaveRabatt(Xdoc, ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
private void btnSaveAs_Click(object sender, EventArgs e) { try { if (gvDimensions.RowCount == 0) { return; } if (_IsSaveDimension) { throw new Exception("Bitte speichern Sie die Maße"); } frmSaveDimension Obj = new frmSaveDimension("Dimension", ""); Obj.ObjEArticle = ObjEArticle; Obj.ObjBArticle = ObjBArticle; Obj.strArticle = "Info's zur Aktuellen Abmessung : " + txtWG.Text + "/" + txtWA.Text + "/" + txtWI.Text; Obj.ShowDialog(); ObjEArticle = Obj.ObjEArticle; ObjBArticle = Obj.ObjBArticle; BindDimensions(ObjEArticle.WIID); gvWI_FocusedRowChanged(null, null); } catch (Exception ex) { Utility.ShowError(ex); } }
private void gvArticles_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { try { if (gvArticles.FocusedRowHandle >= 0 && gvArticles.GetFocusedRowCellValue("WIID") != null) { if (Convert.ToString(gvArticles.GetFocusedRowCellValue("HasAccessories")) == "YES") { ObjEArticles = new EArticles(); int iv = 0; if (int.TryParse(Convert.ToString(gvArticles.GetFocusedRowCellValue("WIID")), out iv)) { ObjEArticles.ParentID = iv; ObjEArticles = ObjBArticles.GetAccessories(ObjEArticles); gcAccessories.DataSource = ObjEArticles.dtAccessories; } } else { gcAccessories.DataSource = null; } } } catch (Exception ex) { Utility.ShowError(ex); } }
private void btnAddAccessory_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { try { if (gvArticles.FocusedRowHandle >= 0 && gvArticles.GetFocusedRowCellValue("WIID") != null) { ObjEArticles = new EArticles(); frmAddAccessory Obj = new frmAddAccessory(ObjEArticles); Obj.ShowDialog(); if (ObjEArticles.IsContinue) { int iv = 0; if (int.TryParse(Convert.ToString(gvArticles.GetFocusedRowCellValue("WIID")), out iv)) { ObjEArticles.ParentID = iv; ObjEArticles.UserID = Utility.UserID; ObjBArticles.SaveArticleMapping(ObjEArticles); if (Convert.ToString(gvArticles.GetFocusedRowCellValue("HasAccessories")) == "NO") { gvArticles.SetRowCellValue(gvArticles.FocusedRowHandle, "HasAccessories", "YES"); } gcAccessories.DataSource = ObjEArticles.dtAccessories; Utility.Setfocus(gvAccessories, "AccessoriesID", ObjEArticles.AccessoriesID); } } } } catch (Exception ex) { Utility.ShowError(ex); } }
private void gvDeleteDimension_Click(object sender, EventArgs e) { try { if (gvDimensions.GetFocusedRowCellValue("DimensionID") != null) { int IValue = 0; if (int.TryParse(Convert.ToString(gvDimensions.GetFocusedRowCellValue("DimensionID")), out IValue)) { var dlgResult = XtraMessageBox.Show("Sind Sie sicher, dass Sie die ausgewählten Abmessungen löschen möchten?", "Frage", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (Convert.ToString(dlgResult) == "Yes") { if (ObjEArticle == null) { ObjEArticle = new EArticles(); } ObjEArticle.DimensionID = IValue; if (ObjDArticle == null) { ObjDArticle = new DArticles(); } ObjDArticle.DeleteDimension(ObjEArticle); gvDimensions.DeleteSelectedRows(); } } } } catch (Exception ex) { Utility.ShowError(ex); } }
/// <summary> /// Code to Add dimensions of article /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles SaveDimension(EArticles ObjEArticle) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/Dimension"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DimensionID", ObjEArticle.DimensionID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WIID", ObjEArticle.WIID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "A", ObjEArticle.A); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "B", ObjEArticle.B); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "L", ObjEArticle.L); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ListPrice", ObjEArticle.ListPrice.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "GMulti", ObjEArticle.GMulti.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Minuten", ObjEArticle.Minuten.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ValidityDate", ObjEArticle.ValidityDate.ToString("yyyy-MM-dd")); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CreatedBy", ObjEArticle.CreatedBy.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LastUpdatedBy", ObjEArticle.LastUpdatedBy.ToString()); if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjEArticle = ObjDArticles.SaveDimension(Xdoc, ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
public frmEditRabatt(EArticles _ObjEArticle, bool _IsCopy) { InitializeComponent(); this.AcceptButton = btnSave; this.CancelButton = btnCancel; ObjEArticle = _ObjEArticle; IsCopy = _IsCopy; }
private void frmTypList_Load(object sender, EventArgs e) { ObjEArticles = new EArticles(); ObjDArticles = new DArticles(); ObjEArticles = ObjDArticles.GetTypForRabatt(ObjEArticles); gcTyp.DataSource = ObjEArticles.dtTyp; gvTyp.Columns["TypID"].Visible = false; gvTyp.BestFitColumns(); }
/// <summary> /// Code to get list of accessories /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles GetAccessories(EArticles ObjEArticle) { try { ObjEArticle = ObjDArticles.GetAccessories(ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
/// <summary> /// Code to get mapped Typs based on Rabatt ID /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles GetTypByRabatt(EArticles ObjEArticle) { try { ObjEArticle = ObjDArticles.GetTypByRabatt(ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
/// <summary> /// Code to get Articles for accessories mapping /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles GetArticleForAccessories(EArticles ObjEArticle) { try { if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjDArticles.GetArticleForAccessories(ObjEArticle); } catch (Exception ex) { throw ex; } return(ObjEArticle); }
private void btnReset_Click(object sender, EventArgs e) { if (ObjEArticle == null) { ObjEArticle = new EArticles(); } ObjEArticle.RabattID = -1; txtRabatt.Text = string.Empty; txtMulti1.Text = "1"; txtMulti2.Text = "1"; txtMulti3.Text = "1"; txtMulti4.Text = "1"; }
/// <summary> /// Code to delete accessory mapping /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles DeleteAccessory(EArticles ObjEArticle) { try { if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjDArticles.DeleteAccessory(ObjEArticle); } catch (Exception ex) { throw ex; } return(ObjEArticle); }
/// <summary> /// Code to Save new set of Dimesions with new validity date from Article master /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles SaveDimensionCopy(EArticles ObjEArticle) { try { if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjEArticle = ObjDArticles.SaveDimensionCopy(ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
/// <summary> /// Code to import article data i.e. data migration /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles ImportArticleData(EArticles ObjEArticle) { try { if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjEArticle = ObjDArticles.ImportArticleData(ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
/// <summary> /// Code to save Article mapping with accesories /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles SaveArticleMapping(EArticles ObjEArticle) { try { if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjEArticle = ObjDArticles.SaveArticleMapping(ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
/// <summary> /// Code to getch article data from base i.e. Article data, dimensiions, typ and Rabatt mappings /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles GetArticle(EArticles ObjEArticle) { try { if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjEArticle = ObjDArticles.GetArticle(ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
private void frmArticleAccessories_Load(object sender, EventArgs e) { try { if (ObjBArticles == null) { ObjBArticles = new BArticles(); } if (ObjEArticles == null) { ObjEArticles = new EArticles(); } ObjBArticles.GetArticleForAccessories(ObjEArticles); gcArticles.DataSource = ObjEArticles.dtArt; } catch (Exception ex) { Utility.ShowError(ex); } }
private void btnAddDimension_Click(object sender, EventArgs e) { try { if (ObjEArticle.WIID < 0) { if (!Utility._IsGermany) { throw new Exception("Please Select The Article"); } else { throw new Exception("Bitte wählen Sie einen Artikel"); } } decimal GMulti = 1; ObjEArticle = new EArticles(); ObjEArticle.DimensionID = -1; ObjEArticle.WIID = _WIIDValue; ObjEArticle.GMulti = GMulti; frmAddDimension frm = new frmAddDimension(); frm.ObjEArticle = ObjEArticle; frm.ShowDialog(); if (frm.DialogResult == DialogResult.OK) { BindDimensions(ObjEArticle.WIID); Setfocus(gvDimensions, "DimensionID", ObjEArticle.DimensionID); if (Utility._IsGermany == true) { frmOTTOPro.UpdateStatus("Vorgang abgeschlossen: Speichern der (neuen) Abmessungen"); } else { frmOTTOPro.UpdateStatus("Dimension saved successfully"); } } } catch (Exception ex) { Utility.ShowError(ex); } finally { ObjBArticle.GetArticle(ObjEArticle); } }
/// <summary> /// Code to fetch Rabatt and typ list form database and bind to grid controls /// </summary> private void BindRabattData() { try { if (ObjEArticle == null) { ObjEArticle = new EArticles(); } gcRabatt.DataSource = ObjEArticle.dtRabatt; gvRabatt.Columns["RabattID"].Visible = false; gvRabatt.BestFitColumns(); } catch (Exception ex) { throw; } }
private void frmType_Load(object sender, EventArgs e) { try { if (Utility.ArticleDataAccess == "7") { btnSave.Enabled = false; } if (ObjEArticle == null) { ObjEArticle = new EArticles(); } if (ObjBArticle == null) { ObjBArticle = new BArticles(); } ObjEArticle = ObjBArticle.GetTyp(ObjEArticle); ObjEArticle.dtWG.TableName = "WG"; cmbWGWA.Properties.DataSource = ObjEArticle.dtWG; cmbWGWA.Properties.ValueMember = "WGID"; cmbWGWA.Properties.DisplayMember = "WGWADesc"; cmbWI.Properties.DataSource = ObjEArticle.dtWI; cmbWI.Properties.ValueMember = "WIID"; cmbWI.Properties.DisplayMember = "WI"; cmbWI.CascadingOwner = cmbWGWA; cmbSupplier.Properties.DataSource = ObjEArticle.dtSupplier; cmbSupplier.Properties.ValueMember = "SupplierID"; cmbSupplier.Properties.DisplayMember = "FullName"; ReqFields.Add(txtTyp); ReqFields.Add(cmbWGWA); ReqFields.Add(cmbWI); ReqFields.Add(cmbSupplier); BindTypeData(); } catch (Exception ex) { Utility.ShowError(ex); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (ObjBArticle == null) { ObjBArticle = new BArticles(); } ObjEArticle.ValidityDate = dateEditGultigkeit.DateTime; ObjEArticle.dtDim = ((DataView)gvDimensions.DataSource).ToTable(); ObjEArticle = ObjBArticle.SaveDimensionCopy(ObjEArticle); MessageBox.Show("Maße / Artikeldaten mit neuem Gültigkeitsdatum wurden gespeichert : " + string.Format("{0:y}", dateEditGultigkeit.DateTime)); this.Close(); } catch (Exception ex) { Utility.ShowError(ex); } }
/// <summary> /// It contains code to parse the article values while adding new or editing an existing article. /// </summary> private void ParsearticleDetails() { if (ObjEArticle == null) { ObjEArticle = new EArticles(); } if (!string.IsNullOrEmpty(txtWG.Text.Trim()) && txtWG.Text != "0") { ObjEArticle.WG = txtWG.Text; } else { if (!Utility._IsGermany) { throw new Exception("Please Enter Valid WG Value"); } else { throw new Exception("Bitte geben Sie einen zulässigen Wert an für WG"); } } if (!string.IsNullOrEmpty(txtWA.Text.Trim())) { ObjEArticle.WA = txtWA.Text; } else { ObjEArticle.WA = "0"; } ObjEArticle.WI = txtWI.Text.Trim(); ObjEArticle.WGDescription = txtWGDescription.Text; ObjEArticle.WADescription = txtWADescription.Text; ObjEArticle.WIDescription = txtWIDescription.Text; ObjEArticle.Fabrikate = txtFabrikat.Text; ObjEArticle.Dimension = txtDimension.Text; ObjEArticle.Menegenheit = cmbME.Text; ObjEArticle.Masseinheit = txtMasseinheit.Text; ObjEArticle.TextKZ = txtTextKZ.Text; ObjEArticle.Remarks = txtremark.Text; ObjEArticle.DataNormNumber = txtDatanormNr.Text; }