private void LoadList()
{
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)); }
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
System.Data.DataTable dt = clsProductVariationsMatrix.BaseListAsDataTable(Int64.Parse(lblProductID.Text), MatrixDescription: stSearchKey);
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 void lstItem_ItemDataBound(object sender, DataListItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView dr = (DataRowView) e.Item.DataItem;
HtmlInputCheckBox chkList = (HtmlInputCheckBox) e.Item.FindControl("chkList");
chkList.Value = dr["VariationID"].ToString();
Label lblVariationType = (Label) e.Item.FindControl("lblVariationType");
lblVariationType.Text = dr["VariationType"].ToString();
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
TextBox txtDescription = (TextBox) e.Item.FindControl("txtDescription");
txtDescription.Text = clsProductVariationsMatrix.Details(Convert.ToInt32(lblMatrixID.Text), Convert.ToInt32(chkList.Value)).Description;
clsProductVariationsMatrix.CommitAndDispose();
}
}
private void LoadItemData()
{
try
{
DataClass clsData = new DataClass();
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
System.Data.DataTable dt = clsData.DataReaderToDataTable(clsProductVariationsMatrix.Search(mDetails.ProductID, "", "a.Description", SortOption.Ascending, 100, mboShowItemMoreThanZeroQty));
clsProductVariationsMatrix.CommitAndDispose();
lstItems.Items.Clear(); int iImgCtr = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (mboIsPriceInq)
lstItems.Items.Add(dr["MatriXID"].ToString(), "[" + dr["Price"].ToString() + "]" + Environment.NewLine + dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["Description"].ToString(), iImgCtr);
else
lstItems.Items.Add(dr["MatriXID"].ToString(), dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["Description"].ToString(), iImgCtr);
if (iImgCtr == 7) iImgCtr = 0; else iImgCtr++;
}
try { lstItems.Items[0].Selected = true; }
catch { }
}
catch (Exception ex)
{
if (ex.Message.ToLower() != "index was outside the bounds of the array.")
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
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();
}
protected void cboProducts_SelectedIndexChanged(object sender, System.EventArgs e)
{
long ProductID = Convert.ToInt64(cboProducts.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboProductVariation.DataTextField = "VariationDesc";
cboProductVariation.DataValueField = "MatrixID";
cboProductVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboProductVariation.DataBind();
cboProductVariation.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboProductVariation.SelectedIndex = 0;
clsProductVariationsMatrix.CommitAndDispose();
}
protected void imgVariationQuickAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
long.Parse(cboProductCode.SelectedItem.Value);
if (txtVariation.Text != null || txtVariation.Text.Trim() != string.Empty || txtVariation.Text.Trim() != "")
{
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
clsProductVariationsMatrix.InsertBaseVariationEasy(long.Parse(cboProductCode.SelectedItem.Value), txtVariation.Text, clsAccessUserDetails.Name);
clsProductVariationsMatrix.CommitAndDispose();
cmdVariationSearch_Click(null, null);
}
}
catch { }
}
protected void cmdVariationSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string stSearchKey = txtVariation.Text.ToString();
if (txtVariation.Text == null) stSearchKey = "";
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "Description";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsDataClass.DataReaderToDataTable(clsProductVariationsMatrix.Search(ProductID, stSearchKey, "VariationDesc",SortOption.Ascending)).DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
clsProductVariationsMatrix.CommitAndDispose();
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
return;
if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING)
return;
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{ cboVariation.Items.Add(new ListItem("No Variation", "0")); }
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID, MatrixID: Int64.Parse(cboVariation.SelectedItem.Value));
clsProductVariationsMatrix.CommitAndDispose();
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrevPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0");
txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0");
if (clsDetails.VAT >0)
chkIsTaxable.Checked = true;
else
chkIsTaxable.Checked = false;
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
return;
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{ cboVariation.Items.Add(new ListItem("No Variation", "0"));}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID);
clsProductVariationsMatrix.CommitAndDispose();
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrice.Text = clsDetails.WSPrice.ToString("#####0.#0");
txtSellingPrice.Text = clsDetails.Price.ToString("#####0.#0");
decimal decMargin = clsDetails.Price - clsDetails.WSPrice;
try { decMargin = decMargin / clsDetails.WSPrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
if (clsDetails.VAT > 0)
chkIsTaxable.Checked = true;
else
chkIsTaxable.Checked = false;
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
//if (ProductID != 0)
//{
// lnkVariationAdd.Visible = true;
// string stParam = "?task=" + Common.Encrypt("add", Session.SessionID) +
// "&prodid=" + Common.Encrypt(ProductID.ToString(), Session.SessionID);
// lnkVariationAdd.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam;
//}
//else { lnkVariationAdd.Visible = false; }
}
private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach(DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList");
if (chkList!=null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
// Aug 1, 2011 : Lemu
// Remove the entire code and replaced with the code below to cater InventoryAdjustment and ProductMovement
// See _Product/_variationsMatrix/_List.cs.Delete
//
// ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
// clsProductVariationsMatrix.Delete(stIDs.Substring(0,stIDs.Length-1));
// clsProductVariationsMatrix.SynchronizeQuantity(Convert.ToInt64(lblProductID.Text));
// clsProductVariationsMatrix.CommitAndDispose();
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
clsProductVariationsMatrix.GetConnection();
Products clsProducts = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
long ProductID = Int64.Parse(lblProductID.Text);
string[] strIDs = stIDs.Substring(0, stIDs.Length - 1).Split(',');
foreach (string ID in strIDs)
{
long MatrixID = long.Parse(ID);
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
InvAdjustmentDetails clsInvAdjustmentDetails = new InvAdjustmentDetails();
clsInvAdjustmentDetails.UID = clsAccessUserDetails.UID;
clsInvAdjustmentDetails.InvAdjustmentDate = DateTime.Now;
clsInvAdjustmentDetails.ProductID = clsDetails.ProductID;
clsInvAdjustmentDetails.ProductCode = clsDetails.ProductCode;
clsInvAdjustmentDetails.Description = clsDetails.ProductDesc;
clsInvAdjustmentDetails.VariationMatrixID = clsDetails.MatrixID;
clsInvAdjustmentDetails.MatrixDescription = clsDetails.MatrixDescription;
clsInvAdjustmentDetails.UnitID = clsDetails.BaseUnitID;
clsInvAdjustmentDetails.UnitCode = clsDetails.BaseUnitCode;
clsInvAdjustmentDetails.QuantityBefore = clsDetails.Quantity;
clsInvAdjustmentDetails.QuantityNow = 0;
clsInvAdjustmentDetails.MinThresholdBefore = clsDetails.MinThreshold;
clsInvAdjustmentDetails.MinThresholdNow = 0;
clsInvAdjustmentDetails.MaxThresholdBefore = clsDetails.MaxThreshold;
clsInvAdjustmentDetails.MaxThresholdNow = 0;
clsInvAdjustmentDetails.Remarks = "deleted item.";
InvAdjustment clsInvAdjustment = new InvAdjustment(clsProducts.Connection, clsProducts.Transaction);
clsInvAdjustment.Insert(clsInvAdjustmentDetails);
clsProducts.SubtractQuantity(Constants.BRANCH_ID_MAIN, clsDetails.ProductID, clsDetails.MatrixID, clsDetails.Quantity, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_PRODUCT_VARIATION_DELETE) + " : " + clsDetails.MatrixDescription, clsInvAdjustmentDetails.InvAdjustmentDate, "SYS-VARDEL" + clsInvAdjustmentDetails.InvAdjustmentDate.ToString("yyyyMMddHHmmss"), clsAccessUserDetails.Name);
clsProductVariationsMatrix.Delete(long.Parse(ID));
}
clsProductVariationsMatrix.CommitAndDispose();
}
return boRetValue;
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
return;
if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING)
return;
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{ cboVariation.Items.Add(new ListItem("No Variation", Constants.ZERO_STRING)); }
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
ProductDetails clsDetails = clsProduct.Details(ProductID);
ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
System.Data.DataTable dtProductPurchasePriceHistory = clsProductPurchasePriceHistory.ListAsDataTable(ProductID, DateTime.Now.AddMonths(-6), "PurchasePrice", SortOption.Ascending);
clsProductVariationsMatrix.CommitAndDispose();
string strPurchasePriceHistory = string.Empty;
foreach (System.Data.DataRow dr in dtProductPurchasePriceHistory.Rows)
{
DateTime dtePurchaseDate = DateTime.Parse(dr["PurchaseDate"].ToString());
decimal decPurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString());
long lngSupplierID = long.Parse(dr["SupplierID"].ToString());
string strSupplierName = "" + dr["SupplierName"].ToString();
if (lngSupplierID == long.Parse(lblSupplierID.Text))
clsDetails.PurchasePrice = decPurchasePrice;
strPurchasePriceHistory += dtePurchaseDate.ToString("ddMMMyyyy HH:mm") + ": " + decPurchasePrice.ToString("#,##0.##0").PadLeft(10) + " " + strSupplierName + "\r\n<br />" + Environment.NewLine;
}
lblPurchasePriceHistory.Text = "<br />" + strPurchasePriceHistory;
cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.##0");
txtSellingPrice.Text = clsDetails.Price.ToString("#####0.##0");
txtOldSellingPrice.Text = clsDetails.Price.ToString("#####0.##0");
decimal decMargin = clsDetails.Price - clsDetails.PurchasePrice;
try { decMargin = decMargin / clsDetails.PurchasePrice; }
catch { decMargin = 1; }
decMargin = decMargin * 100;
txtMargin.Text = decMargin.ToString("#,##0.##0");
txtVAT.Text = clsDetails.VAT.ToString("#,##0.##0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.##0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.##0");
if (clsDetails.VAT > 0) chkIsTaxable.Checked = true;
else chkIsTaxable.Checked = false;
if (cboProductUnit.Items.Count == 0)
{ cboProductUnit.Items.Add(new ListItem("No Unit", "0")); }
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
ComputeItemAmount();
cboVariation_SelectedIndexChanged(null, null);
lstItemFixCssClass();
}
protected void imgVariationQuickAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtVariation.Text))
{
DateTime dteExpiration = Constants.C_DATE_MIN_VALUE;
string LotNo = "";
if (Session[Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE].ToString() == Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE_EXPIRATION_LOTNO)
{
string javaScript = "";
string[] variation = txtVariation.Text.Split(';');
if (!DateTime.TryParse(variation[0], out dteExpiration))
{
javaScript = "window.alert('Please enter a valid expiration date in YYYY-MM-DD format. Variation format must be: EXPIRATION;LOTNO');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updPrint, this.updPrint.GetType(), "openwindow", javaScript, true);
return;
}
if (variation.Length == 1)
{
javaScript = "window.alert('Please enter a valid LOTNO, it must not be blank. If there is no LOTNO please enter NA.');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updPrint, this.updPrint.GetType(), "openwindow", javaScript, true);
return;
}
LotNo = variation[1];
if (string.IsNullOrEmpty(LotNo))
{
javaScript = "window.alert('Please enter a valid LOTNO, it must not be blank. If there is no LOTNO please enter NA.');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updPrint, this.updPrint.GetType(), "openwindow", javaScript, true);
return;
}
}
long lngProdductID = long.Parse(cboProductCode.SelectedItem.Value);
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
long lngMatrixID = clsProductVariationsMatrix.InsertBaseVariationEasy(long.Parse(cboProductCode.SelectedItem.Value), txtVariation.Text, clsAccessUserDetails.Name);
if (Session[Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE].ToString() == Constants.SYS_CONFIG_BACKEND_VARIATION_TYPE_EXPIRATION_LOTNO)
{
ProductVariationsMatrixDetails clsDetails;
clsDetails = new ProductVariationsMatrixDetails();
clsDetails.MatrixID = lngMatrixID;
clsDetails.ProductID = lngProdductID;
// save the expiration
clsDetails.VariationID = long.Parse(CONSTANT_VARIATIONS.EXPIRATION.ToString("d"));
clsDetails.Description = dteExpiration.ToString("yyyy-MM-dd");
clsProductVariationsMatrix.SaveVariation(clsDetails);
// save the lotno
clsDetails.VariationID = long.Parse(CONSTANT_VARIATIONS.LOTNO.ToString("d"));
clsDetails.Description = LotNo;
clsProductVariationsMatrix.SaveVariation(clsDetails);
}
clsProductVariationsMatrix.CommitAndDispose();
cmdVariationSearch_Click(null, null);
}
}
catch{}
}
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;
}
}
}
string stringVariationDesc = null;
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
stringVariationDesc += txtDescription.Text + "; ";
}
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductBaseVariationsMatrixDetails clsBaseDetails = new ProductBaseVariationsMatrixDetails();
ProductVariationsMatrixDetails clsDetails;
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
ProductDetails clsProductDetails = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction).Details(Int64.Parse(lblProductID.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.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsBaseDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsBaseDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsBaseDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsBaseDetails.MinThreshold = Convert.ToDecimal(txtMinThreshold.Text);
clsBaseDetails.MaxThreshold = Convert.ToDecimal(txtMaxThreshold.Text);
clsBaseDetails.SupplierID = clsProductDetails.SupplierID;
clsBaseDetails.CreatedBy = clsAccessUserDetails.Name;
clsBaseDetails.MatrixID = clsProductVariationsMatrix.InsertBaseVariation(clsBaseDetails);
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList");
TextBox txtDescription = (TextBox) item.FindControl("txtDescription");
clsDetails = new ProductVariationsMatrixDetails();
clsDetails.MatrixID = clsBaseDetails.MatrixID;
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.VariationID = Convert.ToInt32(chkList.Value);
clsDetails.Description = txtDescription.Text;
clsProductVariationsMatrix.SaveVariation(clsDetails);
}
clsProductVariationsMatrix.CommitAndDispose();
return true;
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
return;
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
if (ProductID == 0) {
cboVariation.Items.Clear();
cboVariation.Items.Add(new ListItem("No Variation", "0"));
return;
}
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "VariationDesc";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
clsProductVariationsMatrix.CommitAndDispose();
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
clsUnitMatrix.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
clsDetails = clsProduct.Details(ProductID);
clsProduct.CommitAndDispose();
cboProductUnit.Items.Add( new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1;
cboVariation_SelectedIndexChanged(null, null);
}
private void LoadItemData()
{
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
try
{
string searchkey = "" + txtSearch.Text;
DataClass clsData = new DataClass();
System.Data.DataTable dt =
clsData.DataReaderToDataTable(clsProductVariationsMatrix.Search(mDetails.ProductID,searchkey,"a.Description",SortOption.Ascending, 100, mboShowItemMoreThanZeroQty));
clsProductVariationsMatrix.CommitAndDispose();
//dt.TableName = "tblProductVariationsMatrix";
this.dgStyle.MappingName = dt.TableName;
dgItems.DataSource = dt;
dgItems.Select(0);
dgItems.CurrentRowIndex=0;
}
catch (Exception ex)
{
clsProductVariationsMatrix.CommitAndDispose();
if (ex.Message.ToLower() != "index was outside the bounds of the array.")
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
protected void lstItem_ItemDataBound(object sender, DataListItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView dr = (DataRowView) e.Item.DataItem;
HtmlInputCheckBox chkList = (HtmlInputCheckBox) e.Item.FindControl("chkList");
chkList.Value = dr["VariationID"].ToString();
HyperLink lnkVariationType = (HyperLink)e.Item.FindControl("lnkVariationType");
lnkVariationType.Text = dr["VariationType"].ToString(); //VariationID
lnkVariationType.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Variation/Default.aspx?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(dr["VariationID"].ToString(), Session.SessionID);
TextBox txtDescription = (TextBox)e.Item.FindControl("txtDescription");
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
txtDescription.Text = clsProductVariationsMatrix.Details(Convert.ToInt64(lblMatrixID.Text), Convert.ToInt32(chkList.Value)).Description;
clsProductVariationsMatrix.CommitAndDispose();
}
}
