Beispiel #1
0
        protected void gvAudit_SelectedIndexChanged(object sender, EventArgs e)
        {
            ADAM.DataBase.ADAMConnectionString       mdb = new DataBase.ADAMConnectionString();
            ADAM.DataBase.ExchangeRequestDetailsData ddr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExcahnge.SelectedDataKey.Value.ToString()));

            ddlExchangeRequest.SelectedValue = ddr.ExchangeRequestHeaderData.OrderType.ToString();
            txtExchangeRequestNo.Text        = ddr.ExchangeRequestHeaderData.ExchangeRequestNo.ToString();
            ShowReport();
        }
Beispiel #2
0
        protected void btnEditOrderItem_Click(object sender, ImageClickEventArgs e)
        {
            try
            {
                if (Session["UserID"] == null)
                {
                    Response.Redirect("~/BasicData/webLogIn.aspx");
                }
                int userid      = int.Parse(Session["UserID"].ToString());
                int operationid = 2;

                csGetPermission Per = new csGetPermission();
                if (!Per.getPermission(userid, pageid, operationid))
                {
                    Response.Redirect("~/BasicData/webHomePage.aspx");
                }

                ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
                ADAM.DataBase.RefluxDetailsData    ddr = mdb.RefluxDetailsDatas.Single(a => a.Id == long.Parse(RefluxDetailsId.Value));
                if (ddr.RefluxHeaderData.OrderType == 1)
                {
                    ADAM.DataBase.PurchaseOredrDetail purchasedr = mdb.PurchaseOredrDetails.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
                    if (decimal.Parse(txtQty.Text) > purchasedr.ConformQty)
                    {
                        Response.Write("<script>alert('لا يمكن ان تكون الكمية المرتجعة اكبر من الكمية الموجوده في طلب الشراء')</script>");
                        return;
                    }
                }

                if (ddr.RefluxHeaderData.OrderType == 2)
                {
                    ADAM.DataBase.ExchangeRequestDetailsData detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
                    if (decimal.Parse(txtQty.Text) > detailsdr.Qty)
                    {
                        Response.Write("<script>alert('لا يمكن ان تكون الكمية المرتجعة اكبر من الكمية الموجوده في طلب الصرف')</script>");
                        return;
                    }

                    if (decimal.Parse(txtFreeQty.Text) > detailsdr.FreeQty)
                    {
                        Response.Write("<script>alert('لا يمكن ان تكون الكمية المجانية المرتجعة اكبر من الكمية الموجوده في طلب الصرف')</script>");
                        return;
                    }
                }

                ddr.RefluxQty     = decimal.Parse(txtQty.Text);
                ddr.RefluxFreeQty = decimal.Parse(txtFreeQty.Text);

                mdb.SaveChanges();
                gvReflux.DataBind();
            }
            catch { }
        }
        protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                DropDownList ddlSalsType = gvExchangeRequestData.SelectedRow.FindControl("ddlSalsType") as DropDownList;
                if (ddlSalsType.SelectedValue == "0")
                {
                    Response.Write("<script>alert('من فضلك أدخل نوع السعر')</script>");
                    return;
                }

                ADAM.DataBase.ADAMConnectionString       mdb = new DataBase.ADAMConnectionString();
                ADAM.DataBase.ExchangeRequestDetailsData ddr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString()));
                var Rows = from a in mdb.ExchangeRequestPricings where a.ExchangeRequestDetailsId == ddr.Id select a;
                if (Rows.Count() > 0)
                {
                    Response.Write("<script>alert('لقد تم التسعير من قبل')</script>");
                    return;
                }
                ADAM.DataBase.ExchangeRequestPricing dr = new DataBase.ExchangeRequestPricing();
                dr.DiscPresent = 0;
                dr.DiscQty     = 0;
                dr.ExchangeRequestDetailsId = ddr.Id;
                dr.Note = "";

                long ItemPriceId = long.Parse(gvExchangeRequestData.SelectedDataKey[1].ToString());
                ADAM.DataBase.ItemPrice itmpricdr = mdb.ItemPrices.Single(a => a.Id == ItemPriceId);
                dr.MainClausePrice   = itmpricdr.MainClausePrice;
                dr.MainSalesPrice    = itmpricdr.MainSalesPrice;
                dr.MainShowsPrice    = itmpricdr.MainShowsPrice;
                dr.TesterClausePrice = itmpricdr.TesterClausePrice;
                dr.TesterSalesPrice  = itmpricdr.TesterSalesPrice;
                dr.TesterShowsPrice  = itmpricdr.TesterShowsPrice;

                if (ddlSalsType.SelectedValue == "1")
                {
                    dr.TInvoicePrice = itmpricdr.TesterSalesPrice;
                    dr.InvoicePrice  = itmpricdr.MainSalesPrice;
                }

                if (ddlSalsType.SelectedValue == "2")
                {
                    dr.InvoicePrice  = itmpricdr.MainClausePrice;
                    dr.TInvoicePrice = itmpricdr.TesterClausePrice;
                }

                mdb.ExchangeRequestPricings.Add(dr);
                mdb.SaveChanges();
                Response.Write("<script>alert('تم التسعير بنجاح')</script>");
            }
            catch { return; }
        }
 protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e)
 {
     ADAM.DataBase.ADAMConnectionString       mdb       = new DataBase.ADAMConnectionString();
     ADAM.DataBase.ExchangeRequestDetailsData Detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString()));
     hfDetailsId.Value = Detailsdr.Id.ToString();
     ADAM.DataBase.Item itmdr = mdb.Items.Single(a => a.Id == Detailsdr.ItemId);
     ItemId.Value        = itmdr.Id.ToString();
     hfItemColorId.Value = Detailsdr.ItemColorId.ToString();
     gvItemMovement.DataBind();
     gvExchangeRequestData.DataBind();
     gvExchangeRequestData.SelectedRow.BackColor          = System.Drawing.Color.BurlyWood;
     gvExchangeRequestData.SelectedRow.Cells[8].BackColor = gvExchangeRequestData.SelectedRow.Cells[9].BackColor = System.Drawing.Color.PaleVioletRed;
 }
Beispiel #5
0
        protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e)
        {
            ADAM.DataBase.ADAMConnectionString       mdb       = new DataBase.ADAMConnectionString();
            ADAM.DataBase.ExchangeRequestDetailsData Detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString()));

            hfExchangeRequestDetailsId.Value = Detailsdr.Id.ToString();
            ddlItemName.DataBind();
            GetItemDatabyID(Detailsdr.ItemId);
            ddlItemColor.SelectedValue = Detailsdr.ItemColorId.ToString();
            txtQty.Text            = Detailsdr.Qty.ToString();
            txtFreeQty.Text        = Detailsdr.FreeQty.ToString();
            hfIncommingOrder.Value = Detailsdr.IncommingOrderNo.ToString();
        }
Beispiel #6
0
        protected void btnDelete_Click(object sender, ImageClickEventArgs e)
        {
            if (Session["UserID"] == null)
            {
                Response.Redirect("~/BasicData/webLogIn.aspx");
            }
            int userid      = int.Parse(Session["UserID"].ToString());
            int operationid = 6;

            csGetPermission Per = new csGetPermission();

            if (!Per.getPermission(userid, pageid, operationid))
            {
                Response.Redirect("~/BasicData/webHomePage.aspx");
            }


            ADAM.DataBase.ADAMConnectionString       Mdb       = new DataBase.ADAMConnectionString();
            ADAM.DataBase.ExchangeRequestDetailsData Detailsdr = Mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(hfDetailsId.Value));
            if (Detailsdr.Status == 0)
            {
                Mdb.ExchangeRequestDetailsDatas.Remove(Detailsdr);
                Mdb.SaveChanges();
                gvExchangeRequestData.DataBind();

                var Rows = from a in Mdb.ExchangeRequestDetailsDatas where a.ExchangeRequestHeaderDataId == long.Parse(hfId.Value) select a;
                if (Rows.Count() <= 0)
                {
                    ADAM.DataBase.ExchangeRequestHeaderData Hdr = Mdb.ExchangeRequestHeaderDatas.Single(a => a.Id == long.Parse(hfId.Value));
                    Mdb.ExchangeRequestHeaderDatas.Remove(Hdr);
                    Mdb.SaveChanges();
                    Response.Redirect("~/StoreData/webUpdateExchangeRequest.aspx");
                }
            }
            else
            {
                Response.Write("<script>alert('لقد تم صرف هذا الصنف  من المخزن')</script>");
                return;
            }
        }
Beispiel #7
0
        protected void btnEditOrderItem_Click(object sender, ImageClickEventArgs e)
        {
            if (Session["UserID"] == null)
            {
                Response.Redirect("~/BasicData/webLogIn.aspx");
            }
            int userid      = int.Parse(Session["UserID"].ToString());
            int operationid = 2;

            csGetPermission Per = new csGetPermission();

            if (!Per.getPermission(userid, pageid, operationid))
            {
                Response.Redirect("~/BasicData/webHomePage.aspx");
            }


            ADAM.DataBase.ADAMConnectionString       Mdb       = new DataBase.ADAMConnectionString();
            ADAM.DataBase.ExchangeRequestDetailsData Detailsdr = Mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(hfDetailsId.Value));
            if (Detailsdr.Status == 0)
            {
                if (decimal.Parse(txtQty.Text) > decimal.Parse(lblCurrentBalance.Text))
                {
                    Response.Write("<script>alert('لا يمكن ان تكون الكمية المصروفه اكبر من الرصيد الحالي')</script>");
                    return;
                }
                Detailsdr.ItemId      = long.Parse(ddlItemName.SelectedValue);
                Detailsdr.Qty         = decimal.Parse(txtQty.Text);
                Detailsdr.FreeQty     = decimal.Parse(txtFreeQty.Text);
                Detailsdr.Note        = txtExchangeRequestNote.Text;
                Detailsdr.ItemColorId = int.Parse(ddlItemColor.Text);
                Mdb.SaveChanges();
                gvExchangeRequestData.DataBind();
            }
            else
            {
                Response.Write("<script>alert('لقد تم صرف هذا الصنف  من المخزن')</script>");
                return;
            }
        }
Beispiel #8
0
 protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e)
 {
     ADAM.DataBase.ADAMConnectionString       mdb       = new DataBase.ADAMConnectionString();
     ADAM.DataBase.ExchangeRequestDetailsData Detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString()));
     ADAM.DataBase.Item itmdr = mdb.Items.Single(a => a.Id == Detailsdr.ItemId);
     txtItemCode.Text          = itmdr.Code.ToString();
     ddlItemName.SelectedValue = itmdr.Id.ToString();
     ADAM.DataBase.ItemUnit Unitdr = mdb.ItemUnits.Single(a => a.Id == itmdr.ItemunitId);
     txtFreeQty.Text            = Detailsdr.FreeQty.ToString();
     lblItemUnit.Text           = Unitdr.Name;
     lblLimitQty.Text           = itmdr.LimitQty.ToString();
     ddlItemColor.SelectedValue = Detailsdr.ItemColorId.ToString();
     ADAM.DataBase.ItemStatus stdr = mdb.ItemStatus.Single(a => a.Id == itmdr.ItemStatus);
     lblItemstatus.Text = stdr.Status;
     txtBounce.Text     = Detailsdr.Bounce.ToString();
     ADAM.DataBase.SexData sexdr = mdb.SexDatas.Single(a => a.Id == itmdr.Sex);
     lblSex.Text = sexdr.Sex;
     txtQty.Text = Detailsdr.Qty.ToString();
     txtExchangeRequestNote.Text = Detailsdr.Note;
     hfDetailsId.Value           = Detailsdr.Id.ToString();
     GetCurrentBalance();
 }
        protected void gvItemMovement_SelectedIndexChanged(object sender, EventArgs e)
        {
            ADAM.DataBase.ADAMConnectionString Mdb   = new DataBase.ADAMConnectionString();
            ADAM.DataBase.ItemMovement         movdr = Mdb.ItemMovements.Single(a => a.Id == long.Parse(gvItemMovement.SelectedDataKey.Value.ToString()));
            TextBox txtQtyOut     = gvItemMovement.SelectedRow.FindControl("txtQtyOut") as TextBox;
            TextBox txtfreeQtyOut = gvItemMovement.SelectedRow.FindControl("txtfreeQtyOut") as TextBox;


            if ((movdr.MainQtyOut + decimal.Parse(txtQtyOut.Text) <= movdr.MainQty) && (movdr.AdditionalQtyOut + decimal.Parse(txtfreeQtyOut.Text) <= movdr.AdditionalQty))
            {
                movdr.MainQtyOut       = movdr.MainQtyOut + decimal.Parse(txtQtyOut.Text);
                movdr.AdditionalQtyOut = movdr.AdditionalQtyOut + decimal.Parse(txtfreeQtyOut.Text);

                var ExchangeRequestOrderRows = from a in Mdb.ExchangeRequestDetailsDatas
                                               where a.ExchangeRequestHeaderData.OrderType == long.Parse(ddlExchangeRequestType.SelectedValue) &&
                                               a.Status == 1
                                               orderby a.ExchangeRequestOrder descending
                                               select a;

                if (ExchangeRequestOrderRows.Count() <= 0)
                {
                    hfExchangeRequestOrder.Value = "1";
                }
                else
                {
                    if (hfExchangeRequestOrder.Value == "0")
                    {
                        hfExchangeRequestOrder.Value = (ExchangeRequestOrderRows.First().ExchangeRequestOrder + 1).ToString();
                    }
                }

                ADAM.DataBase.ExchangeRequestDetailsData Exdr = Mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(hfDetailsId.Value));
                if ((decimal.Parse(txtQtyOut.Text)) > (Exdr.Qty + Exdr.Bounce))
                {
                    Response.Write("<script>alert('لا يمكن ان يكون الكمية المنصرفة اكبر من كمية طلب الصرف')</script>");
                    return;
                }
                if ((decimal.Parse(txtfreeQtyOut.Text)) > (Exdr.FreeQty))
                {
                    Response.Write("<script>alert('لا يمكن ان يكون الكمية Tester المنصرفة اكبر من كمية طلب الصرف')</script>");
                    return;
                }
                Exdr.ExchangeRequestOrder = long.Parse(hfExchangeRequestOrder.Value);
                Exdr.Status = 1;

                if (movdr.IncommingOrderNo != 0)
                {
                    ADAM.DataBase.IncommingOrderData incdr = Mdb.IncommingOrderDatas.Single(a => a.IncommingOrderNo == movdr.IncommingOrderNo && a.AuditDetailsId == movdr.AuditDetailsId);
                    Exdr.IncommingOrderId = incdr.Id;
                    Exdr.LocationId       = movdr.LocatioId;
                }

                ADAM.DataBase.ItemMovement dr = new DataBase.ItemMovement();
                dr.AdditionalQty        = decimal.Parse(txtfreeQtyOut.Text) * -1;
                dr.AdditionalQtyOut     = 0;
                dr.AuditDetailsId       = movdr.AuditDetailsId;
                dr.DocmentId            = Exdr.Id;
                dr.IncommingOrderNo     = movdr.IncommingOrderNo;
                dr.ItemColorId          = movdr.ItemColorId;
                dr.ItemId               = movdr.ItemId;
                dr.ItemUnitId           = movdr.ItemUnitId;
                dr.LocatioId            = movdr.LocatioId;
                dr.MainQty              = decimal.Parse(txtQtyOut.Text) * -1;
                dr.MainQtyOut           = 0;
                dr.MovementDate         = DateTime.Now;
                dr.MovmentnameId        = int.Parse(ddlExchangeRequestType.Text);
                dr.RecDate              = DateTime.Now;
                dr.StoreId              = movdr.StoreId;
                dr.SupplyOrderDetailsId = movdr.SupplyOrderDetailsId;
                dr.ParentItemMoveMentId = movdr.Id;
                Mdb.ItemMovements.Add(dr);

                Exdr.IncommingOrderNo = movdr.IncommingOrderNo;

                Mdb.SaveChanges();

                Exdr.MovementId = dr.Id;

                gvExchangeRequestData.DataBind();
            }
            else
            {
                Response.Write("<script>alert('لا يمكن ان يكون الكمية المنصرفة اكبر من كمية الرصيد الحالي')</script>");
                return;
            }
        }
        //protected void btnEditOrderItem_Click(object sender, ImageClickEventArgs e)
        //{
        //    try
        //    {
        //        ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
        //        ADAM.DataBase.RefluxDetailsData ddr = mdb.RefluxDetailsDatas.Single(a => a.Id == long.Parse(RefluxDetailsId.Value));
        //        if (ddr.RefluxHeaderData.OrderType == 1)
        //        {
        //            ADAM.DataBase.PurchaseOredrDetail purchasedr = mdb.PurchaseOredrDetails.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
        //            if (decimal.Parse(txtQty.Text) > purchasedr.ConformQty)
        //            {
        //                Response.Write("<script>alert('لا يمكن ان تكون الكمية المرتجعة اكبر من الكمية الموجوده في طلب الشراء')</script>");
        //                return;
        //            }
        //        }

        //        if (ddr.RefluxHeaderData.OrderType == 2)
        //        {
        //            ADAM.DataBase.ExchangeRequestDetailsData detailsdr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
        //            if (decimal.Parse(txtQty.Text) > detailsdr.Qty)
        //            {
        //                Response.Write("<script>alert('لا يمكن ان تكون الكمية المرتجعة اكبر من الكمية الموجوده في طلب الصرف')</script>");
        //                return;
        //            }

        //            if (decimal.Parse(txtFreeQty.Text) > detailsdr.FreeQty)
        //            {
        //                Response.Write("<script>alert('لا يمكن ان تكون الكمية المجانية المرتجعة اكبر من الكمية الموجوده في طلب الصرف')</script>");
        //                return;
        //            }
        //        }

        //        ddr.RefluxQty = decimal.Parse(txtQty.Text);
        //        ddr.RefluxFreeQty = decimal.Parse(txtFreeQty.Text);

        //        mdb.SaveChanges();
        //        gvReflux.DataBind();
        //    }
        //    catch { }
        //}

        protected void btnSave_Click(object sender, ImageClickEventArgs e)
        {
            ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
            ADAM.DataBase.RefluxDetailsData    ddr = mdb.RefluxDetailsDatas.Single(a => a.Id == long.Parse(RefluxDetailsId.Value));
            if (ddr.RefluxHeaderData.OrderType == 1)
            {
                ADAM.DataBase.PurchaseOredrDetail Pdr = mdb.PurchaseOredrDetails.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
                if (Pdr.Status == 2)
                {
                    Pdr.IsClosed = 1;
                }
                else
                {
                    Response.Write("<script>alert('لا يمكن ارتجاع هذا الصنف حيث انه ليس في حالة جديد لطلب الشراء')</script>");
                    return;
                }
            }
            else if (ddr.RefluxHeaderData.OrderType == 2)
            {
                ADAM.DataBase.ExchangeRequestDetailsData Edr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == ddr.ExchangeOrPurchaseDetailsId);
                if (Edr.Status == 0)
                {
                    Response.Write("<script>alert('لا يمكن ارتجاع هذا الصنف حيث انه لم يتم صرفه')</script>");
                    return;
                }
                else if (Edr.Status != 0)
                {
                    long incommingOrder = 0;
                    long AuditDetailsId = 0;
                    long MovementnameId = 6;

                    var incomeRows = from a in mdb.ItemMovements
                                     where (a.MovmentnameId == 3 || a.MovmentnameId == 6) && a.ItemId == ddr.ItemId && a.ItemColorId == ddr.ItemColorId && a.IncommingOrderNo == long.Parse(txtIncommingOrder.Text)
                                     select a;

                    if (incomeRows.Count() <= 0)
                    {
                        Response.Write("<script>alert('من فضلك تأكد من رقم أذن الوارد')</script>");
                        return;
                    }

                    if (!string.IsNullOrEmpty(txtIncommingOrder.Text) && long.Parse(txtIncommingOrder.Text) > 0)
                    {
                        incommingOrder = long.Parse(txtIncommingOrder.Text);
                        MovementnameId = 3;
                    }

                    ADAM.DataBase.ItemMovement itmmovdr = mdb.ItemMovements.Single(a => a.IncommingOrderNo == incommingOrder && a.AuditDetailsId == AuditDetailsId &&
                                                                                   a.MovmentnameId == MovementnameId && a.ItemColorId == ddr.ItemColorId && a.ItemId == ddr.ItemId);

                    itmmovdr.MainQtyOut       = itmmovdr.MainQtyOut - (ddr.RefluxQty + ddr.Bounce);
                    itmmovdr.AdditionalQtyOut = itmmovdr.AdditionalQtyOut - ddr.RefluxFreeQty;

                    ADAM.DataBase.ItemMovement Nmov = new DataBase.ItemMovement();
                    Nmov.AdditionalQty        = ddr.RefluxFreeQty;
                    Nmov.AuditDetailsId       = AuditDetailsId;
                    Nmov.DocmentId            = ddr.Id;
                    Nmov.IncommingOrderNo     = incommingOrder;
                    Nmov.ItemColorId          = itmmovdr.ItemColorId;
                    Nmov.ItemId               = ddr.ItemId;
                    Nmov.LocatioId            = itmmovdr.LocatioId;
                    Nmov.ItemUnitId           = itmmovdr.ItemUnitId;
                    Nmov.MainQty              = ddr.RefluxQty + ddr.Bounce;
                    Nmov.MainQtyOut           = Nmov.AdditionalQtyOut = 0;
                    Nmov.MovementDate         = DateTime.Now;
                    Nmov.MovmentnameId        = 13;
                    Nmov.RecDate              = DateTime.Now;
                    Nmov.StoreId              = itmmovdr.StoreId;
                    Nmov.SupplyOrderDetailsId = itmmovdr.SupplyOrderDetailsId;
                    Nmov.ParentItemMoveMentId = itmmovdr.Id;
                    mdb.ItemMovements.Add(Nmov);
                }
                ddr.Status = 1;
            }
            mdb.SaveChanges();
            gvReflux.DataBind();
        }
Beispiel #11
0
        protected void gvExchangeRequestData_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                TextBox      txtQtyPrice    = gvExchangeRequestData.SelectedRow.FindControl("txtQtyPrice") as TextBox;
                TextBox      txtTesterPrice = gvExchangeRequestData.SelectedRow.FindControl("txtTesterPrice") as TextBox;
                DropDownList ddlSalsType    = gvExchangeRequestData.SelectedRow.FindControl("ddlSalsType") as DropDownList;
                if (ddlSalsType.SelectedValue == "0")
                {
                    Response.Write("<script>alert('من فضلك أدخل نوع السعر')</script>");
                    return;
                }
                if (string.IsNullOrEmpty(txtQtyPrice.Text) || decimal.Parse(txtQtyPrice.Text) < 1)
                {
                    Response.Write("<script>alert('من فضلك أدخل السعر بشكل صحيح بحيث يكون اكبر من الصفر')</script>");
                    return;
                }

                if ((string.IsNullOrEmpty(txtTesterPrice.Text) || decimal.Parse(txtTesterPrice.Text) < 1) && decimal.Parse(gvExchangeRequestData.SelectedRow.Cells[7].Text) > 0)
                {
                    Response.Write("<script>alert('من فضلك أدخل سعر الـ Tester بشكل صحيح بحيث يكون اكبر من الصفر')</script>");
                    return;
                }

                if (decimal.Parse(gvExchangeRequestData.SelectedRow.Cells[7].Text) <= 0 && decimal.Parse(txtTesterPrice.Text) > 1)
                {
                    Response.Write("<script>alert('لا يمكن تسعير ال Tester لان قيمة 0')</script>");
                    return;
                }

                ADAM.DataBase.ADAMConnectionString       mdb = new DataBase.ADAMConnectionString();
                ADAM.DataBase.ExchangeRequestDetailsData ddr = mdb.ExchangeRequestDetailsDatas.Single(a => a.Id == long.Parse(gvExchangeRequestData.SelectedDataKey.Value.ToString()));
                var Rows = from a in mdb.ExchangeRequestPricings where a.ExchangeRequestDetailsId == ddr.Id select a;
                if (Rows.Count() > 0)
                {
                    Response.Write("<script>alert('لقد تم التسعير من قبل')</script>");
                    return;
                }
                ADAM.DataBase.ExchangeRequestPricing dr = new DataBase.ExchangeRequestPricing();
                dr.DiscPresent = 0;
                dr.DiscQty     = 0;
                dr.ExchangeRequestDetailsId = ddr.Id;
                dr.Note = "";
                long ItemPriceId = long.Parse(gvExchangeRequestData.SelectedDataKey[1].ToString());
                ADAM.DataBase.ItemPrice itmpricdr = mdb.ItemPrices.Single(a => a.Id == ItemPriceId);
                dr.MainClausePrice   = itmpricdr.MainClausePrice;
                dr.MainSalesPrice    = itmpricdr.MainSalesPrice;
                dr.MainShowsPrice    = itmpricdr.MainShowsPrice;
                dr.TesterClausePrice = itmpricdr.TesterClausePrice;
                dr.TesterSalesPrice  = itmpricdr.TesterSalesPrice;
                dr.TesterShowsPrice  = itmpricdr.TesterShowsPrice;
                if (ddlSalsType.SelectedValue == "1")
                {
                    dr.TInvoicePrice = itmpricdr.TesterSalesPrice;
                    dr.InvoicePrice  = itmpricdr.MainSalesPrice;
                }

                if (ddlSalsType.SelectedValue == "2")
                {
                    dr.InvoicePrice  = itmpricdr.MainClausePrice;
                    dr.TInvoicePrice = itmpricdr.TesterClausePrice;
                }
                mdb.ExchangeRequestPricings.Add(dr);
                mdb.SaveChanges();
            }
            catch { return; }
        }