private void SelectItem()
{
ListView.SelectedListViewItemCollection items = this.lstItems.SelectedItems;
foreach (ListViewItem item in items)
{
mDetails.VariationsMatrixID = Convert.ToInt64(item.SubItems[0].Name); break;
}
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
ProductBaseVariationsMatrixDetails clsDetails = new ProductBaseVariationsMatrixDetails(); // clsProductVariationsMatrix.BaseDetailsByMatrixID(mDetails.VariationsMatrixID);
clsProductVariationsMatrix.CommitAndDispose();
if (mDetails.VariationsMatrixID != 0)
{
mDetails.MatrixDescription = clsDetails.Description;
mDetails.ProductUnitID = clsDetails.UnitID;
mDetails.ProductUnitCode = clsDetails.UnitCode;
mDetails.Price = clsDetails.Price;
mDetails.VAT = clsDetails.VAT;
mDetails.LocalTax = clsDetails.LocalTax;
mDetails.Amount = (mDetails.Quantity * mDetails.Price) - (mDetails.Quantity * mDetails.Discount);
mDetails.PurchasePrice = clsDetails.PurchasePrice;
mDetails.PurchaseAmount = mDetails.Quantity * mDetails.PurchasePrice;
mDetails.IncludeInSubtotalDiscount = clsDetails.IncludeInSubtotalDiscount;
}
dialog = DialogResult.OK;
this.Hide();
}
private void LoadList()
{
string SortField = "prd.Description";
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 stSearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{
stSearchKey = Server.UrlDecode(Common.Decrypt((string)Request.QueryString["search"], Session.SessionID));
}
else if (Session["Search"] != null)
{
stSearchKey = Server.UrlDecode(Common.Decrypt(Session["Search"].ToString(), Session.SessionID));
}
try { Session.Remove("Search"); }
catch { }
if (stSearchKey == null)
{
stSearchKey = string.Empty;
}
else if (stSearchKey != string.Empty)
{
Session.Add("Search", Common.Encrypt(stSearchKey, Session.SessionID));
}
ProductBaseVariationsMatrixDetails clsSearchKeys = new ProductBaseVariationsMatrixDetails();
clsSearchKeys.Description = stSearchKey;
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
System.Data.DataTable dt = clsProductVariationsMatrix.BaseListAsDataTable(Int64.Parse(lblProductID.Text), Int32.Parse(Session["BranchID"].ToString()), MatrixDescription: stSearchKey, SortField: SortField, SortOrder: sortoption);
clsProductVariationsMatrix.CommitAndDispose();
PageData.DataSource = dt.DefaultView;
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;
}
private bool SaveRecord()
{
foreach (DataListItem item in lstItem.Items)
{
HyperLink lnkVariationType = (HyperLink)item.FindControl("lnkVariationType");
if (lnkVariationType.Text.ToUpper() == CONSTANT_VARIATIONS.EXPIRATION.ToString("G"))
{
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
try
{
DateTime Expiry = DateTime.Parse(txtDescription.Text);
}
catch {
string javaScript = "window.alert('Please enter a valid expiration date in YYYY-MM-DD format');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return(false);
}
}
}
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
ProductVariationsMatrixDetails clsDetails = new ProductVariationsMatrixDetails();
string stringVariationDesc = null;
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
clsDetails = new ProductVariationsMatrixDetails();
clsDetails.MatrixID = Convert.ToInt32(lblMatrixID.Text);
clsDetails.ProductID = Convert.ToInt32(lblProductID.Text);
clsDetails.VariationID = Convert.ToInt32(chkList.Value);
clsDetails.Description = txtDescription.Text;
clsProductVariationsMatrix.SaveVariation(clsDetails);
Label lblVariationType = (Label)item.FindControl("lblVariationType");
//stringVariationDesc += lblVariationType.Text + ":" + txtDescription.Text + "; ";
stringVariationDesc += txtDescription.Text + "; ";
}
//update base variation matrix
ProductDetails clsProductDetails = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction).Details(Int64.Parse(lblProductID.Text));
ProductBaseVariationsMatrixDetails clsBaseDetails = new ProductBaseVariationsMatrixDetails();
clsBaseDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsBaseDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsBaseDetails.BarCode1 = txtBarcode.Text;
clsBaseDetails.BarCode2 = txtBarcode2.Text;
clsBaseDetails.BarCode3 = txtBarcode3.Text;
clsBaseDetails.Description = stringVariationDesc;
clsBaseDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsBaseDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsBaseDetails.Price1 = Convert.ToDecimal(txtPrice1.Text);
clsBaseDetails.Price2 = Convert.ToDecimal(txtPrice2.Text);
clsBaseDetails.Price3 = Convert.ToDecimal(txtPrice3.Text);
clsBaseDetails.Price4 = Convert.ToDecimal(txtPrice4.Text);
clsBaseDetails.Price5 = Convert.ToDecimal(txtPrice5.Text);
clsBaseDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsBaseDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsBaseDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsBaseDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsBaseDetails.MinThreshold = Convert.ToDecimal(txtMinThreshold.Text);
clsBaseDetails.MaxThreshold = Convert.ToDecimal(txtMaxThreshold.Text);
clsBaseDetails.SupplierID = clsProductDetails.SupplierID;
clsBaseDetails.UpdatedBy = Convert.ToInt64(Session["UID"].ToString());
clsBaseDetails.UpdatedOn = DateTime.Now;
clsProductVariationsMatrix.UpdateBaseVariation(clsBaseDetails);
clsProductVariationsMatrix.CommitAndDispose();
return(true);
}
