public RegistrationType IsDemoExpired(out string SerialNumber)
{
SerialNumber = null;
try
{
RegistrationType regIsDemoExpired = RegistrationType.DEMO_Unexpired;
SerialNumber = GetHDSerialNo();
if (SerialNumber == "W50SJSHQ" || SerialNumber == "K834T9A2BJNB" || SerialNumber == "K10HT77258WN" || SerialNumber == "587OCI98T" || SerialNumber == "MRG3W9KKH9S45H" || SerialNumber == "9546305796063968058" || SerialNumber == "9VP7QL84")
{
// K10HT77258WN - Lemuel
// 587OCI98T - Darius
// MRG3W9KKH9S45H - Rico
// 9546305796063968058 - Grace
// 9VP7QL84 - Lemuel
// WD-WXTY08TPJ153
return RegistrationType.Registered;
}
try
{
Data.Terminal clsTerminal = new Data.Terminal();
string cipherText = clsTerminal.getTerminalKey(SerialNumber);
clsTerminal.CommitAndDispose();
if (cipherText != string.Empty)
{
string plainText = CompanyDetails.CompanyCode + SerialNumber.ToString().Trim(); // original plaintext
//string cipherText = System.Configuration.ConfigurationManager.AppSettings["RegistrationKey"].ToString(); // encrypted text
string passPhrase = CompanyDetails.TIN; // can be any string
string initVector = "%@skmelaT3rsh1t!"; // must be 16 bytes
// Before encrypting data, we will append plain text to a random
// salt value, which will be between 4 and 8 bytes long (implicitly
// used defaults).
AceSoft.Cryptor clsCryptor = new AceSoft.Cryptor(passPhrase, initVector);
if (plainText == clsCryptor.Decrypt(cipherText))
{
return RegistrationType.Registered;
}
}
}
catch { }
Data.TerminalReport clsTerminalReport = new Data.TerminalReport();
string EndingTransactionNo = clsTerminalReport.EndingTransactioNo(Constants.TerminalBranchID, CompanyDetails.TerminalNo);
clsTerminalReport.CommitAndDispose();
if (Convert.ToInt64(EndingTransactionNo) > 1000)
regIsDemoExpired = RegistrationType.DEMO_Expired;
return regIsDemoExpired;
}
catch (Exception ex)
{
SerialNumber = ex.ToString();
return RegistrationType.Error; }
}
protected void Page_Load(object sender, System.EventArgs e)
{
const string defaultHeading = "Login";
const string defaultTitle = "RetailPlus System";
const SearchCategoryID defaultAllSourcesIndex = SearchCategoryID.AllSources;
LargeHeading.Text = defaultHeading;
SiteTitle.Title = defaultTitle;
HorizontalNavBar.PageNavigatorid = HorizontalNavID.Home;
RightBodySectionSearch.SearchIDSelectedItem = defaultAllSourcesIndex;
PageLevelError.Visible = false;
// Data.TerminalReport clsTerminalReport = new Data.TerminalReport();
// Data.TerminalReportDetails details = clsTerminalReport.Details(CompanyDetails.TerminalNo);
// clsTerminalReport.CommitAndDispose();
//
// if (Convert.ToInt64(details.EndingTransactionNo) >= 50)
// {
// Session["ErrorCurrentExecutionFilePath"] = Request.CurrentExecutionFilePath;
// Session["ErrMessage"] = Constants.DEMO_EXPIRED_MESSAGE;
// Session["ErrorMessage"] = Constants.DEMO_EXPIRED_MESSAGE;
// Session["ErrorSource"] = Constants.DEMO_EXPIRED_HEADER;
// Session["ErrorExceptionType"] = null;
// Session["ErrorStackTrace"] = null;
//
// Response.Redirect("/RetailPlus/GenericError.aspx");
// }
// else
// {
//Check if a user is currently login
if (Session["UID"] != null)
{
Login.AssignUserSession(Convert.ToInt16(Session["UID"]));
Response.Redirect(Constants.ROOT_DIRECTORY + "/Home/Default.aspx");
}
else
{ HorizontalNavBar.Visible = false;
RightBodySectionSearch.Visible = false;
Data.Terminal clsTerminal = new Data.Terminal();
clsTerminal.UpdateBEVersion("2.0.1.5");
clsTerminal.CommitAndDispose();
}
// }
}
private void LoadRecord()
{
Terminal clsTerminal = new Terminal();
RewardPointsDetails clsDetails = clsTerminal.RewardPointsDetails();
clsTerminal.CommitAndDispose();
chkEnableRewardPoints.Checked = clsDetails.EnableRewardPoints;
chkRoundDownRewardPoints.Checked = clsDetails.RoundDownRewardPoints;
txtRewardPointsMinimum.Text = clsDetails.RewardPointsMinimum.ToString("##0.#0");
txtRewardPointsEvery.Text = clsDetails.RewardPointsEvery.ToString("##0.#0");
txtRewardPoints.Text = clsDetails.RewardPoints.ToString("##0.#0");
chkEnableRewardPointsAsPayment.Checked = clsDetails.EnableRewardPointsAsPayment;
txtRewardPointsMaxPercentageForPayment.Text = clsDetails.RewardPointsMaxPercentageForPayment.ToString("##0.#0");
txtRewardPointsPaymentValue.Text = clsDetails.RewardPointsPaymentValue.ToString("##0.#0");
txtRewardPointsPaymentCashEquivalent.Text = clsDetails.RewardPointsPaymentCashEquivalent.ToString("##0.#0");
}
private void LoadOptions()
{
Data.Unit clsUnit = new Data.Unit();
cboProductGroupUnit.DataTextField = "UnitName";
cboProductGroupUnit.DataValueField = "UnitID";
cboProductGroupUnit.DataSource = clsUnit.ListAsDataTable(SortField: "UnitName").DefaultView;
cboProductGroupUnit.DataBind();
cboProductGroupUnit.SelectedIndex = cboProductGroupUnit.Items.Count - 1;
Terminal clsTerminal = new Terminal(clsUnit.Connection, clsUnit.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
txtVAT.Text = clsTerminalDetails.VAT.ToString("###.#0");
txtEVAT.Text = clsTerminalDetails.EVAT.ToString("###.#0");
txtLocalTax.Text = clsTerminalDetails.LocalTax.ToString("###.#0");
clsUnit.CommitAndDispose();
}
private void SaveRecord()
{
DebitMemoItemDetails clsDetails = new DebitMemoItemDetails();
Products clsProducts = new Products();
ProductDetails clsProductDetails = clsProducts.Details1(Constants.BRANCH_ID_MAIN, Convert.ToInt64(cboProductCode.SelectedItem.Value));
Terminal clsTerminal = new Terminal(clsProducts.Connection, clsProducts.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProducts.CommitAndDispose();
clsDetails.DebitMemoID = Convert.ToInt64(lblDebitMemoID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.ProductCode = clsProductDetails.ProductCode;
clsDetails.BarCode = clsProductDetails.BarCode;
clsDetails.Description = clsProductDetails.ProductDesc;
clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.ProductUnitCode = cboProductUnit.SelectedItem.Text;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.PrevUnitCost = Convert.ToDecimal(txtPrevPrice.Text);
clsDetails.UnitCost = Convert.ToDecimal(txtPrice.Text);
clsDetails.Discount = getItemTotalDiscount();
clsDetails.DiscountApplied = Convert.ToDecimal(txtDiscount.Text);
if (clsDetails.DiscountApplied == 0)
{
if (chkInPercent.Checked == true)
clsDetails.DiscountType = DiscountTypes.Percentage;
else
clsDetails.DiscountType = DiscountTypes.FixedValue;
}
else
{
clsDetails.DiscountType = DiscountTypes.NotApplicable;
}
clsDetails.IsVatable = chkIsTaxable.Checked;
clsDetails.Amount = ComputeItemAmount();
if (clsDetails.IsVatable)
{
clsDetails.VatableAmount = clsDetails.Amount;
clsDetails.EVatableAmount = clsDetails.Amount;
clsDetails.LocalTax = clsDetails.Amount;
if (clsTerminalDetails.IsVATInclusive == false)
{
if (clsDetails.VatableAmount < clsDetails.Discount) clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount < clsDetails.Discount) clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax < clsDetails.Discount) clsDetails.LocalTax = 0;
}
else
{
if (clsDetails.VatableAmount >= clsDetails.Discount) clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount >= clsDetails.Discount) clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax >= clsDetails.Discount) clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); else clsDetails.LocalTax = 0;
}
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
}
clsDetails.isVATInclusive = clsTerminalDetails.IsVATInclusive;
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (clsDetails.VariationMatrixID != 0)
clsDetails.MatrixDescription = cboVariation.SelectedItem.Text;
clsDetails.ProductGroup = clsProductDetails.ProductGroupCode;
clsDetails.ProductSubGroup = clsProductDetails.ProductSubGroupCode;
clsDetails.Remarks = txtRemarks.Text;
DebitMemoItems clsDebitMemoItems = new DebitMemoItems();
if (lblDebitMemoItemID.Text != "0")
{
clsDetails.DebitMemoItemID = Convert.ToInt64(lblDebitMemoItemID.Text);
clsDebitMemoItems.Update(clsDetails);
}
else
clsDebitMemoItems.Insert(clsDetails);
DebitMemoDetails clsDebitMemoDetails = new DebitMemoDetails();
clsDebitMemoDetails.DebitMemoID = clsDetails.DebitMemoID;
clsDebitMemoDetails.DiscountApplied = Convert.ToDecimal(txtPODebitMemoDiscountApplied.Text);
clsDebitMemoDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscountType.SelectedItem.Value);
clsDebitMemoDetails.Discount2Applied = Convert.ToDecimal(txtPODebitMemoDiscount2Applied.Text);
clsDebitMemoDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount2Type.SelectedItem.Value);
clsDebitMemoDetails.Discount3Applied = Convert.ToDecimal(txtPODebitMemoDiscount3Applied.Text);
clsDebitMemoDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboPODebitMemoDiscount3Type.SelectedItem.Value);
DebitMemos clsDebitMemos = new DebitMemos(clsDebitMemoItems.Connection, clsDebitMemoItems.Transaction);
clsDebitMemos.UpdateDiscount(clsDetails.DebitMemoID, clsDebitMemoDetails.DiscountApplied, clsDebitMemoDetails.DiscountType, clsDebitMemoDetails.Discount2Applied, clsDebitMemoDetails.Discount2Type, clsDebitMemoDetails.Discount3Applied, clsDebitMemoDetails.Discount3Type);
clsDebitMemoDetails = clsDebitMemos.Details(clsDetails.DebitMemoID);
clsDebitMemoItems.CommitAndDispose();
UpdateFooter(clsDebitMemoDetails);
}
private void LoadOptions()
{
Int64 UID = Convert.ToInt64(Session["UID"]);
Security.AccessRights clsAccessRights = new Security.AccessRights();
Security.AccessRightsDetails clsDetails = clsAccessRights.Details(UID,(int) AccessTypes.SummarizedDailySalesWithTFDetailed);
clsAccessRights.CommitAndDispose();
cboReportType.Items.Clear();
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION));
cboReportType.Items.Add(new ListItem(ReportTypes.SummarizeDailySales, ReportTypes.SummarizeDailySales));
if (clsDetails.Read)
cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerDay, ReportTypes.SalesPerDay));
if (cboReportType.Items.Count == 2) cboReportType.Items.RemoveAt(cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.REPORT_SELECTION)));
cboReportType.SelectedIndex = 0;
cboConsignment.Items.Clear();
cboConsignment.Items.Add(new ListItem("Both", "-1"));
cboConsignment.Items.Add(new ListItem("Yes", true.ToString()));
cboConsignment.Items.Add(new ListItem("No", false.ToString()));
cboTransactionStatus.Items.Clear();
foreach(string status in Enum.GetNames(typeof(TransactionStatus)))
{
cboTransactionStatus.Items.Add(new ListItem(status, status));
}
cboTransactionStatus.SelectedIndex = cboTransactionStatus.Items.IndexOf( cboTransactionStatus.Items.FindByText(TransactionStatus.NotYetApplied.ToString()));
cboPaymentType.Items.Clear();
foreach(string PaymentType in Enum.GetNames(typeof(PaymentTypes)))
{
cboPaymentType.Items.Add(new ListItem(PaymentType, PaymentType));
}
cboPaymentType.SelectedIndex = cboPaymentType.Items.IndexOf( cboPaymentType.Items.FindByText(PaymentTypes.NotYetAssigned.ToString()));
txtStartTransactionDate.Text = Common.ToShortDateString(DateTime.Now.AddDays(-1));
txtEndTransactionDate.Text = Common.ToShortDateString(DateTime.Now);
Customer clsCustomer = new Customer();
cboContactName.DataTextField = "ContactName";
cboContactName.DataValueField = "ContactID";
cboContactName.DataSource = clsCustomer.CustomersDataTable(txtContactName.Text, 0, false, "ContactName", SortOption.Ascending);
cboContactName.DataBind();
if (string.IsNullOrEmpty(txtContactName.Text))
cboContactName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboContactName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtContactName.Text, Constants.ZERO_STRING));
cboContactName.SelectedIndex = 0;
cboAgent.Items.Clear();
Contacts clsContact = new Contacts(clsCustomer.Connection, clsCustomer.Transaction);
cboAgent.DataTextField = "ContactName";
cboAgent.DataValueField = "ContactID";
cboAgent.DataSource = clsContact.AgentsAsDataTable(txtAgent.Text, 0, "ContactName", SortOption.Ascending);
cboAgent.DataBind();
if (string.IsNullOrEmpty(txtAgent.Text))
cboAgent.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboAgent.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtAgent.Text, Constants.ZERO_STRING));
cboAgent.SelectedIndex = 0;
Terminal clsTerminal = new Terminal(clsCustomer.Connection, clsCustomer.Transaction);
cboTerminalNo.DataTextField = "TerminalNo";
cboTerminalNo.DataValueField = "TerminalNo";
cboTerminalNo.DataSource = clsTerminal.ListAsDataTable();
cboTerminalNo.DataBind();
cboTerminalNo.Items.Insert(0, new ListItem(Constants.ALL, Constants.ALL));
cboTerminalNo.SelectedIndex = 0;
Branch clsBranch = new Branch(clsCustomer.Connection, clsCustomer.Transaction);
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable(OnlyIncludeIneSales: true).DefaultView;
cboBranch.DataBind();
cboBranch.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboBranch.SelectedIndex = 0;
Security.AccessUser clsAccessUser = new Security.AccessUser(clsCustomer.Connection, clsCustomer.Transaction);
cboCashierName.DataTextField = "Name";
cboCashierName.DataValueField = "UID";
cboCashierName.DataSource = clsAccessUser.Cashiers(txtCashierName.Text, 0);
cboCashierName.DataBind();
if (string.IsNullOrEmpty(txtCashierName.Text))
cboCashierName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboCashierName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtCashierName.Text, Constants.ZERO_STRING));
cboCashierName.SelectedIndex = 0;
ProductGroup clsProductGroup = new ProductGroup(clsCustomer.Connection, clsCustomer.Transaction);
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupName";
cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName");
cboProductGroup.DataBind();
cboProductGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboProductGroup.SelectedIndex = 0;
clsCustomer.CommitAndDispose();
#region Sales Per Day
cboMonth.Items.Add(new ListItem("January", "1"));
cboMonth.Items.Add(new ListItem("February", "2"));
cboMonth.Items.Add(new ListItem("March", "3"));
cboMonth.Items.Add(new ListItem("April", "4"));
cboMonth.Items.Add(new ListItem("May", "5"));
cboMonth.Items.Add(new ListItem("June", "6"));
cboMonth.Items.Add(new ListItem("July", "7"));
cboMonth.Items.Add(new ListItem("August", "8"));
cboMonth.Items.Add(new ListItem("September", "9"));
cboMonth.Items.Add(new ListItem("October", "10"));
cboMonth.Items.Add(new ListItem("November", "11"));
cboMonth.Items.Add(new ListItem("Decemeber", "12"));
cboMonth.SelectedIndex = DateTime.Now.Month - 1;
int x = 2007;
while (x <= DateTime.Now.Year)
{
cboYear.Items.Add(new ListItem(x.ToString(), x.ToString()));
x++;
}
cboYear.SelectedIndex = cboYear.Items.Count - 1;
#endregion
}
private void SaveRecord()
{
SOItemDetails clsDetails = new SOItemDetails();
Products clsProducts = new Products();
ProductDetails clsProductDetails = clsProducts.Details1(Constants.BRANCH_ID_MAIN, Convert.ToInt64(cboProductCode.SelectedItem.Value));
Terminal clsTerminal = new Terminal(clsProducts.Connection, clsProducts.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProducts.CommitAndDispose();
clsDetails.SOID = Convert.ToInt64(lblSOID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.ProductCode = clsProductDetails.ProductCode;
clsDetails.BarCode = clsProductDetails.BarCode;
clsDetails.Description = clsProductDetails.ProductDesc;
clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.ProductUnitCode = cboProductUnit.SelectedItem.Text;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.UnitCost = Convert.ToDecimal(txtPrice.Text);
clsDetails.Discount = getItemTotalDiscount();
clsDetails.DiscountApplied = Convert.ToDecimal(txtDiscount.Text);
if (clsDetails.DiscountApplied == 0)
{
if (chkInPercent.Checked == true)
clsDetails.DiscountType = DiscountTypes.Percentage;
else
clsDetails.DiscountType = DiscountTypes.FixedValue;
}
else
{
clsDetails.DiscountType = DiscountTypes.NotApplicable;
}
clsDetails.IsVatable = chkIsTaxable.Checked;
clsDetails.Amount = ComputeItemAmount();
if (clsDetails.IsVatable)
{
clsDetails.VatableAmount = clsDetails.Amount;
clsDetails.EVatableAmount = clsDetails.Amount;
clsDetails.LocalTax = clsDetails.Amount;
if (clsTerminalDetails.IsVATInclusive == false)
{
if (clsDetails.VatableAmount < clsDetails.Discount) clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount < clsDetails.Discount) clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax < clsDetails.Discount) clsDetails.LocalTax = 0;
}
else
{
if (clsDetails.VatableAmount >= clsDetails.Discount) clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.VatableAmount = 0;
if (clsDetails.EVatableAmount >= clsDetails.Discount) clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100)); else clsDetails.EVatableAmount = 0;
if (clsDetails.LocalTax >= clsDetails.Discount) clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100)); else clsDetails.LocalTax = 0;
}
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
//if (!clsTerminalDetails.IsVATInclusive) clsDetails.Amount += (clsDetails.VAT + clsDetails.LocalTax);
//if (!clsTerminalDetails.EnableEVAT) clsDetails.Amount += clsDetails.EVAT;
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
}
clsDetails.isVATInclusive = clsTerminalDetails.IsVATInclusive;
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
if (clsDetails.VariationMatrixID != 0)
clsDetails.MatrixDescription = cboVariation.SelectedItem.Text;
clsDetails.ProductGroup = clsProductDetails.ProductGroupCode;
clsDetails.ProductSubGroup = clsProductDetails.ProductSubGroupCode;
clsDetails.Remarks = txtRemarks.Text;
// Added Jul 1, 2010 4:20PM : for suggested selling information
clsDetails.SellingPrice = decimal.Parse(txtSellingPrice.Text);
clsDetails.SellingVAT = decimal.Parse(txtVAT.Text);
clsDetails.SellingEVAT = decimal.Parse(txtEVAT.Text);
clsDetails.SellingLocalTax = decimal.Parse(txtLocalTax.Text);
SOItem clsSOItem = new SOItem();
if (lblSOItemID.Text != "0")
{
clsDetails.SOItemID = Convert.ToInt64(lblSOItemID.Text);
clsSOItem.Update(clsDetails);
}
else
clsSOItem.Insert(clsDetails);
SODetails clsSODetails = new SODetails();
clsSODetails.SOID = clsDetails.SOID;
clsSODetails.DiscountApplied = Convert.ToDecimal(txtSODiscountApplied.Text);
clsSODetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboSODiscountType.SelectedItem.Value);
SO clsSO = new SO(clsSOItem.Connection, clsSOItem.Transaction);
clsSO.UpdateDiscount(clsDetails.SOID, clsSODetails.DiscountApplied, clsSODetails.DiscountType);
clsSODetails = clsSO.Details(clsDetails.SOID);
clsSOItem.CommitAndDispose();
UpdateFooter(clsSODetails);
}
private Int32 SaveRecord()
{
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsDetails = new ProductUnitsMatrixDetails();
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.BaseUnitID = Convert.ToInt32(lblBaseUnitID.Text);
clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text);
clsDetails.BottomUnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value);
clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text);
int id = clsUnitMatrix.Insert(clsDetails);
ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails();
ProductPackage clsProductPackage = new ProductPackage(clsUnitMatrix.Connection, clsUnitMatrix.Transaction);
clsProductPackageDetails = clsProductPackage.DetailsByProductIDAndUnitID(Convert.ToInt64(lblProductID.Text), Convert.ToInt32(cboBottomUnit.SelectedItem.Value));
if (clsProductPackageDetails.PackageID == 0)
{
Products clsProduct = new Products(clsUnitMatrix.Connection, clsUnitMatrix.Transaction);
ProductDetails clsProductDetails = clsProduct.Details(Convert.ToInt64(lblProductID.Text));
Terminal clsTerminal = new Terminal(clsUnitMatrix.Connection, clsUnitMatrix.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
clsProductPackageDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsProductPackageDetails.UnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value);
clsProductPackageDetails.Price = clsProductDetails.Price * Convert.ToDecimal(txtBaseUnitValue.Text);
clsProductPackageDetails.WSPrice = clsProductDetails.WSPrice * Convert.ToDecimal(txtBaseUnitValue.Text);
clsProductPackageDetails.PurchasePrice = clsProductDetails.PurchasePrice * Convert.ToDecimal(txtBaseUnitValue.Text);
clsProductPackageDetails.Quantity = 1;
clsProductPackageDetails.VAT = clsTerminalDetails.VAT;
clsProductPackageDetails.EVAT = clsTerminalDetails.EVAT;
clsProductPackageDetails.LocalTax = clsTerminalDetails.LocalTax;
if (!string.IsNullOrEmpty(clsProductDetails.BarCode1)) clsProductPackageDetails.BarCode1 = clsProductDetails.BarCode1 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString();
if (!string.IsNullOrEmpty(clsProductDetails.BarCode2)) clsProductPackageDetails.BarCode2 = clsProductDetails.BarCode2 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString();
if (!string.IsNullOrEmpty(clsProductDetails.BarCode3)) clsProductPackageDetails.BarCode3 = clsProductDetails.BarCode3 + clsProductPackageDetails.UnitID.ToString() + clsProductPackageDetails.Quantity.ToString();
clsProductPackage.Insert(clsProductPackageDetails);
}
clsUnitMatrix.CommitAndDispose();
return id;
}
public void GenerateItemsForReorder(Int32 TerminalID, long SOID)
{
try
{
GetConnection();
Terminal clsTerminal = new Terminal(base.Connection, base.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(TerminalID);
SODetails clsSODetails = Details(SOID);
Products clsProduct = new Products(base.Connection, base.Transaction);
System.Data.DataTable dt = clsProduct.ForReorder(clsSODetails.CustomerID);
SOItem clsSOItem = new SOItem(base.Connection, base.Transaction);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
foreach (System.Data.DataRow dr in dt.Rows)
{
SOItemDetails clsDetails = new SOItemDetails();
clsDetails.SOID = SOID;
clsDetails.ProductID = Convert.ToInt64(dr["ProductID"]);
clsDetails.ProductCode = dr["ProductCode"].ToString();
clsDetails.BarCode = dr["BarCode"].ToString();
clsDetails.Description = dr["ProductDesc"].ToString();
clsDetails.ProductGroup = dr["ProductGroupCode"].ToString();
clsDetails.ProductSubGroup = dr["ProductSubGroupCode"].ToString();
clsDetails.ProductUnitID = Convert.ToInt32(dr["UnitID"]);
clsDetails.ProductUnitCode = dr["UnitName"].ToString();
clsDetails.Quantity = Convert.ToDecimal(dr["ReorderQty"]);
clsDetails.UnitCost = Convert.ToDecimal(dr["Price"]);
clsDetails.Discount = 0;
clsDetails.DiscountApplied = 0;
clsDetails.DiscountType = DiscountTypes.Percentage;
clsDetails.Remarks = "added using auto generation";
decimal amount = clsDetails.Quantity * clsDetails.UnitCost;
if (Convert.ToDecimal(dr["VAT"]) > 0)
{
clsDetails.VatableAmount = amount;
clsDetails.EVatableAmount = amount;
clsDetails.LocalTax = amount;
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
clsDetails.IsVatable = true;
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
clsDetails.IsVatable = false;
}
clsDetails.Amount = amount + clsDetails.VAT;
System.Data.DataTable dtmatrix = clsProductVariationsMatrix.ForReorder(clsDetails.ProductID, clsSODetails.CustomerID);
if (dtmatrix.Rows.Count > 0)
foreach (System.Data.DataRow drmatrix in dtmatrix.Rows)
{
amount = clsDetails.Quantity * clsDetails.UnitCost;
clsDetails.ProductUnitID = Convert.ToInt32(drmatrix["UnitID"]);
clsDetails.ProductUnitCode = drmatrix["UnitName"].ToString();
clsDetails.Quantity = Convert.ToDecimal(drmatrix["ReorderQty"]);
clsDetails.UnitCost = Convert.ToDecimal(drmatrix["Price"]);
if (Convert.ToDecimal(drmatrix["VAT"]) > 0)
{
clsDetails.VatableAmount = amount;
clsDetails.EVatableAmount = amount;
clsDetails.LocalTax = amount;
clsDetails.VAT = clsDetails.VatableAmount * (clsTerminalDetails.VAT / 100);
clsDetails.EVAT = clsDetails.EVatableAmount * (clsTerminalDetails.EVAT / 100);
clsDetails.LocalTax = clsDetails.LocalTax * (clsTerminalDetails.LocalTax / 100);
clsDetails.IsVatable = true;
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
clsDetails.IsVatable = false;
}
clsDetails.Amount = amount + clsDetails.VAT;
clsDetails.VariationMatrixID = Convert.ToInt64(drmatrix["MatrixID"]);
clsDetails.MatrixDescription = drmatrix["VariationDesc"].ToString();
clsSOItem.Insert(clsDetails);
}
else
{
clsDetails.VariationMatrixID = 0;
clsDetails.MatrixDescription = string.Empty;
clsSOItem.Insert(clsDetails);
}
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
Int32 iID = Convert.ToInt32(Common.Decrypt(Request.QueryString["id"],Session.SessionID));
ProductGroup clsProductGroup = new ProductGroup();
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupID";
cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName").DefaultView;
cboProductGroup.DataBind();
cboProductGroup.SelectedIndex = cboProductGroup.Items.Count - 1;
Data.Unit clsUnit = new Data.Unit(clsProductGroup.Connection, clsProductGroup.Transaction);
cboProductUnit.DataTextField = "UnitName";
cboProductUnit.DataValueField = "UnitID";
cboProductUnit.DataSource = clsUnit.ListAsDataTable(SortField:"UnitName").DefaultView;
cboProductUnit.DataBind();
cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactName = true;
ContactColumns clsContactSearchColumns = new ContactColumns();
Contacts clsContact = new Contacts(clsProductGroup.Connection, clsProductGroup.Transaction);
cboSupplier.DataTextField = "ContactName";
cboSupplier.DataValueField = "ContactID";
cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsContactSearchColumns, string.Empty, 0, false, "ContactName", System.Data.SqlClient.SortOrder.Ascending).DefaultView;
cboSupplier.DataBind();
cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductGroup.Connection, clsProductGroup.Transaction);
ProductUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(iID);
if (clsUnitDetails.BottomUnitName == null)
{
cboProductUnit.Enabled = true;
}
// Added July 9, 2010
Terminal clsTerminal = new Terminal(clsProductGroup.Connection, clsProductGroup.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
txtWSPriceMarkUp.Text = clsTerminalDetails.WSPriceMarkUp.ToString();
txtMargin.Text = clsTerminalDetails.RETPriceMarkUp.ToString();
clsProductGroup.CommitAndDispose();
}
private void SaveRecord()
{
TerminalDetails clsDetails = new TerminalDetails();
clsDetails.BranchID = Convert.ToInt32(lblBranchID.Text);
clsDetails.TerminalID = Convert.ToInt32(lblTerminalID.Text);
clsDetails.TerminalNo = txtTerminalNo.Text;
clsDetails.TerminalCode = txtTerminalCode.Text;
clsDetails.TerminalName = txtTerminalName.Text;
clsDetails.Status = 0;
clsDetails.DateCreated = Convert.ToDateTime(txtDateCreated.Text);
clsDetails.MachineSerialNo = txtMachineSerialNo.Text;
clsDetails.AccreditationNo = txtAccreditationNo.Text;
clsDetails.IsPrinterAutoCutter = Convert.ToBoolean(chkIsPrinterAutoCutter.Checked);
clsDetails.AutoPrint = (PrintingPreference) Enum.Parse(typeof(PrintingPreference), cboAutoPrint.SelectedItem.Value);
clsDetails.IsVATInclusive = Convert.ToBoolean(chkIsVATInclusive.Checked);
clsDetails.PrinterName = txtPrinterName.Text;
clsDetails.TurretName = txtTurretName.Text;
clsDetails.CashDrawerName = txtCashDrawerName.Text;
clsDetails.ItemVoidConfirmation = Convert.ToBoolean(chkItemVoidConfirmation.Checked);
clsDetails.EnableEVAT = Convert.ToBoolean(chkEnableEVAT.Checked);
clsDetails.MaxReceiptWidth = Convert.ToInt16(txtMaxReceiptWidth.Text);
clsDetails.FORM_Behavior = cboFormBehaviour.SelectedItem.Value;
clsDetails.MarqueeMessage = txtMarqueeMessage.Text;
// Added May 6, 2009.
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.ShowItemMoreThanZeroQty = chkShowItemMoreThanZeroQty.Checked;
clsDetails.ShowOnlyPackedTransactions = chkShowOnlyPackedTransactions.Checked;
clsDetails.ShowOneTerminalSuspendedTransactions = chkShowOneTerminalSuspendedTransactions.Checked;
clsDetails.ReceiptType = (TerminalReceiptType)Enum.Parse(typeof(TerminalReceiptType), cboReceiptType.SelectedItem.Value);
clsDetails.SalesInvoicePrinterName = txtSalesInvoicePrinterName.Text;
clsDetails.CashCountBeforeReport = chkCashCountBeforeReport.Checked;
clsDetails.PreviewTerminalReport = chkPreviewTerminalReport.Checked;
// Added May 6, 2009.
clsDetails.IsPrinterDotMatrix = chkIsPrinterDotmatrix.Checked;
clsDetails.IsChargeEditable = chkIsChargeEditable.Checked;
clsDetails.IsDiscountEditable = chkIsDiscountEditable.Checked;
clsDetails.CheckCutOffTime = chkCheckCutOffTime.Checked;
clsDetails.StartCutOffTime = txtStartCutOffTime.Text;
clsDetails.EndCutOffTime = txtEndCutOffTime.Text;
clsDetails.WithRestaurantFeatures = chkWithRestaurantFeatures.Checked;
clsDetails.SeniorCitizenDiscountCode = cboDiscountCode.SelectedItem.Value;
clsDetails.PWDDiscountCode = cboPWDDiscountCode.SelectedItem.Value;
// Added May 21, 2009
clsDetails.IsTouchScreen = chkIsTouchScreen.Checked;
// Added June 1, 2010
clsDetails.WillContinueSelectionVariation = chkWillContinueSelectionVariation.Checked;
// Added June 15, 2010
clsDetails.WillContinueSelectionProduct = chkWillContinueSelectionProduct.Checked;
// Added Sep 21, 2010
clsDetails.WillPrintGrandTotal = chkWillPrintGrandTotal.Checked;
// Added Apr 12, 2011
clsDetails.ReservedAndCommit = chkReservedAndCommit.Checked;
// Added Oct 17, 2011
clsDetails.ShowCustomerSelection = chkShowCustomerSelection.Checked;
clsDetails.GroupChargeType = new ChargeTypeDetails()
{
ChargeTypeID = int.Parse(cboGroupChargeType.SelectedItem.Value),
ChargeTypeCode = cboGroupChargeType.SelectedItem.Text
};
clsDetails.PersonalChargeType = new ChargeTypeDetails()
{
ChargeTypeID = int.Parse(cboPersonalChargeType.SelectedItem.Value),
ChargeTypeCode = cboPersonalChargeType.SelectedItem.Text
};
// Added Sep 24, 2014
clsDetails.DefaultTransactionChargeCode = cboDefaultTransactionChargeCode.SelectedItem.Value;
clsDetails.DineInChargeCode = cboDineInChargeCode.SelectedItem.Value;
clsDetails.TakeOutChargeCode = cboTakeOutChargeCode.SelectedItem.Value;
clsDetails.DeliveryChargeCode = cboDeliveryChargeCode.SelectedItem.Value;
Terminal clsTerminal = new Terminal();
clsTerminal.Update(clsDetails);
clsTerminal.CommitAndDispose();
}
private void LoadRecord()
{
Int32 TerminalID = Convert.ToInt32(Common.Decrypt(Request.QueryString["id"],Session.SessionID));
Terminal clsTerminal = new Terminal();
TerminalDetails clsDetails = clsTerminal.Details(TerminalID);
clsTerminal.CommitAndDispose();
lblBranchID.Text = clsDetails.BranchID.ToString();
lblTerminalID.Text = clsDetails.TerminalID.ToString();
txtTerminalNo.Text = clsDetails.TerminalNo;
txtTerminalCode.Text = clsDetails.TerminalCode;
txtTerminalName.Text = clsDetails.TerminalName;
txtStatus.Text = clsDetails.Status.ToString("G");
txtDateCreated.Text = clsDetails.DateCreated.ToString("yyyy-MM-dd HH:mm");
txtMachineSerialNo.Text = clsDetails.MachineSerialNo;
txtAccreditationNo.Text = clsDetails.AccreditationNo;
chkIsPrinterAutoCutter.Checked = clsDetails.IsPrinterAutoCutter;
cboAutoPrint.SelectedIndex = cboAutoPrint.Items.IndexOf(cboAutoPrint.Items.FindByValue(clsDetails.AutoPrint.ToString("d")));
chkIsVATInclusive.Checked = clsDetails.IsVATInclusive;
txtPrinterName.Text = clsDetails.PrinterName;
txtTurretName.Text = clsDetails.TurretName;
txtCashDrawerName.Text = clsDetails.CashDrawerName;
chkItemVoidConfirmation.Checked = clsDetails.ItemVoidConfirmation;
chkEnableEVAT.Checked = clsDetails.EnableEVAT;
txtMaxReceiptWidth.Text = clsDetails.MaxReceiptWidth.ToString();
cboFormBehaviour.SelectedIndex = cboFormBehaviour.Items.IndexOf(cboFormBehaviour.Items.FindByValue(clsDetails.FORM_Behavior));
txtMarqueeMessage.Text = clsDetails.MarqueeMessage;
if (Session["UserName"].ToString().ToLower() == "admin")
{
txtMachineSerialNo.ReadOnly = false;
txtAccreditationNo.ReadOnly = false;
}
// Added May 6, 2009.
txtVAT.Text = clsDetails.VAT.ToString("##.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("##.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("##.#0");
chkShowItemMoreThanZeroQty.Checked = clsDetails.ShowItemMoreThanZeroQty;
chkShowOnlyPackedTransactions.Checked = clsDetails.ShowOnlyPackedTransactions;
chkShowOneTerminalSuspendedTransactions.Checked = clsDetails.ShowOneTerminalSuspendedTransactions;
cboReceiptType.SelectedIndex = cboReceiptType.Items.IndexOf(cboReceiptType.Items.FindByValue(clsDetails.ReceiptType.ToString("d")));
txtSalesInvoicePrinterName.Text = clsDetails.SalesInvoicePrinterName;
chkCashCountBeforeReport.Checked = clsDetails.CashCountBeforeReport;
chkPreviewTerminalReport.Checked = clsDetails.PreviewTerminalReport;
// Added May 6, 2009.
chkIsPrinterDotmatrix.Checked = clsDetails.IsPrinterDotMatrix;
chkIsChargeEditable.Checked = clsDetails.IsChargeEditable;
chkIsDiscountEditable.Checked = clsDetails.IsDiscountEditable;
chkCheckCutOffTime.Checked = clsDetails.CheckCutOffTime;
txtStartCutOffTime.Text = clsDetails.StartCutOffTime;
txtEndCutOffTime.Text = clsDetails.EndCutOffTime;
chkWithRestaurantFeatures.Checked = clsDetails.WithRestaurantFeatures;
cboDiscountCode.SelectedIndex = cboDiscountCode.Items.IndexOf(cboDiscountCode.Items.FindByValue(clsDetails.SeniorCitizenDiscountCode));
cboPWDDiscountCode.SelectedIndex = cboPWDDiscountCode.Items.IndexOf(cboPWDDiscountCode.Items.FindByValue(clsDetails.PWDDiscountCode));
chkIsTouchScreen.Checked = clsDetails.IsTouchScreen;
chkWillContinueSelectionVariation.Checked = clsDetails.WillContinueSelectionVariation;
chkWillContinueSelectionProduct.Checked = clsDetails.WillContinueSelectionProduct;
chkWillPrintGrandTotal.Checked = clsDetails.WillPrintGrandTotal;
chkReservedAndCommit.Checked = clsDetails.ReservedAndCommit;
// Added Oct 17, 2011
chkShowCustomerSelection.Checked = clsDetails.ShowCustomerSelection;
cboGroupChargeType.SelectedIndex = cboGroupChargeType.Items.IndexOf(cboGroupChargeType.Items.FindByValue(clsDetails.GroupChargeType.ChargeTypeID.ToString()));
cboPersonalChargeType.SelectedIndex = cboPersonalChargeType.Items.IndexOf(cboPersonalChargeType.Items.FindByValue(clsDetails.PersonalChargeType.ChargeTypeID.ToString()));
// Added Sep 24, 2014
cboDefaultTransactionChargeCode.SelectedIndex = cboDefaultTransactionChargeCode.Items.IndexOf(cboDefaultTransactionChargeCode.Items.FindByValue(clsDetails.DefaultTransactionChargeCode));
cboDineInChargeCode.SelectedIndex = cboDineInChargeCode.Items.IndexOf(cboDineInChargeCode.Items.FindByValue(clsDetails.DineInChargeCode));
cboTakeOutChargeCode.SelectedIndex = cboTakeOutChargeCode.Items.IndexOf(cboTakeOutChargeCode.Items.FindByValue(clsDetails.TakeOutChargeCode));
cboDeliveryChargeCode.SelectedIndex = cboDeliveryChargeCode.Items.IndexOf(cboDeliveryChargeCode.Items.FindByValue(clsDetails.DeliveryChargeCode));
}
private void SaveRecord()
{
RewardPointsDetails clsDetails = new RewardPointsDetails();
clsDetails.EnableRewardPoints = chkEnableRewardPoints.Checked;
clsDetails.RoundDownRewardPoints = chkRoundDownRewardPoints.Checked;
clsDetails.RewardPointsMinimum = Convert.ToDecimal(txtRewardPointsMinimum.Text);
clsDetails.RewardPointsEvery = Convert.ToDecimal(txtRewardPointsEvery.Text);
clsDetails.RewardPoints = Convert.ToDecimal(txtRewardPoints.Text);
clsDetails.EnableRewardPointsAsPayment = chkEnableRewardPointsAsPayment.Checked;
clsDetails.RewardPointsMaxPercentageForPayment = Convert.ToDecimal(txtRewardPointsMaxPercentageForPayment.Text);
clsDetails.RewardPointsPaymentValue = Convert.ToDecimal(txtRewardPointsPaymentValue.Text);
clsDetails.RewardPointsPaymentCashEquivalent = Convert.ToDecimal(txtRewardPointsPaymentCashEquivalent.Text);
Terminal clsTerminal = new Terminal();
clsTerminal.UpdateRewardPointSystem(clsDetails);
clsTerminal.CommitAndDispose();
}
private void LoadOptions()
{
ProductGroup clsProductGroup = new ProductGroup();
DataClass clsDataClass = new DataClass();
cboGroup.DataTextField = "ProductGroupName";
cboGroup.DataValueField = "ProductGroupID";
cboGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName").DefaultView;
cboGroup.DataBind();
cboGroup.SelectedIndex = cboGroup.Items.Count - 1;
cboGroup_SelectedIndexChanged(null, System.EventArgs.Empty);
Data.Unit clsUnit = new Data.Unit();
cboProductSubGroupUnit.DataTextField = "UnitName";
cboProductSubGroupUnit.DataValueField = "UnitID";
cboProductSubGroupUnit.DataSource = clsUnit.ListAsDataTable(SortField:"UnitName").DefaultView;
cboProductSubGroupUnit.DataBind();
cboProductSubGroupUnit.SelectedIndex = cboProductSubGroupUnit.Items.Count - 1;
Terminal clsTerminal = new Terminal(clsUnit.Connection, clsUnit.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
txtVAT.Text = clsTerminalDetails.VAT.ToString("###.#0");
txtEVAT.Text = clsTerminalDetails.EVAT.ToString("###.#0");
txtLocalTax.Text = clsTerminalDetails.LocalTax.ToString("###.#0");
clsUnit.CommitAndDispose();
if (cboGroup.Items.Count != 0)
{
Int32 BaseUnitID= clsProductGroup.Details(Convert.ToInt32(cboGroup.SelectedItem.Value)).UnitDetails.UnitID;
cboProductSubGroupUnit.SelectedIndex = cboProductSubGroupUnit.Items.IndexOf( cboProductSubGroupUnit.Items.FindByValue(BaseUnitID.ToString()));
}
clsProductGroup.CommitAndDispose();
}
private void LoadOptions()
{
Int64 UID = Convert.ToInt64(Session["UID"]);
Security.AccessRights clsAccessRights = new Security.AccessRights();
cboReportType.Items.Clear();
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION));
if (clsAccessRights.Details(UID, (int)AccessTypes.SummarizedDailySales).Read)
{
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.SummarizeDailySales, ReportTypes.SummarizeDailySales));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerDay, ReportTypes.SalesPerDay));
}
//if (clsAccessRights.Details(UID, (int)AccessTypes.SummarizedDailySalesWithTF).Read)
//{
// cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
// cboReportType.Items.Add(new ListItem(ReportTypes.SummarizeDailySalesWithTF, ReportTypes.SummarizeDailySalesWithTF));
// cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerDayWithTF, ReportTypes.SalesPerDayWithTF));
//}
if (clsAccessRights.Details(UID, (int)AccessTypes.SalesTransactionReport).Read)
{
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesPerHour, ReportTypes.SalesPerHour));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactions, ReportTypes.SalesTransactions));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomer, ReportTypes.SalesTransactionPerCustomer));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerPerGroup, ReportTypes.SalesTransactionPerCustomerPerGroup));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerPerGroupSummarized, ReportTypes.SalesTransactionPerCustomerPerGroupSummarized));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerWithCheque, ReportTypes.SalesTransactionPerCustomerWithCheque));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCustomerPerItem, ReportTypes.SalesTransactionPerCustomerPerItem));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCashier, ReportTypes.SalesTransactionPerCashier));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerCashierPerCustomer, ReportTypes.SalesTransactionPerCashierPerCustomer));
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerTerminal, ReportTypes.SalesTransactionPerTerminal));
if (clsAccessRights.Details(UID, (int)AccessTypes.SalesTransactionPerItem).Read)
{
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerItem, ReportTypes.SalesTransactionPerItem));
}
if (clsAccessRights.Details(UID, (int)AccessTypes.SalesTransactionPerItemWoutPurchaseDetails).Read)
{
cboReportType.Items.Add(new ListItem(ReportTypes.SalesTransactionPerItemWoutPurchaseDetails, ReportTypes.SalesTransactionPerItemWoutPurchaseDetails));
}
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.CashSalesDaily, ReportTypes.CashSalesDaily));
cboReportType.Items.Add(new ListItem(ReportTypes.CashSalesMonthly, ReportTypes.CashSalesMonthly));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.ChequePaymentList, ReportTypes.ChequePaymentList));
cboReportType.Items.Add(new ListItem(ReportTypes.ChequeSalesDaily, ReportTypes.ChequeSalesDaily));
cboReportType.Items.Add(new ListItem(ReportTypes.ChequeSalesMonthly, ReportTypes.ChequeSalesMonthly));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.CreditCardSalesDaily, ReportTypes.CreditCardSalesDaily));
cboReportType.Items.Add(new ListItem(ReportTypes.CreditCardSalesMonthly, ReportTypes.CreditCardSalesMonthly));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.DailySalesTransaction, ReportTypes.DailySalesTransaction));
cboReportType.Items.Add(new ListItem(ReportTypes.WeeklySalesTransaction, ReportTypes.WeeklySalesTransaction));
cboReportType.Items.Add(new ListItem(ReportTypes.MonthlySalesTransaction, ReportTypes.MonthlySalesTransaction));
}
if (clsAccessRights.Details(UID, (int)AccessTypes.PaidOutDisburseROC).Read)
{
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.PaidOut, ReportTypes.PaidOut));
cboReportType.Items.Add(new ListItem(ReportTypes.Disburse, ReportTypes.Disburse));
cboReportType.Items.Add(new ListItem(ReportTypes.RecieveOnAccount, ReportTypes.RecieveOnAccount));
}
cboReportType.SelectedIndex = 0;
clsAccessRights.CommitAndDispose();
cboConsignment.Items.Clear();
cboConsignment.Items.Add(new ListItem("Both", "-1"));
cboConsignment.Items.Add(new ListItem("Yes", true.ToString()));
cboConsignment.Items.Add(new ListItem("No", false.ToString()));
cboTransactionStatus.Items.Clear();
foreach(string status in Enum.GetNames(typeof(TransactionStatus)))
{
cboTransactionStatus.Items.Add(new ListItem(status, status));
}
cboTransactionStatus.SelectedIndex = cboTransactionStatus.Items.IndexOf( cboTransactionStatus.Items.FindByText(TransactionStatus.NotYetApplied.ToString()));
cboPaymentType.Items.Clear();
foreach(string PaymentType in Enum.GetNames(typeof(PaymentTypes)))
{
cboPaymentType.Items.Add(new ListItem(PaymentType, PaymentType));
}
cboPaymentType.SelectedIndex = cboPaymentType.Items.IndexOf( cboPaymentType.Items.FindByText(PaymentTypes.NotYetAssigned.ToString()));
txtStartValidityDate.Text = Common.ToShortDateString(DateTime.Now);
txtEndValidityDate.Text = Common.ToShortDateString(DateTime.Now.AddDays(30));
txtStartTransactionDate.Text = Common.ToShortDateString(DateTime.Now.AddDays(-1));
txtEndTransactionDate.Text = Common.ToShortDateString(DateTime.Now);
Customer clsCustomer = new Customer();
cboContactName.DataTextField = "ContactName";
cboContactName.DataValueField = "ContactID";
cboContactName.DataSource = clsCustomer.CustomersDataTable(txtContactName.Text, 0, false, "ContactName", SortOption.Ascending);
cboContactName.DataBind();
if (string.IsNullOrEmpty(txtContactName.Text))
cboContactName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboContactName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtContactName.Text, Constants.ZERO_STRING));
cboContactName.SelectedIndex = 0;
ContactGroups clsContactGroups = new ContactGroups(clsCustomer.Connection, clsCustomer.Transaction);
cboContactGroupName.DataTextField = "ContactGroupName";
cboContactGroupName.DataValueField = "ContactGroupID";
cboContactGroupName.DataSource = clsContactGroups.ListAsDataTable(ContactGroupCategory.CUSTOMER, txtContactGroupName.Text);
cboContactGroupName.DataBind();
if (string.IsNullOrEmpty(txtContactName.Text))
cboContactGroupName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboContactGroupName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtContactGroupName.Text, Constants.ZERO_STRING));
cboContactGroupName.SelectedIndex = 0;
cboAgent.Items.Clear();
Contacts clsContact = new Contacts(clsCustomer.Connection, clsCustomer.Transaction);
cboAgent.DataTextField = "ContactName";
cboAgent.DataValueField = "ContactID";
cboAgent.DataSource = clsContact.AgentsAsDataTable(txtAgent.Text, 0, "ContactName", SortOption.Ascending);
cboAgent.DataBind();
if (string.IsNullOrEmpty(txtAgent.Text))
cboAgent.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboAgent.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtAgent.Text, Constants.ZERO_STRING));
cboAgent.SelectedIndex = 0;
Terminal clsTerminal = new Terminal(clsCustomer.Connection, clsCustomer.Transaction);
cboTerminalNo.DataTextField = "TerminalNo";
cboTerminalNo.DataValueField = "TerminalNo";
cboTerminalNo.DataSource = clsTerminal.ListAsDataTable();
cboTerminalNo.DataBind();
cboTerminalNo.Items.Insert(0, new ListItem(Constants.ALL, Constants.ALL));
cboTerminalNo.SelectedIndex = 0;
Branch clsBranch = new Branch(clsCustomer.Connection, clsCustomer.Transaction);
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
cboBranch.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboBranch.SelectedIndex = 0;
Security.AccessUser clsAccessUser = new Security.AccessUser(clsCustomer.Connection, clsCustomer.Transaction);
cboCashierName.DataTextField = "Name";
cboCashierName.DataValueField = "UID";
cboCashierName.DataSource = clsAccessUser.Cashiers(txtCashierName.Text, 0);
cboCashierName.DataBind();
if (string.IsNullOrEmpty(txtCashierName.Text))
cboCashierName.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboCashierName.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtCashierName.Text, Constants.ZERO_STRING));
cboCashierName.SelectedIndex = 0;
ProductGroup clsProductGroup = new ProductGroup(clsCustomer.Connection, clsCustomer.Transaction);
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupName";
cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField:"ProductGroupName");
cboProductGroup.DataBind();
cboProductGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboProductGroup.SelectedIndex = 0;
clsCustomer.CommitAndDispose();
#region Sales Per Day
cboMonth.Items.Add(new ListItem("January", "1"));
cboMonth.Items.Add(new ListItem("February", "2"));
cboMonth.Items.Add(new ListItem("March", "3"));
cboMonth.Items.Add(new ListItem("April", "4"));
cboMonth.Items.Add(new ListItem("May", "5"));
cboMonth.Items.Add(new ListItem("June", "6"));
cboMonth.Items.Add(new ListItem("July", "7"));
cboMonth.Items.Add(new ListItem("August", "8"));
cboMonth.Items.Add(new ListItem("September", "9"));
cboMonth.Items.Add(new ListItem("October", "10"));
cboMonth.Items.Add(new ListItem("November", "11"));
cboMonth.Items.Add(new ListItem("Decemeber", "12"));
cboMonth.SelectedIndex = DateTime.Now.Month - 1;
int x = 2007;
while (x <= DateTime.Now.Year)
{
cboYear.Items.Add(new ListItem(x.ToString(), x.ToString()));
x++;
}
cboYear.SelectedIndex = cboYear.Items.Count - 1;
#endregion
}
private void LoadList()
{
Terminal clsTerminal = new Terminal();
string SortField = "TerminalNo";
if (Request.QueryString["sortfield"]!=null)
{ SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); }
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"]!=null)
{ sortoption = (SortOption) Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }
string SearchKey = "";
if (Request.QueryString["Search"]!=null)
{ SearchKey = Common.Decrypt((string)Request.QueryString["search"],Session.SessionID); }
PageData.DataSource = clsTerminal.ListAsDataTable(SearchKey, SortField, sortoption).DefaultView;
clsTerminal.CommitAndDispose();
int iPageSize = Convert.ToInt16(Session["PageSize"]) ;
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i=0; i < PageData.PageCount;i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{ cboCurrentPage.Items[i].Selected = true;}
else
{ cboCurrentPage.Items[i].Selected = false;}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
public void GenerateItemsForReorderByRID(Int32 TerminalID, long POID, long RID, DateTime IDC_StartDate, DateTime IDC_EndDate)
{
try
{
GetConnection();
Terminal clsTerminal = new Terminal(base.Connection, base.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(TerminalID);
PODetails clsPODetails = Details(POID);
Products clsProduct = new Products(base.Connection, base.Transaction);
// Aug 26, 2011 :Lemu
// Insert UpdateProductReorderOverStockPerSupplier to update the MinThreshold & MaxThreshold using RID before getting the for stocking
clsProduct.UpdateProductReorderOverStockPerSupplier(clsPODetails.SupplierID, RID, IDC_StartDate, IDC_EndDate);
// end
POItem clsPOItem = new POItem(base.Connection, base.Transaction);
ProductInventories clsProductInventories = new ProductInventories(base.Connection, base.Transaction);
System.Data.DataTable dt = clsProductInventories.ListAsDataTable(BranchID: Constants.BRANCH_ID_MAIN, SupplierID: clsPODetails.SupplierID, ForReorder: 1);
foreach (System.Data.DataRow dr in dt.Rows)
{
if (decimal.Round(Convert.ToDecimal(dr["RIDReorderQty"].ToString())) > 0)
{
POItemDetails clsDetails = new POItemDetails();
clsDetails.POID = POID;
clsDetails.ProductID = Convert.ToInt64(dr["ProductID"].ToString());
clsDetails.ProductCode = dr["ProductCode"].ToString();
clsDetails.BarCode = dr["BarCode"].ToString();
clsDetails.Description = dr["ProductDesc"].ToString();
clsDetails.ProductGroup = dr["ProductGroupCode"].ToString();
clsDetails.ProductSubGroup = dr["ProductSubGroupCode"].ToString();
clsDetails.ProductUnitID = Convert.ToInt32(dr["UnitID"]);
clsDetails.ProductUnitCode = dr["UnitName"].ToString();
clsDetails.RID = Convert.ToInt64(dr["RID"]);
clsDetails.Quantity = decimal.Round(Convert.ToDecimal(dr["RIDReorderQty"]));
clsDetails.UnitCost = Convert.ToDecimal(dr["PurchasePrice"]);
clsDetails.Discount = 0;
clsDetails.DiscountApplied = 0;
clsDetails.DiscountType = DiscountTypes.Percentage;
clsDetails.Remarks = "added using auto generation";
decimal amount = clsDetails.Quantity * clsDetails.UnitCost;
// Added Sep 27, 2010 4:20PM : for selling information
clsDetails.SellingPrice = decimal.Parse(dr["Price"].ToString());
clsDetails.SellingVAT = clsTerminalDetails.VAT;
clsDetails.SellingEVAT = clsTerminalDetails.EVAT;
clsDetails.SellingLocalTax = clsTerminalDetails.LocalTax;
clsDetails.OldSellingPrice = clsDetails.SellingPrice;
if (Convert.ToDecimal(dr["VAT"]) > 0)
{
clsDetails.VatableAmount = amount;
clsDetails.EVatableAmount = amount;
clsDetails.LocalTax = amount;
clsDetails.VatableAmount = (clsDetails.VatableAmount) / (1 + (clsTerminalDetails.VAT / 100));
clsDetails.EVatableAmount = (clsDetails.EVatableAmount) / (1 + (clsTerminalDetails.VAT / 100));
clsDetails.LocalTax = (clsDetails.LocalTax) / (1 + (clsTerminalDetails.LocalTax / 100));
clsDetails.IsVatable = true;
}
else
{
clsDetails.VAT = 0;
clsDetails.VatableAmount = 0;
clsDetails.EVAT = 0;
clsDetails.EVatableAmount = 0;
clsDetails.LocalTax = 0;
clsDetails.IsVatable = false;
}
clsDetails.Amount = amount;
clsDetails.VariationMatrixID = Convert.ToInt64(dr["MatrixID"]);
clsDetails.MatrixDescription = dr["MatrixDescription"].ToString();
clsPOItem.Insert(clsDetails);
}
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
