private void lstPO_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["POID"].ToString();
POPaymentStatus POPaymentStatus = (POPaymentStatus)Enum.Parse(typeof(POPaymentStatus), dr["PaymentStatus"].ToString());
if (POPaymentStatus == POPaymentStatus.ForProcessing || POPaymentStatus == POPaymentStatus.Partially)
{
chkList.Attributes.Add("checked", "checked");
}
HyperLink lnkPONo = (HyperLink)e.Item.FindControl("lnkPONo");
lnkPONo.Text = dr["PONo"].ToString();
Common Common = new Common();
string stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&poid=" + Common.Encrypt(chkList.Value.ToString(), Session.SessionID);
lnkPONo.NavigateUrl = AceSoft.RetailPlus.Constants.ROOT_DIRECTORY + "/PurchasesAndPayables/_PO/Default.aspx" + stParam;
Label lblPODate = (Label)e.Item.FindControl("lblPODate");
lblPODate.Text = Convert.ToDateTime(dr["PODate"].ToString()).ToString("MM-dd-yyyy");
Label lblDeliveryDate = (Label)e.Item.FindControl("lblDeliveryDate");
lblDeliveryDate.Text = Convert.ToDateTime(dr["DeliveryDate"].ToString()).ToString("MM-dd-yyyy");
Label lblSupplierDRNo = (Label)e.Item.FindControl("lblSupplierDRNo");
lblSupplierDRNo.Text = dr["SupplierDRNo"].ToString();
Label lblAmount = (Label)e.Item.FindControl("lblAmount");
lblAmount.Text = Convert.ToDecimal(dr["SubTotal"].ToString()).ToString("#,##0.#0");
Label lblPaidAmount = (Label)e.Item.FindControl("lblPaidAmount");
lblPaidAmount.Text = Convert.ToDecimal(dr["PaidAmount"].ToString()).ToString("#,##0.#0");
Label lblUnpaidAmount = (Label)e.Item.FindControl("lblUnpaidAmount");
lblUnpaidAmount.Text = Convert.ToDecimal(dr["UnpaidAmount"].ToString()).ToString("#,##0.#0");
// //For anchor
// HtmlGenericControl divExpCollAsst = (HtmlGenericControl) e.Item.FindControl("divExpCollAsst");
//
// HtmlAnchor anchorDown = (HtmlAnchor) e.Item.FindControl("anchorDown");
// anchorDown.HRef = "javascript:ToggleDiv('" + divExpCollAsst.ClientID + "')";
}
}
public bool UpdatePayment(long POID, decimal PaidAmount, POPaymentStatus paymentStatus)
{
try
{
string SQL = "UPDATE tblPO SET " +
"PaidAmount = PaidAmount + @PaidAmount, " +
"UnpaidAmount = UnpaidAmount - @PaidAmount, " +
"PaymentStatus = @PaymentStatus " +
"WHERE POID = @POID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmPaidAmount = new MySqlParameter("@PaidAmount",MySqlDbType.Decimal);
prmPaidAmount.Value = PaidAmount;
cmd.Parameters.Add(prmPaidAmount);
MySqlParameter prmPaymentStatus = new MySqlParameter("@PaymentStatus",MySqlDbType.Int16);
prmPaymentStatus.Value = paymentStatus.ToString("d");
cmd.Parameters.Add(prmPaymentStatus);
MySqlParameter prmPOID = new MySqlParameter("@POID",MySqlDbType.Int64);
prmPOID.Value = POID;
cmd.Parameters.Add(prmPOID);
base.ExecuteNonQuery(cmd);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
/**********************************
* Lemuel E. Aceron
* July 30, 2008 17:21
* Added for Payment
**********************************/
public bool UpdatePaymentStatus(POPaymentStatus paymentStatus, string IDs)
{
try
{
string SQL = "UPDATE tblPO SET PaymentStatus = @PaymentStatus WHERE POID IN (" + IDs + ");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmPaymentStatus = new MySqlParameter("@PaymentStatus",MySqlDbType.Int16);
prmPaymentStatus.Value = paymentStatus.ToString("d");
cmd.Parameters.Add(prmPaymentStatus);
base.ExecuteNonQuery(cmd);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
