Пример #1
0
        protected void btnEditPurchaseItem_Click(object sender, ImageClickEventArgs e)
        {
            ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
            ADAM.DataBase.DierctSellDetail     PurcahseOrderdetaildr = Mdb.DierctSellDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value));

            PurcahseOrderdetaildr.ItemColorId = int.Parse(ddlItemColor.SelectedValue);
            PurcahseOrderdetaildr.ItemId      = long.Parse(ddlItemName.SelectedValue);
            PurcahseOrderdetaildr.Note        = txtPurchaseNote.Text;
            PurcahseOrderdetaildr.Qty         = decimal.Parse(txtQty.Text);
            Mdb.SaveChanges();
            gvPurchaseDetailsData.DataBind();
        }
Пример #2
0
        protected void gvPurchaseDetailsData_SelectedIndexChanged(object sender, EventArgs e)
        {
            ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
            ADAM.DataBase.DierctSellDetail     PurchaseDetailsdr = Mdb.DierctSellDetails.Single(a => a.Id == long.Parse(gvPurchaseDetailsData.SelectedDataKey.Value.ToString()));

            hfPurchaseDetailsId.Value = PurchaseDetailsdr.Id.ToString();
            GetItemDatabyID(PurchaseDetailsdr.ItemId);
            ddlItemColor.SelectedValue = PurchaseDetailsdr.ItemColorId.ToString();
            txtQty.Text          = PurchaseDetailsdr.Qty.ToString();
            txtPurchaseNote.Text = PurchaseDetailsdr.Note;
            ddlItemColor_SelectedIndexChanged(sender, e);
        }
Пример #3
0
        protected void btndeletePurchaseItem_Click(object sender, ImageClickEventArgs e)
        {
            ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
            ADAM.DataBase.DierctSellDetail     PurcahseOrderdetaildr = Mdb.DierctSellDetails.Single(a => a.Id == long.Parse(hfPurchaseDetailsId.Value));
            Mdb.DierctSellDetails.Remove(PurcahseOrderdetaildr);
            Mdb.SaveChanges();
            gvPurchaseDetailsData.DataBind();
            var PurchaseOrderHeaderRows = from a in Mdb.DierctSellDetails where a.DirectSellHeaderId == long.Parse(hfId.Value) select a;

            if (PurchaseOrderHeaderRows.Count() <= 0)
            {
                ADAM.DataBase.DirectSellData PurchaseHeadedr = Mdb.DirectSellDatas.Single(a => a.Id == long.Parse(hfId.Value));
                Mdb.DirectSellDatas.Remove(PurchaseHeadedr);
                Mdb.SaveChanges();
                btnNew_Click(sender, e);
            }
        }