private void LoadRecord() { ERPConfig clsERPConfig = new ERPConfig(); ERPConfigDetails clsDetails = clsERPConfig.Details(); clsERPConfig.CommitAndDispose(); txtDateFrom.Text = clsDetails.PostingDateFrom.ToString("yyyy-MM-dd"); txtDateTo.Text = clsDetails.PostingDateTo.ToString("yyyy-MM-dd"); }
private void SaveRecord() { ERPConfigDetails clsDetails = new ERPConfigDetails(); clsDetails.PostingDateFrom = Convert.ToDateTime(txtDateFrom.Text); clsDetails.PostingDateTo = Convert.ToDateTime(txtDateTo.Text); ERPConfig clsERPConfig = new ERPConfig(); clsERPConfig.UpdatePostingDate(clsDetails.PostingDateFrom, clsDetails.PostingDateTo); clsERPConfig.CommitAndDispose(); }
private void LoadRecord() { ERPConfig clsERPConfig = new ERPConfig(); APLinkConfigDetails clsDetails = clsERPConfig.APLinkDetails(); clsERPConfig.CommitAndDispose(); cboChartOfAccountAPTracking.SelectedIndex = cboChartOfAccountAPTracking.Items.IndexOf(cboChartOfAccountAPTracking.Items.FindByValue(clsDetails.ChartOfAccountIDAPTracking.ToString())); cboChartOfAccountAPBills.SelectedIndex = cboChartOfAccountAPBills.Items.IndexOf(cboChartOfAccountAPBills.Items.FindByValue(clsDetails.ChartOfAccountIDAPBills.ToString())); cboChartOfAccountAPFreight.SelectedIndex = cboChartOfAccountAPFreight.Items.IndexOf(cboChartOfAccountAPFreight.Items.FindByValue(clsDetails.ChartOfAccountIDAPFreight.ToString())); cboChartOfAccountAPVDeposit.SelectedIndex = cboChartOfAccountAPVDeposit.Items.IndexOf(cboChartOfAccountAPVDeposit.Items.FindByValue(clsDetails.ChartOfAccountIDAPVDeposit.ToString())); cboChartOfAccountAPContra.SelectedIndex = cboChartOfAccountAPContra.Items.IndexOf(cboChartOfAccountAPContra.Items.FindByValue(clsDetails.ChartOfAccountIDAPContra.ToString())); cboChartOfAccountAPLatePayment.SelectedIndex = cboChartOfAccountAPLatePayment.Items.IndexOf(cboChartOfAccountAPLatePayment.Items.FindByValue(clsDetails.ChartOfAccountIDAPLatePayment.ToString())); }
private string CloseInventory() { string strRetValue = ""; try { DateTime DeliveryDate = Convert.ToDateTime(txtClosingDate.Text); ERPConfig clsERPConfig = new ERPConfig(); ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details(); if (clsERPConfigDetails.PostingDateFrom <= DeliveryDate && clsERPConfigDetails.PostingDateTo >= DeliveryDate) { string strReferenceNo = Constants.CLOSE_INVENTORY_CODE + CompanyDetails.BECompanyCode + DateTime.Now.Year.ToString() + clsERPConfig.get_LastClosingNo(); AccessUserDetails clsAccessUserDetails = (AccessUserDetails)Session["AccessUserDetails"]; ProductInventories clsProductInventories = new ProductInventories(clsERPConfig.Connection, clsERPConfig.Transaction); clsProductInventories.CloseInventoryByProductGroup(int.Parse(cboBranch.SelectedItem.Value), clsAccessUserDetails.UID, DateTime.Parse(txtClosingDate.Text), strReferenceNo, long.Parse(cboProductGroup.SelectedItem.Value), cboProductGroup.SelectedItem.Text); Products clsProducts = new Products(clsERPConfig.Connection, clsERPConfig.Transaction); clsProducts.LockUnlockForSellingByProductGroup(int.Parse(cboBranch.SelectedItem.Value), long.Parse(cboProductGroup.SelectedItem.Value), false); clsERPConfig.CommitAndDispose(); strRetValue = strReferenceNo; } else { clsERPConfig.CommitAndDispose(); string stScript = "<Script>"; stScript += "window.alert('Sorry you cannot close using the closing date: " + txtClosingDate.Text + ". Please enter an allowable posting date.')"; stScript += "</Script>"; Response.Write(stScript); } } catch (Exception ex) { string stScript = "<Script>"; stScript += "window.alert('An error has occured while closing the inventory. Details:' " + ex.Message + ")"; stScript += "</Script>"; Response.Write(stScript); } return strRetValue; }
private void Post() { DateTime DeliveryDate = Convert.ToDateTime(txtPostDate.Text); ERPConfig clsERPConfig = new ERPConfig(); ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details(); clsERPConfig.CommitAndDispose(); if (clsERPConfigDetails.PostingDateFrom <= DeliveryDate && clsERPConfigDetails.PostingDateTo >= DeliveryDate) { long DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text); string SupplierDRNo = txtSupplierDocNo.Text; DebitMemos clsDebitMemos = new DebitMemos(); clsDebitMemos.Post(DebitMemoID, SupplierDRNo, DeliveryDate); clsDebitMemos.CommitAndDispose(); Common Common = new Common(); string stParam = "?task=" + Common.Encrypt("list",Session.SessionID) + "&memoid=" + Common.Encrypt(DebitMemoID.ToString(),Session.SessionID); Response.Redirect("Default.aspx" + stParam); } else { string stScript = "<Script>"; stScript += "window.alert('Sorry you cannot post using the delivery date: " + txtPostDate.Text + ". Please enter an allowable posting date.')"; stScript += "</Script>"; Response.Write(stScript); } }
private void IssueGRN() { DateTime DeliveryDate = Convert.ToDateTime(txtDeliveryDate.Text); ERPConfig clsERPConfig = new ERPConfig(); ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details(); clsERPConfig.CommitAndDispose(); if (clsERPConfigDetails.PostingDateFrom <= DeliveryDate && clsERPConfigDetails.PostingDateTo >= DeliveryDate) { long SOID = Convert.ToInt64(lblSOID.Text); string CustomerDRNo = txtCustomerDRNo.Text; SO clsSO = new SO(); clsSO.IssueGRN(SOID, CustomerDRNo, DeliveryDate); clsSO.CommitAndDispose(); string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&soid=" + Common.Encrypt(SOID.ToString(), Session.SessionID); Response.Redirect("Default.aspx" + stParam); } else { string stScript = "<Script>"; stScript += "window.alert('Sorry you cannot post using the delivery date: " + txtDeliveryDate.Text + ". Please enter an allowable posting date.')"; stScript += "</Script>"; Response.Write(stScript); } }
private void SaveRecord() { APLinkConfigDetails clsDetails = new APLinkConfigDetails(); clsDetails.ChartOfAccountIDAPTracking = Convert.ToInt32(cboChartOfAccountAPTracking.SelectedItem.Value); clsDetails.ChartOfAccountIDAPBills = Convert.ToInt32(cboChartOfAccountAPBills.SelectedItem.Value); clsDetails.ChartOfAccountIDAPFreight = Convert.ToInt32(cboChartOfAccountAPFreight.SelectedItem.Value); clsDetails.ChartOfAccountIDAPVDeposit = Convert.ToInt32(cboChartOfAccountAPVDeposit.SelectedItem.Value); clsDetails.ChartOfAccountIDAPContra = Convert.ToInt32(cboChartOfAccountAPContra.SelectedItem.Value); clsDetails.ChartOfAccountIDAPLatePayment = Convert.ToInt32(cboChartOfAccountAPLatePayment.SelectedItem.Value); ERPConfig clsERPConfig = new ERPConfig(); clsERPConfig.UpdateAPLinkConfig(clsDetails); clsERPConfig.CommitAndDispose(); }
private void IssueGRN() { DateTime DeliveryDate = Convert.ToDateTime(txtDeliveryDate.Text); ERPConfig clsERPConfig = new ERPConfig(); ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details(); clsERPConfig.CommitAndDispose(); if (clsERPConfigDetails.PostingDateFrom <= DeliveryDate && clsERPConfigDetails.PostingDateTo >= DeliveryDate) { Int64 WBranchTransferID = Convert.ToInt64(lblWBranchTransferID.Text); string ReceivedBy = txtReceivedBy.Text; WBranchTransfer clsWBranchTransfer = new WBranchTransfer(); clsWBranchTransfer.IssueGRN(WBranchTransferID, ReceivedBy, DeliveryDate); clsWBranchTransfer.CommitAndDispose(); string stParam = "?task=" + Common.Encrypt("list",Session.SessionID) + "&WBranchTransferID=" + Common.Encrypt(WBranchTransferID.ToString(),Session.SessionID); Response.Redirect("Default.aspx" + stParam); } else { string stScript = "<Script>"; stScript += "window.alert('Sorry you cannot post using the delivery date: " + txtDeliveryDate.Text + ". Please enter an allowable posting date.')"; stScript += "</Script>"; Response.Write(stScript); } }
private Int64 SaveRecord() { ContactDetails clsDetails = new ContactDetails(); ERPConfig clsERPConfig = new ERPConfig(); BarcodeHelper ean13 = new BarcodeHelper(BarcodeHelper.CustomerCode_Country_Code, BarcodeHelper.CustomerCode_ManufacturerCode, clsERPConfig.get_LastCustomerCode()); clsDetails.ContactCode = ean13.CountryCode + ean13.ManufacturerCode + ean13.ProductCode + ean13.ChecksumDigit; clsERPConfig.CommitAndDispose(); clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text; clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value); clsDetails.ModeOfTerms = ModeOfTerms.Months; clsDetails.Terms = 0; clsDetails.Address = txtAddress1.Text + " " + txtAddress2.Text + " " + txtCity.Text + " " + txtState.Text + " " + txtZipCode.Text; clsDetails.BusinessName = txtBusinessName.Text; clsDetails.TelephoneNo = txtBusinessPhoneNo.Text; clsDetails.Remarks = txtRemarks.Text; clsDetails.Debit = 0; clsDetails.Credit = 0; clsDetails.IsCreditAllowed = false; clsDetails.CreditLimit = 0; clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value); clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value); DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE; DateTime dteSpouseBirthDate = Constants.C_DATE_MIN_VALUE; DateTime dteAnniversaryDate = Constants.C_DATE_MIN_VALUE; dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE; dteSpouseBirthDate = DateTime.TryParse(txtSpouseBirthDate.Text, out dteSpouseBirthDate) ? dteSpouseBirthDate : Constants.C_DATE_MIN_VALUE; dteAnniversaryDate = DateTime.TryParse(txtAnniversaryDate.Text, out dteAnniversaryDate) ? dteAnniversaryDate : Constants.C_DATE_MIN_VALUE; ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails(); clsAddOnDetails.ContactID = clsDetails.ContactID; clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value; clsAddOnDetails.FirstName = txtFirstName.Text; clsAddOnDetails.MiddleName = txtMiddleName.Text; clsAddOnDetails.LastName = txtLastName.Text; clsAddOnDetails.SpouseName = txtSpouseName.Text; clsAddOnDetails.BirthDate = dteBirthDate; clsAddOnDetails.SpouseBirthDate = dteSpouseBirthDate; clsAddOnDetails.AnniversaryDate = dteAnniversaryDate; clsAddOnDetails.Address1 = txtAddress1.Text; clsAddOnDetails.Address2 = txtAddress2.Text; clsAddOnDetails.City = txtCity.Text; clsAddOnDetails.State = txtState.Text; clsAddOnDetails.ZipCode = txtZipCode.Text; clsAddOnDetails.CountryID = int.Parse(cboCountry.SelectedItem.Value); clsAddOnDetails.CountryCode = cboCountry.SelectedItem.Text; clsAddOnDetails.BusinessPhoneNo = txtBusinessPhoneNo.Text; clsAddOnDetails.HomePhoneNo = txtHomePhoneNo.Text; clsAddOnDetails.MobileNo = txtMobileNo.Text; clsAddOnDetails.FaxNo = txtFaxNo.Text; clsAddOnDetails.EmailAddress = txtEmailAddress.Text; clsDetails.AdditionalDetails = clsAddOnDetails; Contacts clsContact = new Contacts(); Int64 id = clsContact.Insert(clsDetails); clsContact.CommitAndDispose(); return id; }