예제 #1
0
        private void UpdateList(int id)
        {
            DS           = new DataSet();
            itemRate     = new ItemRate();
            purchaseData = new PurchaseData();

            itemRate.VendorId = id;
            itemRate.Flag     = 1; //1 for get by VendorId
            DS = purchaseData.GetItemRateList(itemRate);
            rpItemRatesList.DataSource = DS;
            rpItemRatesList.DataBind();
            SelDropDown();
        }
예제 #2
0
        protected void dpItems_SelectedIndexChanged(object sender, EventArgs e)
        {
            DS           = new DataSet();
            itemRate     = new ItemRate();
            purchaseData = new PurchaseData();

            itemRate.ItemId = Convert.ToInt32(dpItems.SelectedItem.Value);
            itemRate.Flag   = 3; //
            DS = purchaseData.GetItemRateList(itemRate);
            rpItemRatesList.DataSource = DS;
            rpItemRatesList.DataBind();

            ScriptManager.RegisterStartupScript(this, this.GetType(), "sel1", "$('#MainContent_dpItems').addClass('selectpicker');$('#MainContent_dpItems').selectpicker();", true);
        }
예제 #3
0
        private void GetDetailsById(int itemRateId)
        {
            itemRate     = new ItemRate();
            purchaseData = new PurchaseData();
            DataSet DS = new DataSet();

            itemRate.ItemRatesId = itemRateId;

            itemRate.Flag = 2;

            DS = purchaseData.GetItemRateList(itemRate);
            if (!Comman.Comman.IsDataSetEmpty(DS))
            {
                dpVendor1.ClearSelection();
                if (dpVendor1.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["VendorId"]).ToString()) != null)
                {
                    dpVendor1.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["VendorId"]).ToString()).Selected = true;
                }

                dpItem.ClearSelection();
                if (dpItem.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["ItemId"]).ToString()) != null)
                {
                    dpItem.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["ItemId"]).ToString()).Selected = true;
                }

                txtQuantity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Quantity"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Quantity"].ToString();

                dpUnit.ClearSelection();
                if (dpUnit.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["UnitId"]).ToString()) != null)
                {
                    dpUnit.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["UnitId"]).ToString()).Selected = true;
                }
                txtPrice.Text      = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Price"].ToString()) ? string.Empty : Convert.ToDecimal(DS.Tables[0].Rows[0]["Price"]).ToString("#0.00");
                txtExcise.Text     = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ExciseDuty"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["ExciseDuty"].ToString();
                txtShipping.Text   = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Shipping"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Shipping"].ToString();
                txtCst.Text        = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["CST"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["CST"].ToString();
                txtVat.Text        = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Vat"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Vat"].ToString();
                txtInsurance.Text  = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Insurance"].ToString()) ? string.Empty : Convert.ToDecimal(DS.Tables[0].Rows[0]["Insurance"]).ToString("#0.00");
                txtFreight.Text    = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["FreightCharges"].ToString()) ? string.Empty : Convert.ToDecimal(DS.Tables[0].Rows[0]["FreightCharges"]).ToString("#0.00");
                txtTotalPrice.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TotalPrice"].ToString()) ? string.Empty : Convert.ToDecimal(DS.Tables[0].Rows[0]["TotalPrice"]).ToString("#0.00");
            }
            btnSubmit.Visible = false;
            btnUpdate.Visible = true;
        }