public void Delete_tblOrderItem_Record(Guid id) { Params.spD_tblOrderItem param = new Params.spD_tblOrderItem(true); param.SetUpConnection(string.Empty); param.Param_Oit_GuidID = id; using (SPs.spD_tblOrderItem sp = new SPs.spD_tblOrderItem(true)) { sp.Execute(ref param); param.Dispose(); } }
private void cmdDelete_Click(object sender, System.EventArgs e) { Params.spD_tblOrderItem Param = null; SPs.spD_tblOrderItem SP = null; Param = new Params.spD_tblOrderItem(); Param.SetUpConnection(ConnectionString); Param.Param_Oit_GuidID = CurrentID; SP = new SPs.spD_tblOrderItem(); if (SP.Execute(ref Param)) { Param.Dispose(); SP.Dispose(); MainDisplay.Visible = false; ErrorDisplay.Visible = true; lab_Error.Text = String.Format("Record with ID: {0} was successfully deleted!", CurrentID.ToString()); return; } else { if (Param.SqlException != null) { throw Param.SqlException; } if (Param.OtherException != null) { throw Param.OtherException; } } }
public void Execute(WSGuid Oit_GuidID, WSGuid Oit_GuidOrderID, WSGuid Oit_GuidProductID) { Params.spD_tblOrderItem param = new Params.spD_tblOrderItem(true); param.SetUpConnection(string.Empty); if (Oit_GuidID == null || Oit_GuidID.UseNull) { param.Param_Oit_GuidID = SqlGuid.Null; } else if (!Oit_GuidID.UseDefault) { param.Param_Oit_GuidID = Oit_GuidID.Value; } if (Oit_GuidOrderID == null || Oit_GuidOrderID.UseNull) { param.Param_Oit_GuidOrderID = SqlGuid.Null; } else if (!Oit_GuidOrderID.UseDefault) { param.Param_Oit_GuidOrderID = Oit_GuidOrderID.Value; } if (Oit_GuidProductID == null || Oit_GuidProductID.UseNull) { param.Param_Oit_GuidProductID = SqlGuid.Null; } else if (!Oit_GuidProductID.UseDefault) { param.Param_Oit_GuidProductID = Oit_GuidProductID.Value; } using (SPs.spD_tblOrderItem sp = new SPs.spD_tblOrderItem(true)) { sp.Execute(ref param); param.Dispose(); } }