public void UpdateReceiveStatus(long TransferOutItemID, TransferOutItemReceivedStatus TransferOutItemReceivedStatus, decimal ReceivedQuantity)
{
try
{
string SQL = "UPDATE tblTransferOutItems SET " +
"TransferOutItemReceivedStatus = @TransferOutItemReceivedStatus, " +
"OriginalQuantity = Quantity, " +
"Quantity = @ReceivedQuantity " +
"WHERE TransferOutItemID = @TransferOutItemID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmTransferOutItemReceivedStatus = new MySqlParameter("@TransferOutItemReceivedStatus", MySqlDbType.Int16);
prmTransferOutItemReceivedStatus.Value = TransferOutItemReceivedStatus.ToString("d");
cmd.Parameters.Add(prmTransferOutItemReceivedStatus);
MySqlParameter prmReceivedQuantity = new MySqlParameter("@ReceivedQuantity", MySqlDbType.Decimal);
prmReceivedQuantity.Value = ReceivedQuantity;
cmd.Parameters.Add(prmReceivedQuantity);
MySqlParameter prmTransferOutItemID = new MySqlParameter("@TransferOutItemID", MySqlDbType.Int64);
prmTransferOutItemID.Value = TransferOutItemID;
cmd.Parameters.Add(prmTransferOutItemID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void lstItemFixCssClass()
{
foreach (DataListItem item in lstItem.Items)
{
Label lblitemTransferOutItemReceivedStatus = (Label)item.FindControl("lblTransferOutItemReceivedStatus");
TransferOutItemReceivedStatus itemTransferOutItemReceivedStatus = (TransferOutItemReceivedStatus)Enum.Parse(typeof(TransferOutItemReceivedStatus), lblitemTransferOutItemReceivedStatus.Text);
if (itemTransferOutItemReceivedStatus == TransferOutItemReceivedStatus.Received)
{
item.CssClass = "ms-item-received-det";
}
else if (item.ItemType == ListItemType.Item)
{
item.CssClass = "";
}
else if (item.ItemType == ListItemType.AlternatingItem)
{
item.CssClass = "ms-alternating";
}
}
}
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["TransferOutItemID"].ToString();
HyperLink lnkDescription = (HyperLink)e.Item.FindControl("lnkDescription");
lnkDescription.Text = dr["Description"].ToString();
lnkDescription.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/Default.aspx?task=" + Common.Encrypt("det", Session.SessionID) + "&id=" + Common.Encrypt(dr["ProductID"].ToString(), Session.SessionID);
HyperLink lnkMatrixDescription = (HyperLink)e.Item.FindControl("lnkMatrixDescription");
if (dr["MatrixDescription"].ToString() == string.Empty || dr["MatrixDescription"].ToString() == null)
{
lnkMatrixDescription.Text = "_";
}
else
{
lnkMatrixDescription.Text = dr["MatrixDescription"].ToString();
lnkMatrixDescription.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx?task=" + Common.Encrypt("det", Session.SessionID) + "&prodid=" + Common.Encrypt(dr["ProductID"].ToString(), Session.SessionID) + "&id=" + Common.Encrypt(dr["VariationMatrixID"].ToString(), Session.SessionID);
}
Label lblQuantity = (Label)e.Item.FindControl("lblQuantity");
lblQuantity.Text = Convert.ToDecimal(dr["Quantity"].ToString()).ToString("#,##0.#0");
Label lblProductUnitID = (Label)e.Item.FindControl("lblProductUnitID");
lblProductUnitID.Text = dr["ProductUnitID"].ToString();
Label lblProductUnitCode = (Label)e.Item.FindControl("lblProductUnitCode");
lblProductUnitCode.Text = dr["ProductUnitCode"].ToString();
Label lblUnitCost = (Label)e.Item.FindControl("lblUnitCost");
lblUnitCost.Text = Convert.ToDecimal(dr["UnitCost"].ToString()).ToString("#,##0.#0");
Label lblDiscountApplied = (Label)e.Item.FindControl("lblDiscountApplied");
lblDiscountApplied.Text = Convert.ToDecimal(dr["DiscountApplied"].ToString()).ToString("#,##0.#0");
DiscountTypes DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), dr["DiscountType"].ToString());
if (DiscountType == DiscountTypes.Percentage)
{
Label lblPercent = (Label)e.Item.FindControl("lblPercent");
lblPercent.Visible = true;
}
Label lblAmount = (Label)e.Item.FindControl("lblAmount");
lblAmount.Text = Convert.ToDecimal(dr["Amount"].ToString()).ToString("#,##0.#0");
Label lblVAT = (Label)e.Item.FindControl("lblVAT");
lblVAT.Text = Convert.ToDecimal(dr["VAT"].ToString()).ToString("#,##0.#0");
Label lblEVAT = (Label)e.Item.FindControl("lblEVAT");
lblEVAT.Text = Convert.ToDecimal(dr["EVAT"].ToString()).ToString("#,##0.#0");
Label lblisVATInclusive = (Label)e.Item.FindControl("lblisVATInclusive");
lblisVATInclusive.Text = Convert.ToBoolean(Convert.ToInt16(dr["isVATInclusive"].ToString())).ToString();
Label lblLocalTax = (Label)e.Item.FindControl("lblLocalTax");
lblLocalTax.Text = Convert.ToDecimal(dr["LocalTax"].ToString()).ToString("#,##0.#0");
Label lblRemarks = (Label)e.Item.FindControl("lblRemarks");
lblRemarks.Text = dr["Remarks"].ToString();
Label lblTransferOutItemReceivedStatus = (Label)e.Item.FindControl("lblTransferOutItemReceivedStatus");
TransferOutItemReceivedStatus clsTransferOutItemReceivedStatus = (TransferOutItemReceivedStatus)Enum.Parse(typeof(TransferOutItemReceivedStatus), dr["TransferOutItemReceivedStatus"].ToString());
lblTransferOutItemReceivedStatus.Text = clsTransferOutItemReceivedStatus.ToString("d");
//For anchor
HtmlGenericControl divExpCollAsst = (HtmlGenericControl)e.Item.FindControl("divExpCollAsst");
HtmlAnchor anchorDown = (HtmlAnchor)e.Item.FindControl("anchorDown");
anchorDown.HRef = "javascript:ToggleDiv('" + divExpCollAsst.ClientID + "')";
}
}
public void UpdateReceiveStatus(long TransferOutItemID, TransferOutItemReceivedStatus TransferOutItemReceivedStatus, decimal ReceivedQuantity)
{
try
{
string SQL = "UPDATE tblTransferOutItems SET " +
"TransferOutItemReceivedStatus = @TransferOutItemReceivedStatus, " +
"OriginalQuantity = Quantity, " +
"Quantity = @ReceivedQuantity " +
"WHERE TransferOutItemID = @TransferOutItemID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmTransferOutItemReceivedStatus = new MySqlParameter("@TransferOutItemReceivedStatus",MySqlDbType.Int16);
prmTransferOutItemReceivedStatus.Value = TransferOutItemReceivedStatus.ToString("d");
cmd.Parameters.Add(prmTransferOutItemReceivedStatus);
MySqlParameter prmReceivedQuantity = new MySqlParameter("@ReceivedQuantity",MySqlDbType.Decimal);
prmReceivedQuantity.Value = ReceivedQuantity;
cmd.Parameters.Add(prmReceivedQuantity);
MySqlParameter prmTransferOutItemID = new MySqlParameter("@TransferOutItemID",MySqlDbType.Int64);
prmTransferOutItemID.Value = TransferOutItemID;
cmd.Parameters.Add(prmTransferOutItemID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void UpdateItemReceiveStatus(long TransferOutItemID, TransferOutItemReceivedStatus clsTransferOutItemReceivedStatus, decimal ReceivedQuantity)
{
TransferOutItem clsTransferOutItem = new TransferOutItem();
clsTransferOutItem.UpdateReceiveStatus(TransferOutItemID, clsTransferOutItemReceivedStatus, ReceivedQuantity);
clsTransferOutItem.CommitAndDispose();
}
