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