Esempio n. 1
0
    protected void btnProductSave_Click(object sender, EventArgs e)
    {
        string PDiscription = string.Empty;

        if (txtProductName.Text == "")
        {
            DisplayMessage("Enter Product Name");
            txtProductName.Text = "";
            txtProductName.Focus();
            return;
        }
        if (ddlUnit.SelectedIndex == 0)
        {
            DisplayMessage("Select Unit");
            ddlUnit.SelectedIndex = 0;
            ddlUnit.Focus();
            return;
        }
        if (txtRequestQty.Text == "")
        {
            txtRequestQty.Text = "1";
        }
        string ReqId     = string.Empty;
        string ProductId = string.Empty;
        string UnitId    = string.Empty;

        if (editid.Value == "")
        {
            ReqId = ObjPurchaseReqestHeader.getAutoId();
        }
        else
        {
            ReqId = editid.Value.ToString();
        }
        int serialNo = 0;

        if (hidProduct.Value == "" || hidProduct.Value == "0")
        {
            DataTable dtProduct = ObjPurchaseRequestDetail.GetPurchaseRequestDetailbyRequestId(StrCompId, StrBrandId, StrLocationId, ReqId.Trim());
            if (dtProduct.Rows.Count > 0)
            {
                dtProduct = new DataView(dtProduct, "", "Serial_No Desc", DataViewRowState.CurrentRows).ToTable();
                serialNo  = Convert.ToInt32(dtProduct.Rows[0]["Serial_No"].ToString());
                serialNo += 1;
            }
            else
            {
                serialNo = 1;
            }
        }
        else
        {
            serialNo = Convert.ToInt32(ViewState["SNO"].ToString());
        }
        if (txtProductName.Text != "")
        {
            DataTable dt = new DataView(ObjProductMaster.GetProductMasterAll(StrCompId.ToString()), "EProductName='" + txtProductName.Text.ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
            if (dt.Rows.Count != 0)
            {
                PDiscription = txtPDescription.Text;

                ProductId = dt.Rows[0]["ProductId"].ToString();
            }
            else
            {
                PDiscription = txtPDesc.Text;

                ProductId = "0";
            }
        }
        if (ddlUnit.SelectedIndex == 0)
        {
        }
        else
        {
            UnitId = ddlUnit.SelectedValue.ToString();
        }
        if (hidProduct.Value == "" || hidProduct.Value == "0")
        {
            ObjPurchaseRequestDetail.InsertPurchaseRequestDetail(StrCompId.ToString(), StrBrandId.ToString(), StrLocationId.ToString(), ReqId.ToString(), serialNo.ToString(), ProductId.ToString(), PDiscription, UnitId.ToString(), txtRequestQty.Text.ToString(), "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), UserId.ToString(), DateTime.Now.ToString(), UserId.ToString(), DateTime.Now.ToString());
        }
        else
        {
            ObjPurchaseRequestDetail.UpdatePurchaseRequestDetail(StrCompId.ToString(), StrBrandId.ToString(), StrLocationId.ToString(), ReqId.ToString(), hidProduct.Value.ToString(), serialNo.ToString(), ProductId.ToString(), PDiscription, UnitId.ToString(), txtRequestQty.Text, "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), UserId.ToString(), DateTime.Now.ToString());

            pnlProduct1.Visible = false;
            pnlProduct2.Visible = false;
        }

        fillgridDetail();
        ResetDetail();
        txtProductName.Focus();
    }
    protected void btnProductSave_Click(object sender, EventArgs e)
    {
        if (txtProductName.Text == "")
        {
            DisplayMessage("Enter Product Name");
            txtProductName.Text = "";
            txtProductName.Focus();
            return;
        }
        if (ddlUnit.SelectedIndex == 0)
        {
            DisplayMessage("Select Unit");
            ddlUnit.SelectedIndex = 0;
            ddlUnit.Focus();
            return;
        }

        if (txtUnitCost.Text == "")
        {
            DisplayMessage("Enter Unit Cost");
            txtUnitCost.Focus();
            return;
        }


        if (txtRequestQty.Text == "")
        {
            txtRequestQty.Text = "1";
        }
        string ReqId     = string.Empty;
        string ProductId = string.Empty;
        string UnitId    = string.Empty;

        if (editid.Value == "")
        {
            ReqId = ObjTrans.getAutoId();   // confusion
        }
        else
        {
            ReqId = editid.Value.ToString();
        }
        string serailNo = string.Empty;

        if (hidProduct.Value == "")
        {
            int Serial = gvProductRequest.Rows.Count;
            Serial   = Serial + 1;
            serailNo = Serial.ToString();
        }
        else
        {
            serailNo = ViewState["SerialNo"].ToString();
        }



        if (txtProductName.Text != "")
        {
            DataTable dt = new DataView(ObjProductMaster.GetProductMasterAll(StrCompId.ToString()), "EProductName='" + txtProductName.Text.ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
            if (dt.Rows.Count != 0)
            {
                ProductId = dt.Rows[0]["ProductId"].ToString();
            }
            else
            {
                ProductId = "0";
            }
        }
        if (ddlUnit.SelectedIndex == 0)
        {
        }
        else
        {
            UnitId = ddlUnit.SelectedValue.ToString();
        }
        if (hidProduct.Value == "")
        {
            OBjtransDetail.InsertTransferRequestDetail(StrCompId.ToString(), StrBrandId.ToString(), StrLocationId.ToString(), serailNo.ToString(), ProductId.ToString(), ReqId.ToString(), UnitId.ToString(), txtUnitCost.Text, txtRequestQty.Text.ToString(), "0", "0", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), UserId.ToString(), DateTime.Now.ToString(), UserId.ToString(), DateTime.Now.ToString());
        }
        else
        {
            OBjtransDetail.UpdateTransferRequestDetail(StrCompId.ToString(), StrBrandId.ToString(), StrLocationId.ToString(), hidProduct.Value.ToString(), ReqId, serailNo.ToString(), ProductId.ToString(), UnitId.ToString(), txtUnitCost.Text, txtRequestQty.Text.ToString(), "0", "0", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), UserId.ToString(), DateTime.Now.ToString());
            pnlProduct1.Visible = false;

            pnlProduct2.Visible = false;
        }
        fillgridDetail();
        ResetDetail();
    }