Beispiel #1
0
    protected void btnDraft_Click(object sender, EventArgs e)
    {
        try
        {
            //string Confirm_Unit = "PC";
            int retval = BLL_POLOG_Delivery.POLog_Insert_Delivery_Item(UDFLib.ConvertIntegerToNull(Request.QueryString["ID"].ToString()), UDFLib.ConvertIntegerToNull(txtDeliveryID.Text),
                                                                       txtName.Text.Trim(), UDFLib.ConvertDecimalToNull(txtPoQty.Text.Trim()), UDFLib.ConvertDecimalToNull(txtPoPrice.Text.Trim()), txtDeliveryUnit.Text,
                                                                       UDFLib.ConvertDecimalToNull(txtConQty.Text.Trim()), UDFLib.ConvertDecimalToNull(txtConPrice.Text.Trim()), txtRemarks.Text.Trim(), UDFLib.ConvertToInteger(GetSessionUserID()));


            string msgDraft = String.Format("parent.ReloadParent_ByButtonID();");
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true);
        }
        catch
        {
        }
    }
    private void saveval()
    {
        StringBuilder strIDVals         = new StringBuilder();
        StringBuilder strItemdesciption = new StringBuilder();
        StringBuilder stritemUnits      = new StringBuilder();
        StringBuilder strItemRequestQty = new StringBuilder();
        StringBuilder strItemComments   = new StringBuilder();
        StringBuilder strUnitPrice      = new StringBuilder();
        StringBuilder strDiscount       = new StringBuilder();
        StringBuilder strSuppCode       = new StringBuilder();
        StringBuilder strBgtCode        = new StringBuilder();
        StringBuilder ItemRefCode       = new StringBuilder();

        int i = 0;

        DataTable dtExtraItems = new DataTable();

        dtExtraItems.Columns.Add("pkid");
        dtExtraItems.Columns.Add("Order_Item_ID");
        dtExtraItems.Columns.Add("POQty");
        dtExtraItems.Columns.Add("POPrice");
        dtExtraItems.Columns.Add("DeliveryQty");
        dtExtraItems.Columns.Add("DeliveryPrice");
        dtExtraItems.Columns.Add("Delivered_Unit");
        dtExtraItems.Columns.Add("Currency");
        dtExtraItems.Columns.Add("Item_Description");
        dtExtraItems.Columns.Add("Delivered_Item_Description");
        dtExtraItems.Columns.Add("Invoiced");



        // dtExtraItems.Columns.Add("BGT_CODE");

        int inc = 1;

        foreach (GridDataItem dataItem in gvDeliveryItem.MasterTableView.Items)
        {
            HiddenField lblgrdID            = (dataItem.FindControl("lblID") as HiddenField);
            HiddenField lblOrderItemID      = (dataItem.FindControl("lblOrderItemID") as HiddenField);
            Label       lblPOQty            = (dataItem.FindControl("lblPOQty") as Label);
            Label       lblPOprice          = (dataItem.FindControl("lblPOprice") as Label);
            TextBox     txtDeliveryQty      = (dataItem.FindControl("txtDeliveryQty") as TextBox);
            TextBox     txtDeliveryprice    = (dataItem.FindControl("txtDeliveryprice") as TextBox);
            Label       lblUnit             = (dataItem.FindControl("lblUnit") as Label);
            Label       lblPOCurrency       = (dataItem.FindControl("lblPOCurrency") as Label);
            Label       lblPODesc           = (dataItem.FindControl("lblPODesc") as Label);
            TextBox     txtItem_Description = (dataItem.FindControl("txtItem_Description") as TextBox);
            Label       lblInvoiced         = (dataItem.FindControl("lblInvoiced") as Label);

            //if (txtgrdItemReqQty.Text.Length > 0 && txtItemDescription.Text.Length > 0)
            //{
            DataRow dritem = dtExtraItems.NewRow();
            dritem["pkid"]                       = lblgrdID.Value;
            dritem["Order_Item_ID"]              = lblOrderItemID.Value;
            dritem["POQty"]                      = lblPOQty.Text.ToString();
            dritem["POPrice"]                    = lblPOprice.Text.ToString();
            dritem["DeliveryQty"]                = (txtDeliveryQty.Text.Trim() == "" ? "0" : txtDeliveryQty.Text.Trim());
            dritem["DeliveryPrice"]              = txtDeliveryprice.Text.ToString();
            dritem["Delivered_Unit"]             = lblUnit.Text.ToString();
            dritem["Currency"]                   = lblPOCurrency.Text.ToString();
            dritem["Item_Description"]           = lblPODesc.Text.ToString();
            dritem["Delivered_Item_Description"] = txtItem_Description.Text.ToString();
            dritem["Invoiced"]                   = lblInvoiced.Text.ToString();
            dtExtraItems.Rows.Add(dritem);
            inc++;

            //}
        }

        int retval = 0;

        if (dtExtraItems.Rows.Count > 0)
        {
            retval = BLL_POLOG_Delivery.POLog_Insert_Delivery_Item(UDFLib.ConvertStringToNull(txtDeliveryID.Text.ToString()), UDFLib.ConvertIntegerToNull(txtSupply_ID.Text.ToString()), dtExtraItems, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
        }
        //else
        //{
        //    string msg2 = String.Format("alert('Please Select Atleast one row.')");
        //    ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true);
        //}
    }