//Submits the items that have been collected.
protected void btn_submitCollectionList_Click(object sender, EventArgs e)
{
//validate if textbox value is less than ordered & inventory
if (ValidatePreparedQty() < 0)
{
return;
}
//(1) tracking qty collected per item for all dpts, store in a list of Collection objs
List <CollectionListItem> allDptCollectionList = new List <CollectionListItem>();
foreach (GridViewRow gvr in gv_CollectionList.Rows)
{
string itemNumber = gvr.Cells[0].Text;
TextBox tb = (TextBox)gvr.FindControl("txt_QtyPrepared");
int qtyPrepped = Convert.ToInt32(tb.Text);
CollectionListItem c = new CollectionListItem(itemNumber, qtyPrepped);
allDptCollectionList.Add(c);
}
//(2) sort goods according to req_date - write to the distri / pending tables
BusinessLogic.SortCollectedGoods(allDptCollectionList);
//(3) deduct collected items from inventory
BusinessLogic.DeductFromInventory(allDptCollectionList);
LoadCollectionList();
if (gv_CollectionList.Rows.Count == 0)
{
//(4) Redirect to Sorting Page if gridview has no more rows (no more items to collect)
Response.Redirect("~/Protected/DisbursementSorting.aspx");
}
}
//when ready for collection is clicked
protected void btn_readyForCollect_Click(object sender, EventArgs e)
{
//checks if qty collected is more than either what is in inventory or order qty
if (ValidatePreparedQty() < 0)
{
return;
}
List <CollectionListItem> clList = new List <CollectionListItem>();
foreach (GridViewRow gvr in gv_ViewRO.Rows)
{
string itemNumber = gvr.Cells[0].Text;
TextBox tb = (TextBox)gvr.FindControl("txt_QtyPrepared");
int qtyPrepped = Convert.ToInt32(tb.Text);
CollectionListItem c = new CollectionListItem(itemNumber, qtyPrepped);
clList.Add(c);
}
// (1) insert collection_details + (2) add RO Ids & their collection_id to requisition_disbursement_detail [table]
string dptId = (Label_ViewRO.Text).Substring(0, 4);
int placeId = BusinessLogic.GetPlaceIdFromDptId(dptId);
/**
* String s = TextBox2.Text;
* DateTime dt = DateTime.ParseExact(s, "dd-MM-yyyy", CultureInfo.InvariantCulture);
* String x = dt.ToString("yyyy-MMMM-dd");
* DateTime search = Convert.ToDateTime(x);
*/
string s = TextBox_Collect_Date.Text;
DateTime dt = DateTime.ParseExact(s, "dd-MM-yyyy", CultureInfo.InvariantCulture);
String x = dt.ToString("yyyy-MMMM-dd");
DateTime collectionDate = Convert.ToDateTime(x);
//DateTime collectionDate = DateTime.Parse(TextBox_Collect_Date.Text); //joel
string ro_id = Label_ViewRO.Text.ToUpper();
//updates tables & sends email
BusinessLogic.SpecialRequestReadyUpdatesCDRDD(placeId, collectionDate, ro_id, dptId);
// (3) change amounts in requisition_order_detail table
BusinessLogic.ViewROSpecialRequestUpdateRODTable(clList, ro_id);
// (4) deduct from inventory
BusinessLogic.DeductFromInventory(clList);
Response.Redirect("~/Protected/ViewROSpecialRequest.aspx");
}
