/// <summary> /// Code to save customer address details /// </summary> /// <param name="XmlDoc"></param> /// <returns></returns> public int SaveCustomerAddressDetails(ECustomer ObjECustomer) { try { int AddressID = -1; XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/CustomerAddress"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CustomerID", Convert.ToString(ObjECustomer.Customer_CustomerID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "AddressID", Convert.ToString(ObjECustomer.AddressID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "AddressShortName", ObjECustomer.AddressShortName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "StreetNo", ObjECustomer.StreetNo); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PostalCode", ObjECustomer.AddrPostalCode); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "City", ObjECustomer.AddrCity); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Country", ObjECustomer.AddrCountry); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DefaultAddress", Convert.ToString(ObjECustomer.DefaultAddress)); AddressID = ObjDCustomer.SaveCustomerAddressDetails(Xdoc); if (AddressID < 0) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Speichern der Kundenaddresse"); } else { throw new Exception("Failed to Save Customer Address"); } } return(AddressID); } catch (Exception ex) { throw; } }
/// <summary> /// Code to save Text areas which are used in Title blatt template design /// </summary> /// <param name="ObjEProposal"></param> /// <returns></returns> public int SaveTextModule(EProposal ObjEProposal) { try { int TextID = -1; XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/TextModule"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TextID", ObjEProposal.TextID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TextModuleArea", ObjEProposal.TextModuleArea); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Category", ObjEProposal.Category); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Contents", ObjEProposal.Contents); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "IsSelect", ObjEProposal.IsSelect.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TextAreaID", ObjEProposal.TextAreaID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CategoryID", ObjEProposal.TextCategoryID.ToString()); TextID = ObjDProposal.SaveTextModuleDetails(Xdoc); if (TextID < 0) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { // throw new Exception("Fehler beim Speichern der LV Angaben"); } else { throw new Exception("Failed to Save Text Module"); } } return(TextID); } catch (Exception ex) { throw; } }
/// <summary> /// Code to save Text Modules Category /// </summary> /// <param name="ObjEProposal"></param> /// <param name="_textID"></param> /// <returns></returns> public int SaveCategory(EProposal ObjEProposal, int _textID) { try { int CategoryID = -1; XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/Category"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CategoryID", ObjEProposal.CategoryID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CategoryName", ObjEProposal.CategoryName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TextAreaID", _textID.ToString()); CategoryID = ObjDProposal.SaveCategory(Xdoc); if (CategoryID < 0) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { // throw new Exception("Fehler beim Speichern der Kundeninformation"); } else { throw new Exception("Failed to Save Category"); } } return(CategoryID); } catch (Exception ex) { throw; } }
/// <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); }
/// <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); }
/// <summary> /// Code to save customer details from customer master /// </summary> /// <param name="ObjECustomer"></param> /// <returns></returns> public int SaveCustomerDetails(ECustomer ObjECustomer) { try { int CustomerID = -1; XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/Customer"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CustomerID", ObjECustomer.Customer_CustomerID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CustomerFullName", ObjECustomer.CustomerFullName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CustomerShortName", ObjECustomer.CustomerShortName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Street", ObjECustomer.CustStreet); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PostalCode", ObjECustomer.CustPostalCode); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "City", ObjECustomer.CustCity); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Country", ObjECustomer.CustCountry); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ILN", ObjECustomer.ILN); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Telephone", ObjECustomer.Telephone); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Fax", ObjECustomer.CustFax); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EmailID", ObjECustomer.CustEmailID); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TaxNumber", ObjECustomer.CustTaxNumber); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BankName", ObjECustomer.BankName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BankPostalCode", ObjECustomer.BankPostalCode); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BankAccountNumber", ObjECustomer.BankAccountNumber); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DVNr", ObjECustomer.DVNr); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TenderNumber", ObjECustomer.TenderNumber); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DebitorNumber", ObjECustomer.DebitorNumber); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CountryType", ObjECustomer.CountryType); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CountryName", ObjECustomer.CountryName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Commentary", ObjECustomer.Commentary); CustomerID = ObjDCustomer.SaveCustomerDetails(Xdoc); if (CustomerID < 0) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { // throw new Exception("Fehler beim Speichern der LV Angaben"); } else { throw new Exception("Failed to Save Customer"); } } return(CustomerID); } catch (Exception ex) { throw; } }
public int SavePositionDetails(EPosition ObjEPosition) { try { int PositionID = -1; XmlDocument Xdoc = new XmlDocument(); PrepareOZ(ObjEPosition); string XPath = "/Nouns/Position"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PositionID", ObjEPosition.PositionID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ProjectID", ObjEPosition.ProjectID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PositionOZ", ObjEPosition.Position_OZ); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ParentOZ", ObjEPosition.Parent_OZ.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Title", ObjEPosition.Title); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ShortDescription", ObjEPosition.ShortDescription); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PositionKZ", ObjEPosition.PositionKZ); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DetailKZ", ObjEPosition.DetailKZ.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LVSection", ObjEPosition.LVSection); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WG", ObjEPosition.WG.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WA", ObjEPosition.WA.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WI", ObjEPosition.WI.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Menge", ObjEPosition.Menge.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ME", ObjEPosition.ME.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Fabricate", ObjEPosition.Fabricate); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Type", ObjEPosition.Type); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LVStatus", ObjEPosition.LVStatus); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ProposalNo", ObjEPosition.ProposalNo.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SurchargeFrom", string.IsNullOrEmpty(ObjEPosition.Surcharge_From) ? "" : ObjEPosition.Surcharge_From); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SurchargeTO", string.IsNullOrEmpty(ObjEPosition.Surcharge_To)? "" : ObjEPosition.Surcharge_To); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SurchargePer", Convert.ToString(ObjEPosition.Surcharge_Per)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "surchargePercentageMO", Convert.ToString(ObjEPosition.surchargePercentage_MO)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "UserID", ObjEPosition.UserID.ToString()); PositionID = ObjDPosition.SavePositionDetails(Xdoc, ObjEPosition.LongDescription); if (PositionID < 0) { throw new Exception("Failed to Save LV Details"); } //else // ObjEPosition.PositionID = PositionID; return(PositionID); } catch (Exception ex) { throw; } }
/// <summary> /// Code to save Organzition contacts /// </summary> /// <param name="ObjEOTTO"></param> /// <returns></returns> public EOTTO SaveOTTOContactDetails(EOTTO ObjEOTTO) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/OTTOContact"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "OttoID", ObjEOTTO.OTTOID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ContactID", ObjEOTTO.ContactID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ContactPerson", ObjEOTTO.ContactPerson); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Telephone", ObjEOTTO.Cont_Telephone); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Fax", ObjEOTTO.Fax); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EmailID", ObjEOTTO.EmailID); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TaxNo", ObjEOTTO.TaxNo); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DefaultContact", ObjEOTTO.DefaultContact.ToString()); ObjEOTTO = ObjDOTTO.SaveOTTOContactDetails(Xdoc, ObjEOTTO); } catch (Exception ex) { throw; } return(ObjEOTTO); }
/// <summary> /// Code to get save Organization details /// </summary> /// <param name="ObjEOTTO"></param> /// <returns></returns> public EOTTO SaveOTTODetails(EOTTO ObjEOTTO) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/OTTO"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "OttoID", ObjEOTTO.OTTOID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ShortName", ObjEOTTO.ShortName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "FullName", ObjEOTTO.FullName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "IsBranch", ObjEOTTO.IsBranch.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Street", ObjEOTTO.Street); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PostalCode", ObjEOTTO.PostalCode); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "City", ObjEOTTO.City); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Country", ObjEOTTO.Country); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ILN", ObjEOTTO.ILN); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BankName", ObjEOTTO.BankName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BankPostalCode", ObjEOTTO.BankPostalCode); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BankAccNo", ObjEOTTO.BankAccNo); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DVNr", ObjEOTTO.DVNr); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TenderNo", ObjEOTTO.TenderNo); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DebtorNo", ObjEOTTO.DebtorNo); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CountryType", ObjEOTTO.CountryType); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Industry", ObjEOTTO.Industry); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ArtBevBew", ObjEOTTO.ArtBevBew); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ArtNU", ObjEOTTO.ArtNU); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BGBez", ObjEOTTO.BGBez); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BGDatum", ObjEOTTO.BGDatum); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BGNr", ObjEOTTO.BGNr); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Telefon", ObjEOTTO.Telefon); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Telefax", ObjEOTTO.Telefax); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Website", ObjEOTTO.Website); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "HotLine", ObjEOTTO.HotLine); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "IBAN", ObjEOTTO.IBAN); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "BIC", ObjEOTTO.BIC); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "USTIDNr", ObjEOTTO.USTIDNr); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SeatofCompany", ObjEOTTO.SeatofCompany); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ManagingDirector", ObjEOTTO.ManagingDirector); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Complementary", ObjEOTTO.Complementary); ObjEOTTO = ObjDOTTO.SaveOTTODetails(Xdoc, ObjEOTTO); } catch (Exception ex) { throw; } return(ObjEOTTO); }
/// <summary> /// Code to Add or Edit supplier contact details from Supplier master to database /// </summary> /// <param name="ObjEsupplier"></param> /// <returns></returns> public ESupplier SaveSupplierContactDetails(ESupplier ObjEsupplier) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/SupplierContact"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SupplierID", Convert.ToString(ObjEsupplier.SupplierID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ContactPersonID", Convert.ToString(ObjEsupplier.ContactPersonID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ContactName", ObjEsupplier.ContactName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Salutation", ObjEsupplier.Salutation); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Designation", ObjEsupplier.Designation); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EmailID", ObjEsupplier.ContEmailID); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Telephone", ObjEsupplier.ContTelephone); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "FAX", ObjEsupplier.ContFax); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DefaultContact", Convert.ToString(ObjEsupplier.DefaultContact)); ObjEsupplier = ObjDSupplier.SavedsSupplierContactDetails(Xdoc, ObjEsupplier); return(ObjEsupplier); } catch (Exception ex) { throw; } }
/// <summary> /// Code to add or edit an article from article master /// </summary> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles SaveArticle(EArticles ObjEArticle) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/Article"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WGID", ObjEArticle.WGID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WG", ObjEArticle.WG); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WA", ObjEArticle.WA); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WGDescription", ObjEArticle.WGDescription); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WADescription", ObjEArticle.WADescription); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WIID", ObjEArticle.WIID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WI", ObjEArticle.WI); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WIDescription", ObjEArticle.WIDescription); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Fabrikate", ObjEArticle.Fabrikate); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Typ", ObjEArticle.Typ); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Masseinheit", ObjEArticle.Masseinheit); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Dimension", ObjEArticle.Dimension); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Menegenheit", ObjEArticle.Menegenheit); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Remarks", ObjEArticle.Remarks); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TextKZ", ObjEArticle.TextKZ); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ValidityDate", ObjEArticle.ValidityDate.ToString("yyyy-MM-dd")); 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, "DataNormNumber", Convert.ToString(ObjEArticle.DataNormNumber)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CreatedBy", Convert.ToString(ObjEArticle.CreatedBy)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LastUpdatedBy", Convert.ToString(ObjEArticle.LastUpdatedBy)); if (ObjDArticles == null) { ObjDArticles = new DArticles(); } ObjEArticle = ObjDArticles.SaveArticle(Xdoc, ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
/// <summary> /// Code to Add or Edit Supplier address details from Supplier master to database /// </summary> /// <param name="ObjEsupplier"></param> /// <returns></returns> public ESupplier SaveSupplierAddressDetails(ESupplier ObjEsupplier) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/SupplierAddress"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SupplierID", Convert.ToString(ObjEsupplier.SupplierID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "AddressID", Convert.ToString(ObjEsupplier.AddressID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ShortName", ObjEsupplier.AddressShortName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "StreetNo", ObjEsupplier.StreetNo); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PostalCode", ObjEsupplier.AddrPostalCode); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "City", ObjEsupplier.AddrCity); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Country", ObjEsupplier.AddrCountry); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DefaultAddress", Convert.ToString(ObjEsupplier.DefaultAddress)); ObjEsupplier = ObjDSupplier.SaveSupplierAddressDetails(Xdoc, ObjEsupplier); return(ObjEsupplier); } catch (Exception ex) { throw; } }
/// <summary> /// Code to customer contact details /// </summary> /// <param name="ObjECustomer"></param> /// <returns></returns> public int SaveCustomerContactDetails(ECustomer ObjECustomer) { try { int ContactPersonID = -1; XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/CustomerContact"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "CustomerID", Convert.ToString(ObjECustomer.Customer_CustomerID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ContactPersonID", Convert.ToString(ObjECustomer.ContactPersonID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Salutation", ObjECustomer.Salutation); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ContatPersonName", ObjECustomer.ContatPersonName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Designation", ObjECustomer.Designation); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EmailID", ObjECustomer.ContEmailID); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Telephone", ObjECustomer.ContTelephone); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "FAX", ObjECustomer.ContFax); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DefaultContact", Convert.ToString(ObjECustomer.DefaultContact)); ContactPersonID = ObjDCustomer.SaveCustomerContactDetails(Xdoc); if (ContactPersonID < 0) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Speichern der Kundeninformation"); } else { throw new Exception("Failed to Save Customer Contact"); } } return(ContactPersonID); } catch (Exception ex) { throw; } }
/// <summary> /// Code to send request to DL to add and edit user details /// </summary> /// <param name="ObjEUserInfo"></param> /// <returns></returns> public int SaveUserDetails(EUserInfo ObjEUserInfo) { try { int UserID = -1; XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/UserInfo"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "UserID", ObjEUserInfo.UserID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "RoleID", ObjEUserInfo.RoleID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "UserName", ObjEUserInfo.UserName.ToLower()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "FirstName", ObjEUserInfo.FirstName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LastName", ObjEUserInfo.LastName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Password", ObjEUserInfo.Password); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "MobileNo", ObjEUserInfo.MobileNo); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EmailID", ObjEUserInfo.EmailID); UserID = ObjDUserInfo.SaveUserDetails(Xdoc, ObjEUserInfo); return(UserID); } catch (Exception ex) { throw; } }
/// <summary> /// Code to add or edit supplier details from supplier master to database /// </summary> /// <param name="ObjEsupplier"></param> /// <returns></returns> public ESupplier SaveSupplierDetails(ESupplier ObjEsupplier) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/Supplier"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SupplierID", ObjEsupplier.SupplierID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "FullName", ObjEsupplier.SupplierFullName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ShortName", ObjEsupplier.SupplierShortName); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PaymentCondition", ObjEsupplier.PaymentCondition); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Commentary", ObjEsupplier.Commentary); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EmailID", ObjEsupplier.SupplierEmailID); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Street", ObjEsupplier.SupplierStreet); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Telephone", ObjEsupplier.SupplierTelephone); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Fax", ObjEsupplier.SupplierFax); ObjEsupplier = ObjDSupplier.SaveSupplierDetails(Xdoc, ObjEsupplier); return(ObjEsupplier); } catch (Exception ex) { throw; } }
/// <summary> /// Code to add ot edit typ from Typ master /// </summary> /// <param name="xml"></param> /// <param name="ObjEArticle"></param> /// <returns></returns> public EArticles SaveTyp(EArticles ObjEArticle) { try { XmlDocument Xdoc = new XmlDocument(); string XPath = "/Nouns/Typ"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "TypID", ObjEArticle.TypID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SupplierID", ObjEArticle.SupplierID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WIID", ObjEArticle.WIID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Typ", ObjEArticle.Typ); 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.SaveTyp(Xdoc, ObjEArticle); } catch (Exception ex) { throw; } return(ObjEArticle); }
/// <summary> /// Code to Add or edit Positions /// Prepare XML object with given values /// prepare Position OZ and ParentOZ into Project raster format /// </summary> /// <param name="ObjEPosition"></param> /// <param name="strRaster"></param> /// <param name="LVSprunge"></param> /// <param name="_IsCopy"></param> /// <returns></returns> public EPosition SavePositionDetails(EPosition ObjEPosition, string strRaster, int LVSprunge, bool _IsCopy = false) { try { CultureInfo CInfo = new CultureInfo("en-US"); XmlDocument Xdoc = new XmlDocument(); if (!_IsCopy) { PrepareOZ(ObjEPosition, strRaster); } string XPath = "/Nouns/Position"; Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PositionID", Convert.ToString(ObjEPosition.PositionID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ProjectID", Convert.ToString(ObjEPosition.ProjectID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PositionOZ", PrepareOZ(ObjEPosition.Position_OZ, strRaster)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ParentOZ", PrepareOZ(ObjEPosition.Parent_OZ, strRaster)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Title", ObjEPosition.Title); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ShortDescription", ObjEPosition.ShortDescription); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PositionKZ", ObjEPosition.PositionKZ); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DetailKZ", ObjEPosition.DetailKZ.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LVSection", ObjEPosition.LVSection); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WG", ObjEPosition.WG.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WA", ObjEPosition.WA.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "WI", ObjEPosition.WI.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Menge", ObjEPosition.Menge.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ME", ObjEPosition.ME.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Fabricate", ObjEPosition.Fabricate); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LiefrantMA", ObjEPosition.LiefrantMA); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Type", ObjEPosition.Type); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LVStatus", ObjEPosition.LVStatus); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ProposalNo", ObjEPosition.ProposalNo.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SurchargeFrom", PrepareOZ(ObjEPosition.Surcharge_From, strRaster)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SurchargeTO", PrepareOZ(ObjEPosition.Surcharge_To, strRaster)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SurchargePer", ObjEPosition.Surcharge_Per.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "surchargePercentageMO", ObjEPosition.surchargePercentage_MO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "UserID", ObjEPosition.UserID.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "ValidityDate", ObjEPosition.ValidityDate.ToString("yyyy-MM-dd")); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "KalkMenge", ObjEPosition.KalkMenge.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "MECost", ObjEPosition.MECost.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "MA", ObjEPosition.MA.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "MO", ObjEPosition.MO.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Dim1", ObjEPosition.Dim1); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Dim2", ObjEPosition.Dim2); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Dim3", ObjEPosition.Dim3); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Dim", ObjEPosition.Dim); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Mins", ObjEPosition.Mins.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Faktor", ObjEPosition.Faktor.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LPMA", ObjEPosition.LPMA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LPMO", ObjEPosition.LPMO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi1MA", ObjEPosition.Multi1MA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi1MO", ObjEPosition.Multi1MO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi2MA", ObjEPosition.Multi2MA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi2MO", ObjEPosition.Multi2MO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi3MA", ObjEPosition.Multi3MA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi3MO", ObjEPosition.Multi3MO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi4MA", ObjEPosition.Multi4MA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi4MO", ObjEPosition.Multi4MO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi5MA", ObjEPosition.Multi5MA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Multi5MO", ObjEPosition.Multi5MO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EinkaufspreisMA", ObjEPosition.EinkaufspreisMA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EinkaufspreisMO", ObjEPosition.EinkaufspreisMO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SelbstkostenMultiMA", ObjEPosition.SelbstkostenMultiMA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SelbstkostenMultiMO", ObjEPosition.SelbstkostenMultiMO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SelbstkostenValueMA", ObjEPosition.SelbstkostenValueMA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SelbstkostenValueMO", ObjEPosition.SelbstkostenValueMO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "VerkaufspreisMultiMA", ObjEPosition.VerkaufspreisMultiMA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "VerkaufspreisMultiMO", ObjEPosition.VerkaufspreisMultiMO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "VerkaufspreisValueMA", ObjEPosition.VerkaufspreisValueMA.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "VerkaufspreisValueMO", ObjEPosition.VerkaufspreisValueMO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "StdSatz", ObjEPosition.StdSatz.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PreisText", ObjEPosition.PreisText); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EinkaufspreisLockMA", ObjEPosition.EinkaufspreisLockMA.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EinkaufspreisLockMO", ObjEPosition.EinkaufspreisLockMO.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SelbstkostenLockMA", ObjEPosition.SelbstkostenLockMA.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SelbstkostenLockMO", ObjEPosition.SelbstkostenLockMO.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "VerkaufspreisLockMA", ObjEPosition.VerkaufspreisLockMA.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "VerkaufspreisLockMO", ObjEPosition.VerkaufspreisLockMO.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DocuwareLink1", Convert.ToString(ObjEPosition.DocuwareLink1)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DocuwareLink2", Convert.ToString(ObjEPosition.DocuwareLink2)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "DocuwareLink3", Convert.ToString(ObjEPosition.DocuwareLink3)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "GrandTotalME", ObjEPosition.GrandTotalME.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "GrandTotalMO", ObjEPosition.GrandTotalMO.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "FinalGB", ObjEPosition.FinalGB.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "EP", ObjEPosition.EP.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "SNO", ObjEPosition.SNO.ToString()); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "Discount", ObjEPosition.Discount.ToString(CInfo)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LVSectionID", Convert.ToString(ObjEPosition.LVSectionID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "LVStatusID", Convert.ToString(ObjEPosition.LVStatusID)); Xdoc = XMLBuilder.XmlConstruct(Xdoc, XPath, "PositionKZID", Convert.ToString(ObjEPosition.PositionKZID)); double OZID = 0; string stOZChar = ""; string OZ1 = string.Empty, OZ2 = string.Empty, OZ3 = string.Empty, OZ4 = string.Empty, OZ5 = string.Empty, OZ6 = string.Empty; if (!string.IsNullOrEmpty(ObjEPosition.Position_OZ)) { string[] strOZList = PrepareOZ(ObjEPosition.Position_OZ, strRaster).Split('.'); if (strOZList.Count() > 1) { string strOZID = strOZList[strOZList.Count() - 2]; string strIndex = strOZList[strOZList.Count() - 1]; if (!double.TryParse(strOZID + "." + strIndex, NumberStyles.Float, CultureInfo.GetCultureInfo("en"), out OZID)) { OZID = 0; } char [] OZcharList = strOZID.ToCharArray(); int CharCount = OZcharList.Count(); if (CharCount > 0) { OZ1 = Convert.ToString(OZcharList[0]); if (CharCount > 1) { OZ2 = Convert.ToString(OZcharList[1]); if (CharCount > 2) { OZ3 = Convert.ToString(OZcharList[2]); if (CharCount > 3) { OZ4 = Convert.ToString(OZcharList[3]); if (CharCount > 4) { OZ5 = Convert.ToString(OZcharList[4]); OZ6 = strIndex; } else { OZ5 = strIndex; } } else { OZ4 = strIndex; } } else { OZ3 = strIndex; } } else { OZ2 = strIndex; } } } } ObjDPosition.SavePositionDetails(Xdoc, ObjEPosition.ProjectID, ObjEPosition.LongDescription, OZID, OZ1, OZ2, OZ3, OZ4, OZ5, OZ6, stOZChar, ObjEPosition.MontageEntry, strRaster, ObjEPosition.RoundOffValue, ObjEPosition); } catch (Exception ex) { throw; } return(ObjEPosition); }