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;
}
}
}
