/// <summary>
/// Save reqsn function
/// </summary>
private void SaveValue()
{
int retval = 0;
List <GridDataItem> RequestedItem = (from GridDataItem grdItem in rgdItems.MasterTableView.Items.Cast <GridDataItem>()
where ((TextBox)grdItem.FindControl("txtgrdItemReqstdQty")).Text != "0.00" && ((TextBox)grdItem.FindControl("txtgrdItemReqstdQty")).Text != "" &&
((TextBox)grdItem.FindControl("txtgrdItemReqstdQty")).Text != "0"
select grdItem).ToList();
IventoryItemData objDoInventory1 = new IventoryItemData();
objDoInventory1.VesselCode = hdnVesselID.Value;
objDoInventory1.RequisitionCode = ViewState["flt_ReqsnCode"].ToString();
BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase();
if (RequestedItem.Count > 0)
{
foreach (GridDataItem reqitem in RequestedItem)
{
objDoInventory1.ItemRefCode = reqitem["ID"].Text;
objDoInventory1.ItemInternRef = "0";
objDoInventory1.SystemCode = reqitem["System_Code"].Text;
objDoInventory1.SubSystemCode = reqitem["Subsystem_Code"].Text;
if (reqitem["Long_Description"].Text != "")
{
objDoInventory1.itemFullDesc = reqitem["Long_Description"].Text;
}
else
{
objDoInventory1.itemFullDesc = "0";
}
objDoInventory1.itemShortDesc = reqitem["Short_Description"].Text;
objDoInventory1.SavedLine = "5";
objDoInventory1.RequisitionComment = "0";
if (reqitem["Drawing_Number"].Text != "")
{
objDoInventory1.Drawing_Number = reqitem["Drawing_Number"].Text;
}
else
{
objDoInventory1.Drawing_Number = "0";
}
objDoInventory1.DrawingLink = "1";
objDoInventory1.CreatedBy = Session["userid"].ToString();
objDoInventory1.DocumentCode = ViewState["flt_DocumentCode"].ToString();
objDoInventory1.reqestedQty = ((TextBox)(reqitem.FindControl("txtgrdItemReqstdQty"))).Text;
objDoInventory1.ItemComment = ((TextBox)reqitem.FindControl("txtgrdItemComments")).Text;
objDoInventory1.ROB = (((TextBox)(reqitem.FindControl("txtROB"))).Text == "" ? null : ((TextBox)(reqitem.FindControl("txtROB"))).Text);
retval = objTechService.SaveInventroySupplyItem(objDoInventory1);
}
}
}
/// <summary>
/// Check if any reqsn with same catalogue in Draft mode.
/// </summary>
protected void CreateNewRequisition()
{
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
IventoryItemData objDoInventory = new IventoryItemData();
objDoInventory.POType = ddlPOType.SelectedValue.ToString();
objDoInventory.VesselCode = ddlVessel.SelectedValue.ToString();
objDoInventory.Department = ddlFunction.SelectedValue.ToString();
objDoInventory.DocumentNumber = "1";
objDoInventory.Totalitem = 0;
objDoInventory.LineType = "R";
objDoInventory.CreatedBy = GetSessionUserID().ToString();
objDoInventory.UserName = GetSessionUserName().ToString().Split(new char[] { ' ' })[0];
objDoInventory.UrgencyCode = ddlUrgency.SelectedValue;
objDoInventory.Account_Type = ddlAccountType.SelectedValue;
objDoInventory.RequisitionType = ddlReqsnType.SelectedValue;
objDoInventory.SystemCode = ddlCatalogue.SelectedValue;
if (ddlDeliveryPort.SelectedValue != "0" && ddlDeliveryPort.SelectedValue != "")
{
objDoInventory.Delivery_Port = Convert.ToInt16(ddlDeliveryPort.SelectedValue);//Convert.ToInt16(Session["DeliveryPort"]);
}
else
{
objDoInventory.Delivery_Port = 0;
}
objDoInventory.Delivery_Date = UDFLib.ConvertToDate(txtDeliveryDate.Text);
objDoInventory.Port_Call = Convert.ToInt16(ddlPortCall.SelectedValue);
objDoInventory.Owner_Code = ddlOwnerName.SelectedValue;
DataSet ds = BLL_PURC_Common.PURC_Checking_Requisition(objDoInventory);
if (ds.Tables[0].Rows.Count > 0)
{
pnlViewRequisition.Visible = true;
pnlNewRequisition.Visible = false;
ddlRequisitionList.DataSource = ds.Tables[0];
ddlRequisitionList.DataTextField = "requisition_code";
ddlRequisitionList.DataValueField = "DOCUMENT_CODE";
ddlRequisitionList.DataBind();
ddlRequisitionList.Items.Insert(0, new ListItem("-SELECT-", "0"));
ddlRequisitionList.SelectedIndex = 0;
BindRequisition(ddlRequisitionList.SelectedValue);
}
else
{
string ReturenID = objTechService.GenerateRequisitionNumber(objDoInventory);
if (ReturenID != "") //(dtReqsn_DocumentCode.Rows.Count >0)
{
ViewState["flt_DocumentCode"] = ReturenID; //Convert.ToString(dt.Rows[0]["DOCUMENT_CODE"]);
Session["DocumentCode"] = ReturenID;
Response.Redirect("PURC_Reqn_Items.aspx?DocumentCode=" + ViewState["flt_DocumentCode"] + "");
}
}
}
}
protected void SaveInventryItem(string ItemID)
{
BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase();
IventoryItemData objDoInventory1 = new IventoryItemData();
objDoInventory1.VesselCode = ViewState["VesselID"].ToString();
objDoInventory1.RequisitionCode = null;
objDoInventory1.ItemRefCode = ItemID.ToString();
objDoInventory1.ItemInternRef = ItemID.ToString();
objDoInventory1.SystemCode = Convert.ToString(GetCatalogue());
objDoInventory1.SubSystemCode = Convert.ToString(GetSubCatalogue());
if (txtItemDescription.Text != "")
{
objDoInventory1.itemFullDesc = txtItemDescription.Text.Trim();
}
else
{
objDoInventory1.itemFullDesc = "0";
}
objDoInventory1.itemShortDesc = txtItemName.Text.Trim();
objDoInventory1.SavedLine = "5";
objDoInventory1.RequisitionComment = "0";
if (txtItemDrawingNumber.Text != "")
{
objDoInventory1.Drawing_Number = txtItemDrawingNumber.Text.Trim();
}
else
{
objDoInventory1.Drawing_Number = "0";
}
objDoInventory1.DrawingLink = "1";
objDoInventory1.CreatedBy = Session["userid"].ToString();
objDoInventory1.DocumentCode = GetDocumentCode().ToString();
objDoInventory1.reqestedQty = "0";
objDoInventory1.ItemComment = null;
objDoInventory1.ROB = "0";
int retval = objTechService.SaveInventroySupplyItem(objDoInventory1);
}
public int AddInventoryItem(IventoryItemData objDOInventoryItem)
{
return(objInventoryItem.AddInventoryItem(objDOInventoryItem));
}
public string GenerateRequisitionNumber(IventoryItemData objDOInventoryItem)
{
return(objInventoryItem.GenerateRequisitionNumber(objDOInventoryItem));
}
public int SaveInventroySupplyItem(IventoryItemData objDOInventoryItem)
{
return(objInventoryItem.SaveInventroySupplyItem(objDOInventoryItem));
}
public int SaveUpdate_Quotation(IventoryItemData objDOInventoryItem, int CurrentUser, decimal TP, DataTable dt)
{
return(objInventoryItem.SaveUpdate_Quotation(objDOInventoryItem, CurrentUser, TP, dt));
}
public string SaveUpdate_FinalQuotation(IventoryItemData objDOInventoryItem, int CurrentUser)
{
return(objInventoryItem.SaveUpdate_FinalQuotation(objDOInventoryItem, CurrentUser));
}
public static DataSet PURC_Checking_Requisition(IventoryItemData objDoInventory)
{
return(DAL_PURC_Common.PURC_Checking_Requisition(objDoInventory));
}
/// <summary>
/// Fill all the Items Detail in Datatable and sets the "IventoryItemData" properties .
/// saves the Requisition
/// </summary>
protected void btnSave_Click(object sender, EventArgs e) // Save Requisition
{
if (ISvalid())
{
DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("ITEM_REF_CODE");
dt.Columns.Add("ORDER_PRICE");
dt.Columns.Add("ORDER_DISCOUNT");
dt.Columns.Add("ORDER_RATE");
dt.Columns.Add("REQUESTED_QTY");
dt.Columns.Add("VAT");
dt.Columns.Add("WithHold");
for (int i = 0; i < rptMain.Items.Count; i++)
{
Repeater rptChild = (Repeater)rptMain.Items[i].FindControl("rptChild");
for (int j = 0; j < rptChild.Items.Count; j++)
{
TextBox txtPPU = (TextBox)rptChild.Items[j].FindControl("txt_PPU");
TextBox txtTP = (TextBox)rptChild.Items[j].FindControl("txtTP");
TextBox txtDiscount = (TextBox)rptChild.Items[j].FindControl("txt_Discount");
TextBox txtQnty = (TextBox)rptChild.Items[j].FindControl("txtQnty");
ImageButton btn = (ImageButton)rptChild.Items[j].FindControl("btnupdate");
DropDownList ddlItemvat = (DropDownList)rptChild.Items[j].FindControl("ddl_ItemVAT");
DropDownList ddlItemWithhod = (DropDownList)rptChild.Items[j].FindControl("ddl_item_Withhold");
DataRow dr = dt.NewRow();
dr["ITEM_REF_CODE"] = btn.CommandArgument.ToString();
dr["ORDER_PRICE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtTP.Text);
dr["ORDER_DISCOUNT"] = Convert.ToDecimal(txtDiscount.Text.Length == 0 ? "0" : txtDiscount.Text);
dr["ORDER_RATE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtPPU.Text);
dr["REQUESTED_QTY"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtQnty.Text);
dr["VAT"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemvat.SelectedValue) == 0 ? "0" : ddlItemvat.SelectedValue);
dr["WithHold"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemWithhod.SelectedValue) == 0 ? "0" : ddlItemWithhod.SelectedValue);
dt.Rows.Add(dr);
}
}
IventoryItemData ItemData = new IventoryItemData();
ItemData.DocumentCode = Session["DocumentCode"].ToString();
ItemData.RequisitionCode = Session["Requisitioncode"].ToString();
ItemData.Delivery_Port = Convert.ToInt32(ddlSupp_Port.SelectedValue);
ItemData.Discount = Convert.ToInt32(txt_Discount.Text);
ItemData.SupplierID = HD_SelectedSupplier.Value.ToString();
ItemData.WithHoldTax = ddlWithHoldTax.SelectedValue.ToString();
ItemData.VAT = ddlVAt.SelectedValue.ToString();
ItemData.Advance = Convert.ToInt32(txt_Advance.Text);
ItemData.Currency = Session["CurrencyCode"].ToString();
ItemData.Delivery_Date = UDFLib.ConvertToDate(txt_SuppDate.Text);
//bindprice(Convert.ToDecimal(Session["PreviousCurr"]));
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
objTechService.SaveUpdate_Quotation(ItemData, Convert.ToInt32(Session["userid"]), Convert.ToDecimal(HD_TP.Value.Length < 1 ? "0" : HD_TP.Value), dt);
}
String msg = String.Format("alert('Requisition has been Saved sucessfully.'); ");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
}
else
{
string msgtxt = string.Empty;
if (HD_SelectedSupplier.Value.ToString() == string.Empty)
{
msgtxt = "Please Select The Supplier";
}
else
{
msgtxt = "Please Fill all the Mandatory Fields";
}
String msg = String.Format("alert('" + msgtxt + "'); ");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
}
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
if (ISvalid())
{
DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("ITEM_REF_CODE");
dt.Columns.Add("ORDER_PRICE");
dt.Columns.Add("ORDER_DISCOUNT");
dt.Columns.Add("ORDER_RATE");
dt.Columns.Add("REQUESTED_QTY");
dt.Columns.Add("VAT");
dt.Columns.Add("WithHold");
for (int i = 0; i < rptMain.Items.Count; i++)
{
Repeater rptChild = (Repeater)rptMain.Items[i].FindControl("rptChild");
for (int j = 0; j < rptChild.Items.Count; j++)
{
TextBox txtPPU = (TextBox)rptChild.Items[j].FindControl("txt_PPU");
TextBox txtTP = (TextBox)rptChild.Items[j].FindControl("txtTP");
TextBox txtDiscount = (TextBox)rptChild.Items[j].FindControl("txt_Discount");
TextBox txtQnty = (TextBox)rptChild.Items[j].FindControl("txtQnty");
ImageButton btn = (ImageButton)rptChild.Items[j].FindControl("btnupdate");
DropDownList ddlItemvat = (DropDownList)rptChild.Items[j].FindControl("ddl_ItemVAT");
DropDownList ddlItemWithhod = (DropDownList)rptChild.Items[j].FindControl("ddl_item_Withhold");
DataRow dr = dt.NewRow();
dr["ITEM_REF_CODE"] = btn.CommandArgument.ToString();
dr["ORDER_PRICE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtTP.Text);
dr["ORDER_DISCOUNT"] = Convert.ToDecimal(txtDiscount.Text.Length == 0 ? "0" : txtDiscount.Text);
dr["ORDER_RATE"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtPPU.Text);
dr["REQUESTED_QTY"] = Convert.ToDecimal(txtPPU.Text.Length == 0 ? "0" : txtQnty.Text);
dr["VAT"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemvat.SelectedValue) == 0 ? "0" : ddlItemvat.SelectedValue);
dr["WithHold"] = Convert.ToDecimal(Convert.ToDecimal(ddlItemWithhod.SelectedValue) == 0 ? "0" : ddlItemWithhod.SelectedValue);
dt.Rows.Add(dr);
}
}
//string DateFormat = UDFLib.GetDateFormat();//Get User date format
//UDFLib.ConvertUserDateFormat(txtDeliveryDate.Text, DateFormat);
string ReturnReq = string.Empty;
IventoryItemData ItemData = new IventoryItemData();
ItemData.DocumentCode = DocCode;
ItemData.Delivery_Date = UDFLib.ConvertToDate(txt_SuppDate.Text);;
ItemData.Delivery_Port = Convert.ToInt32(ddlSupp_Port.SelectedValue);
ItemData.Discount = Convert.ToInt32(txt_Discount.Text);
ItemData.SupplierID = HD_SelectedSupplier.Value.ToString();
ItemData.WithHoldTax = ddlWithHoldTax.SelectedValue.ToString();
ItemData.VAT = ddlVAt.SelectedValue.ToString();
ItemData.Advance = Convert.ToInt32(txt_Advance.Text);
ItemData.Currency = Session["CurrencyCode"].ToString();
if (ValidateQuestions() == true)
{
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
objTechService.SaveUpdate_Quotation(ItemData, Convert.ToInt32(Session["userid"]), Convert.ToDecimal(HD_TP.Value.Length < 1 ? "0" : HD_TP.Value), dt);
}
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
ReturnReq = objTechService.SaveUpdate_FinalQuotation(ItemData, Convert.ToInt32(Session["userid"]));
}
SaveQuestionnaire(ReturnReq);
ClientScript.RegisterStartupScript(Page.GetType(), "alert", "alert('Requisition has been Finalized.\\n Please Note Requisition Number:" + ReturnReq + "');window.location='PendingRequisitionDetails.aspx?NOQUOTE=1';", true);
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "alert", "alert('Please complete the Purchase Questionnaire to proceed with the purchase process');", true);
BindItmPreviewRpt();
}
}
else
{
string msgtxt = string.Empty;
if (HD_SelectedSupplier.Value.ToString() == string.Empty)
{
msgtxt = "Please Select The Supplier";
}
else
{
msgtxt = "Please Fill all the Mandatory Fields";
}
String msg = String.Format("alert('" + msgtxt + "'); ");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
}
}
