protected void btnForceClose_Click(object sender, EventArgs e)
{
tblRequisitionTableAdapter RequisitionStatusAdapter = new tblRequisitionTableAdapter();
//Response.Write(gvRequisitionTransaction.Rows[0].Cells[3].Text);
decimal RequestID = Convert.ToDecimal(gvRequisitionTransaction.Rows[0].Cells[2].Text);
if (gvRequisitionTransaction.Rows[0].Cells[3].Text != "Force Closed")
{
RequisitionStatusAdapter.spForceCloseRequisition(RequestID);
}
else
{
RequisitionStatusAdapter.spReactivateRequisition(RequestID);
}
BindGridRTransaction(RequestID);
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
tblRequisitionTableAdapter RequisitionTableAdapter = new tblRequisitionTableAdapter();
int new_RequestID = Convert.ToInt32(RequisitionTableAdapter.InsertABPItemRequisition(ddlToWarehouse.SelectedItem.Text, ddlToLocation.SelectedItem.Text.Trim(), 1, ddlFromWarehouse.SelectedItem.Text, ddlFromLocation.SelectedItem.Text, CommonFunctions.ConvertToUniversalDate(txtRequiredDateFrom.Text), 10, Context.User.Identity.Name, txtCEPNumber.Text));
tblRequestDetailsTableAdapter RequestItemAdapter = new tblRequestDetailsTableAdapter();
foreach (GridViewRow RItem in gvRequirement.Rows)
{
RequestItemAdapter.InsertNewRequestABPItem(new_RequestID, RItem.Cells[0].Text, Convert.ToDecimal(RItem.Cells[3].Text), CommonFunctions.ConvertToUniversalDate(txtRequiredDateFrom.Text), txtRqTime.Text, 0, 10);
}
// Show Message
lblSuccessfulTransactionNumber.Text = " - " + String.Format("{0:0000000}", new_RequestID);
// Generate Email
bool EmailSentBool = CommonFunctions.SendNewRequisitionEmail(new_RequestID, ddlFromWarehouse.SelectedItem.Text, ddlFromLocation.SelectedItem.Text, ddlToWarehouse.SelectedItem.Text, ddlToLocation.SelectedItem.Text.Trim(), Server.HtmlEncode("PMS-II - New Requisition Alert"), Server.HtmlEncode(String.Format("{0:0000000}", new_RequestID)));
// Set The View to next search and show the link for Requisition Note
hlRequisitionNote.NavigateUrl = String.Format("javascript:window.open('RequisitionNote.aspx?RqNo=" + new_RequestID + "', null, 'height=500,width=750,status=yes,toolbar=no,menubar=no,location=no'); void('');");;
MultiView1.SetActiveView(vwSuccess);
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
tblRequisitionTableAdapter RequisitionTableAdapter = new tblRequisitionTableAdapter();
int new_RequestID = Convert.ToInt32(RequisitionTableAdapter.InsertRequisition(ddlToWarehouse.SelectedItem.Text, ddlToLocation.SelectedItem.Text.Trim(), 1, ddlFromWarehouse.SelectedItem.Text, ddlFromLocation.SelectedItem.Text, DateTime.Now, 10, Context.User.Identity.Name));
//Response.Write("new value :" + new_RequestID);
tblRequestDetailsTableAdapter RequestItemAdapter = new tblRequestDetailsTableAdapter();
tblRequirementFileTableAdapter InsertRequirementAdapter = new tblRequirementFileTableAdapter();
foreach (GridViewRow RItem in gvTray.Rows)
{
//Response.Write(RItem.Cells[5].Text); //+ " : " + Convert.ToDecimal(RItem.Cells[1].Text)+ " : " + CommonFunctions.ConvertToUniversalDate(RItem.Cells[2].Text)+ " : " + RItem.Cells[3].Text+ " : " + Int32.Parse(RItem.Cells[4].Text)));
if (RItem.Cells[5].Text == "0")
{
RequestItemAdapter.InsertNewRequestItem(new_RequestID, RItem.Cells[1].Text, Convert.ToDecimal(RItem.Cells[7].Text), CommonFunctions.ConvertToUniversalDate(RItem.Cells[8].Text), RItem.Cells[9].Text.Trim(), Int32.Parse(RItem.Cells[10].Text), 10, CommonFunctions.ConvertToUniversalDate(RItem.Cells[4].Text));
if (!InsertRequirementAdapter.CheckItemScalarQuery(ddlFromWarehouse.SelectedItem.Text, ddlToLocation.SelectedItem.Text.Trim(), CommonFunctions.ConvertToUniversalDate(RItem.Cells[8].Text), RItem.Cells[1].Text).HasValue)
{
InsertRequirementAdapter.InsertRequirement(1, RItem.Cells[1].Text, DateTime.Now, CommonFunctions.ConvertToUniversalDate(RItem.Cells[8].Text), 0, Int32.Parse(RItem.Cells[10].Text), ddlFromLocation.SelectedItem.Text, ddlFromWarehouse.SelectedItem.Text);
}
}
else
{
RequestItemAdapter.InsertNewRequestItem(new_RequestID, RItem.Cells[1].Text, Convert.ToDecimal(RItem.Cells[7].Text), CommonFunctions.ConvertToUniversalDate(RItem.Cells[8].Text), RItem.Cells[9].Text.Trim(), Int32.Parse(RItem.Cells[10].Text), 10, CommonFunctions.ConvertToUniversalDate(RItem.Cells[4].Text));
}
}
// Show Message
lblSuccessfulTransactionNumber.Text = " - " + String.Format("{0:0000000}", new_RequestID);
// Generate Email
bool EmailSentBool = CommonFunctions.SendNewRequisitionEmail(new_RequestID, ddlFromWarehouse.SelectedItem.Text, ddlFromLocation.SelectedItem.Text, ddlToWarehouse.SelectedItem.Text, ddlToLocation.SelectedItem.Text.Trim(), Server.HtmlEncode("PMS-II - New Requisition Alert"), Server.HtmlEncode(String.Format("{0:0000000}", new_RequestID)));
// Set The View to next search and show the link for Requisition Note
hlRequisitionNote.NavigateUrl = String.Format("javascript:window.open('RequisitionNote.aspx?RqNo=" + new_RequestID + "', null, 'height=500,width=750,status=yes,toolbar=no,menubar=no,location=no'); void('');");;
FunctionClearNewItemEF();
//hlRequisitionNote.Attributes.Add("onclick", "window.open('" + HttpUtility.UrlEncode(hlRequisitionNote.NavigateUrl) + "',null,'height=250, width=800,status= no, resizable= no, scrollbars=no, toolbar=no,location=no,menubar=no ');");
MultiView1.SetActiveView(vwSuccess);
Response.Cookies["requesttray"].Expires = DateTime.Now;
}
protected void gvRequisitionInquiry_RowCommand(object sender, GridViewCommandEventArgs e)
{
// Get the index of the clicked row
int rowindex = Convert.ToInt32(e.CommandArgument);
switch (e.CommandName)
{
case "SelectRequisition":
mvSupplyTransactions.SetActiveView(vwRequisitionTransaction);
//Response.Write(gvRequisitionInquiry.DataKeys[rowindex].Value);
BindGridRTransaction(Convert.ToDecimal(gvRequisitionInquiry.DataKeys[rowindex].Value));
chkShowClosedRequisition.Visible = false;
tblRequisitionTableAdapter SetToActiveAdapter = new tblRequisitionTableAdapter();
SetToActiveAdapter.spUpdateRequestStatusToActive(Convert.ToDecimal(gvRequisitionInquiry.DataKeys[rowindex].Value));
break;
case "SelectItem":
mvSupplyTransactions.SetActiveView(vwItemTransaction);
break;
}
}
