private DataTable LoadSalesItem() { var salesItem = new SalesUnitDt(); var dtbSalesItem = salesItem.SelectByNo(txtSTxnNo.Text); dtbSalesItem.PrimaryKey = new[] { dtbSalesItem.Columns["ID"] }; return(dtbSalesItem); }
private void PopulateGrid(string FilterValue) { grdItem.SuspendLayout(); grdItem.AutoGenerateColumns = false; var oSalesUnitDt = new SalesUnitDt(); var tmpDVSalesdt = new DataView(oSalesUnitDt.SelectByNoForCancelItem(_STxnNo.Trim())); tmpDVSalesdt.Sort = "ItemID, ItemFactor, Qty"; tmpDVSalesdt.RowFilter = "ItemID Like '%" + FilterValue.Trim() + "%' Or ItemName Like '%" + FilterValue.Trim() + "%' "; grdItem.DataSource = tmpDVSalesdt; grdItem.ResumeLayout(); oSalesUnitDt.Dispose(); oSalesUnitDt = null; }
private void SaveSalesUnitDt(SqlConnection conn, SqlTransaction trans) { using (var salesDt = new SalesUnitDt()) { salesDt.ID = BussinessRules.ID.GenerateIDNumberWithBeginTransaction("SalesUnitDt", "ID", conn, trans, "SU", " Where ID like 'SU%' "); salesDt.STxnNo = txtSTxnNo.Text.Trim(); salesDt.ItemSeqNo = txtItemID.Text.Trim(); salesDt.UserInsert = _loginInfo.UserID; salesDt.UserUpdate = _loginInfo.UserID; salesDt.ItemUnitID = txtItemUnitID.Text.Trim(); salesDt.ItemFactor = Convert.ToDecimal(txtItemFactor.Text.Trim()); salesDt.Qty = (txtToggleOperator.Text == "-" ? (-1 * Convert.ToDecimal(numQty.Value)) : Convert.ToDecimal(numQty.Value)); salesDt.Price = Convert.ToDecimal(lblUnitPrice.Text.Trim()); salesDt.Disc1Pct = Convert.ToDecimal(1 == 0 ? 0 : 0); salesDt.Disc1Amt = Convert.ToDecimal(lblUnitDisc1.Text.Trim()); salesDt.Disc2Pct = Convert.ToDecimal(0 == 0 ? 0 : 0); salesDt.Disc2Amt = Convert.ToDecimal(lblUnitDisc2.Text.Trim()); salesDt.Disc3Pct = Convert.ToDecimal(0 == 0 ? 0 : 0); salesDt.Disc3Amt = Convert.ToDecimal(0 == 0 ? 0 : 0); salesDt.Description = ""; salesDt.Insert(conn, trans); } }
private bool PopulateItemEntry() //bool isToggleItemUnit = false //, bool isSave = false { bool retval = false; lblItemName.Text = string.Empty; lblItemUnitPrice.Text = String.Format(Program.FormatCurrency, 0); using (var item = new Item()) { string strBarcodeBuah = txtItemID.Text.Trim(); if (Program.Left(strBarcodeBuah, 2) == "22" && strBarcodeBuah.Trim().Length == 13) { txtItemID.Text = Program.Left(strBarcodeBuah, 6); } else { strBarcodeBuah = string.Empty; } if (item.LoadByItemID(txtItemID.Text)) { lblItemName.Text = item.ItemName; txtItemUnitID.Text = (Convert.ToString(cboItemUnit.SelectedValue) == "01" ? item.ItemSUnitID : (Convert.ToString(cboItemUnit.SelectedValue) == "02" ? item.ItemMUnitID : (Convert.ToString(cboItemUnit.SelectedValue) == "03" ? item.ItemLUnitID : ""))); if (strBarcodeBuah.Trim().Length > 0) { cboItemUnit.SelectedValue = "01"; try { if (txtItemUnitID.Text.Trim() == "KG") { numQty.Value = decimal.Parse(strBarcodeBuah.Substring(7, 2) + "." + strBarcodeBuah.Substring(9, 3)); } else { numQty.Value = decimal.Parse(strBarcodeBuah.Substring(7, 5)); } } catch { Program.MsgBox_Show("qty is not valid "); return(false); } //if (item.ItemCategoryID.Trim() != "001" && item.ItemCategoryID.Trim() != "005") //{ // Program.MsgBox_Show("Item Category is not valid "); // return false; //} } //txtItemUnitID.Text = (Convert.ToString(cboItemUnit.SelectedValue) == "01" ? // item.ItemSUnitID : // (Convert.ToString(cboItemUnit.SelectedValue) == "02" ? // item.ItemMUnitID : // (Convert.ToString(cboItemUnit.SelectedValue) == "03" ? // item.ItemLUnitID : ""))); //if (txtItemUnitID.Text.Trim() == item.ItemMUnitID) //isToggleItemUnit == false //{ SearchItemFactor(item.ItemSeqNo, txtItemUnitID.Text.Trim()); //} using (var salesDt = new SalesUnitDt()) { DataTable dtbPriceDOorSalesItem = salesDt.SelectGetPriceItemDOorSales("FO", item.ItemSeqNo.Trim(), txtItemUnitID.Text.Trim(), Convert.ToDecimal(txtItemFactor.Text.Trim()), Convert.ToDecimal(txtCurrencyRate.Text.Trim()), txtMemberID.Text.Trim(), txtSTxnNo.Text.Trim(), numQty.Value); dtbPriceDOorSalesItem.PrimaryKey = new[] { dtbPriceDOorSalesItem.Columns["ItemSeqNo"] }; lblUnitPrice.Text = string.Format(Program.FormatCurrency, dtbPriceDOorSalesItem.Rows[0]["UnitPrice"]); lblUnitDisc1.Text = string.Format(Program.FormatCurrency, Convert.ToDecimal(dtbPriceDOorSalesItem.Rows[0]["Disc1Amt"])); lblUnitDisc2.Text = string.Format(Program.FormatCurrency, Convert.ToDecimal(dtbPriceDOorSalesItem.Rows[0]["Disc2Amt"])); lblUnitDisc.Text = string.Format(Program.FormatCurrency, Convert.ToDecimal(dtbPriceDOorSalesItem.Rows[0]["Disc1Amt"]) + Convert.ToDecimal(dtbPriceDOorSalesItem.Rows[0]["Disc2Amt"])); lblItemUnitPrice.Text = string.Format(Program.FormatCurrency, numQty.Value * ( Convert.ToDecimal(dtbPriceDOorSalesItem.Rows[0]["UnitPrice"]) - Convert.ToDecimal(dtbPriceDOorSalesItem.Rows[0]["Disc1Amt"]) - Convert.ToDecimal(dtbPriceDOorSalesItem.Rows[0]["Disc2Amt"]) ) ); dtbPriceDOorSalesItem.Dispose(); dtbPriceDOorSalesItem = null; } //var strprintname = item.PrintName.Substring(0, 19); retval = true; } else { //if (txtItemID.Text != string.Empty) //{ txtItemID.Text = string.Empty; numQty.Value = 1; lblItemUnitPrice.Text = String.Format(Program.FormatCurrency, 0); //} txtItemUnitID.Text = string.Empty; txtItemFactor.Text = string.Format(Program.FormatCurrency, 1); lblUnitPrice.Text = string.Format(Program.FormatCurrency, 0); lblUnitDisc1.Text = string.Format(Program.FormatCurrency, 0); lblUnitDisc2.Text = string.Format(Program.FormatCurrency, 0); lblUnitDisc.Text = string.Format(Program.FormatCurrency, 0); retval = false; } } txtItemID.Focus(); return(retval); }
private bool PopulateItemEntry() { bool retval = false; string strItemSeqNo = string.Empty; string strItemID = string.Empty; lblItemName.Text = string.Empty; using (var item = new Item()) { string strBarcodeBuah = txtItemID.Text.Trim(); if (strBarcodeBuah.Length > 1) { if (Program.Left(strBarcodeBuah, 2) == "22" && strBarcodeBuah.Trim().Length == 13) { txtItemID.Text = Program.Left(strBarcodeBuah, 6); } else { strBarcodeBuah = string.Empty; } } if (item.LoadByItemID(txtItemID.Text)) { strItemSeqNo = item.ItemSeqNo.Trim(); lblItemName.Text = item.ItemName; strItemID = item.ItemID.Trim(); retval = true; } else { ClearItemEntry(); strItemSeqNo = string.Empty; strItemID = string.Empty; lblItemName.Text = "Item not found. Please try again."; retval = false; } } using (var salesDt = new SalesUnitDt()) { DataTable dtbPriceSalesItem = salesDt.SelectGetPriceItemSalesFOAllByItemSeqNo(strItemSeqNo); dtbPriceSalesItem.PrimaryKey = new[] { dtbPriceSalesItem.Columns["ItemUnitID"] }; grdItemPrice.AutoGenerateColumns = false; grdItemPrice.DataSource = dtbPriceSalesItem; grdItemPrice.ResumeLayout(); dtbPriceSalesItem.Dispose(); dtbPriceSalesItem = null; } var oPromotion = new PromotionHd(); var dv = new DataView(oPromotion.SelectInformationPromotion(Convert.ToDateTime("2011-01-01"), DateTime.Today.Date)); dv.RowFilter = "ItemID = '" + strItemID.Trim() + "'"; dtgPromotion.AutoGenerateColumns = false; dtgPromotion.DataSource = dv; dtgPromotion.ResumeLayout(); dv = null; oPromotion.Dispose(); oPromotion = null; var oitemphoto = new ItemPhoto(); oitemphoto.ItemSeqNo = strItemSeqNo.Trim(); if (oitemphoto.SelectByItemSeqNo().Rows.Count > 0) { Byte[] byteBLOBData = new Byte[0]; byteBLOBData = (Byte[])(oitemphoto.ItemPhoto); MemoryStream stmBLOBData = new MemoryStream(byteBLOBData); picBoxItem.Image = Image.FromStream(stmBLOBData); //Byte[] msdt = (Byte[])(oitemphoto.ItemPhoto); //MemoryStream ms = new MemoryStream(msdt); //ms.Write(msdt, 0, msdt.Length); //ms.Position = 0; //ms.Seek(0, SeekOrigin.Begin); //picBoxItem.Image = Image.FromStream(ms); //Byte[] msdt = (Byte[])(oitemphoto.ItemPhoto); //MemoryStream ms = new MemoryStream(msdt); //Image img = new System.Drawing.Bitmap(ms); //picBoxItem.Image = img; } else { picBoxItem.Image = null; } oitemphoto.Dispose(); oitemphoto = null; txtItemID.Text = string.Empty; txtItemID.Focus(); return(retval); }
private void SelectItem() { if (grdItem.RowCount > 0) { if (Program.MsgBox_Show("Are you sure want to cancel this Item ? ", "Confirmation", "YesNo")) { var oSalesUnitDt = new SalesUnitDt(); oSalesUnitDt.ID = grdItem.SelectedRows[0].Cells["SalesDtID"].Value.ToString(); if (oSalesUnitDt.SelectOne().Rows.Count > 0) { var conn = new SqlConnection(HisConfiguration.ConnectionString); SqlTransaction trans = null; try { conn.Open(); trans = conn.BeginTransaction(); oSalesUnitDt.ID = BussinessRules.ID.GenerateIDNumberWithBeginTransaction("SalesUnitDt", "ID", conn, trans, "SU"); oSalesUnitDt.ItemSeqNo = grdItem.SelectedRows[0].Cells["ItemID"].Value.ToString(); oSalesUnitDt.Qty = -(oSalesUnitDt.Qty); oSalesUnitDt.UserInsert = _UserID; oSalesUnitDt.UserUpdate = _UserID; oSalesUnitDt.Insert(conn, trans); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); trans.Dispose(); } MessageBox.Show(ex.Message); } finally { if (trans != null) { trans.Dispose(); } conn.Close(); conn.Dispose(); } _retval = true; Close(); //oSalesUnitDt.ID = BussinessRules.ID.GenerateIDNumber("SalesUnitDt", "ID", "SU"); //oSalesUnitDt.ItemSeqNo = grdItem.SelectedRows[0].Cells["ItemID"].Value.ToString(); //oSalesUnitDt.Qty = -(oSalesUnitDt.Qty); //oSalesUnitDt.UserInsert = _UserID; //oSalesUnitDt.UserUpdate = _UserID; //oSalesUnitDt.Insert(); //_retval = true; //Close(); } else { Program.MsgBox_Show("Item is not found, please select another item"); PopulateGrid(txtSearch.Text.Trim()); } oSalesUnitDt.Dispose(); oSalesUnitDt = null; } } }