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(); }
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; }
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(); }
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; } }
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; } }
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(); }
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; } }