public static bool SaveUpdateReturnOrder(ATTInvReturnOrder objRo) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { string sp = ""; int countRoDetail = objRo.LstReturnOrderDetail.Count; if (objRo.Action == "A") { sp = "sp_inv_add_return_order"; } else if (objRo.Action == "E") { sp = "sp_inv_edit_return_order"; } if (objRo.Action != "N" && sp != "") { OracleParameter[] paramArray = new OracleParameter[7]; paramArray[0] = Utilities.GetOraParam(":p_org_id", objRo.OrgID, OracleDbType.Int64, ParameterDirection.Input); // paramArray[1] = Utilities.GetOraParam(":p_unit_id", objRo.UnitID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_order_no", objRo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":p_delivery_seq", objRo.DeliverySeq, OracleDbType.Int32, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":p_return_seq", objRo.ReturnSeq, OracleDbType.Int32, ParameterDirection.InputOutput); paramArray[4] = Utilities.GetOraParam(":p_return_date", objRo.ReturnDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":p_return_remarks", objRo.ReturnRemarks, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":p_entry_by", objRo.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray); objRo.ReturnSeq = int.Parse(paramArray[3].Value.ToString()); } if (countRoDetail > 0) { DLLInvReturnOrderDetail.SaveUpdateReturnOrderDetail(objRo, Tran); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { ATTInvDeliveryOrder objDo = new ATTInvDeliveryOrder(); objDo = (ATTInvDeliveryOrder)Session["objReturn"]; ATTInvReturnOrder objRo = new ATTInvReturnOrder(); objRo.OrgID = objDo.OrgID; //objRo.UnitID = objDo.UnitID; objRo.OrderNo = objDo.OrderNo; objRo.DeliverySeq = objDo.DeliverySeq; objRo.ReturnDate = txtReturnDate_RDT.Text; objRo.ReturnRemarks = txtReturnRemark_rqd.Text; objRo.LstReturnOrderDetail = SetReturOrderDetail(); objRo.EntryBy = entryBy; objRo.Action = "A"; if (updReturnFlag) { this.lblStatusMessageTitle.Text = "डेलिभरी सामान फिर्ता"; this.lblStatusMessage.Text = "कति वटा सामान फिर्ता गर्ने हो डाटा राख्नुहोस्।"; this.programmaticModalPopup.Show(); updReturnFlag = false; } else { if (BLLInvReturnOrder.SaveUpdateReturnOrder(objRo)) { ReloadSrchData(); Session["objReturn"] = null; ClearControls(); ClearGridControls(); pnlReturnOrder.Visible = false; this.lblStatusMessageTitle.Text = "डेलिभरी सामान फिर्ता"; this.lblStatusMessage.Text = " सफलतापूर्वक डेलिभरी सामान फिर्ता भयो।"; this.programmaticModalPopup.Show(); } else { this.lblStatusMessageTitle.Text = "डेलिभरी सामान फिर्ता"; this.lblStatusMessage.Text = " डेलिभरी सामान फिर्ता गर्दा वाधा उत्पन्न भयो।"; this.programmaticModalPopup.Show(); } } } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static bool SaveUpdateReturnOrder(ATTInvReturnOrder objRo) { try { //DLLInvDeliveryOrder.SaveUpdateReturnOrder(objDo); DLLInvReturnOrder.SaveUpdateReturnOrder(objRo); return(true); } catch (Exception ex) { throw (ex); } }
public static bool SaveUpdateReturnOrderDetail(ATTInvReturnOrder objRo, OracleTransaction Tran) { try { string sp = ""; foreach (ATTInvReturnOrderDetail objRoDetail in objRo.LstReturnOrderDetail) { sp = ""; if (objRoDetail.Action == "A") sp = "sp_inv_add_return_order_det"; else if (objRoDetail.Action == "E") sp = "sp_inv_edit_return_order_det"; if (objRoDetail.Action != "N" && sp != "") { objRoDetail.ReturnSeq = objRo.ReturnSeq; List<OracleParameter> paramArray = new List<OracleParameter>(); // , paramArray.Add(Utilities.GetOraParam(":p_org_id", objRoDetail.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_order_no", objRoDetail.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_delivery_seq", objRoDetail.DeliverySeq, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_return_seq", objRoDetail.ReturnSeq, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_category_id", objRoDetail.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_sub_category_id", objRoDetail.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_id",objRoDetail.ItemsID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_seq_no",objRoDetail.SeqNo, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_return_qty",objRoDetail.ReturnQty, OracleDbType.Int64, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray()); } } return true; } catch (Exception ex) { throw (ex); } }