/// <summary>
/// GetDefault R_Status_ID
/// </summary>
/// <param name="ctx"></param>
/// <param name="fields"></param>
/// <returns></returns>
public int GetDefaultR_Status_ID(Ctx ctx, string fields)
{
string[] paramValue = fields.Split(',');
int R_RequestType_ID;
//Assign parameter value
R_RequestType_ID = Util.GetValueOfInt(paramValue[0].ToString());
//End Assign parameter value
MRequestType rt = MRequestType.Get(ctx, R_RequestType_ID);
int R_Status_ID = rt.GetDefaultR_Status_ID();
return(R_Status_ID);
}
public JsonResult GetDefaultR_Status_ID(string fields)
{
string retJSON = "";
if (Session["ctx"] != null)
{
VAdvantage.Utility.Ctx ctx = Session["ctx"] as Ctx;
string[] paramValue = fields.Split(',');
int R_RequestType_ID;
//Assign parameter value
R_RequestType_ID = Util.GetValueOfInt(paramValue[0].ToString());
MRequestType rt = MRequestType.Get(ctx, R_RequestType_ID);
int R_Status_ID = rt.GetDefaultR_Status_ID();
//List<Decimal> retlst = new List<Decimal>();
//retlst.Add(currentBalance);
retJSON = JsonConvert.SerializeObject(R_Status_ID);
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
} // prepare
/// <summary>
/// Process
/// </summary>
/// <returns>info</returns>
protected override String DoIt()
{
int lenth = 1;
log.Info("R_RequestType_ID=" + _R_RequestType_ID + ", R_Group_ID=" + _R_Group_ID
+ ", R_Category_ID=" + _R_Category_ID + ", C_BPartner_ID=" + _C_BPartner_ID
+ ", _M_Product_ID=" + _M_Product_ID);
MRequestType type = MRequestType.Get(GetCtx(), _R_RequestType_ID);
if (type.Get_ID() == 0)
{
throw new Exception("@R_RequestType_ID@ @NotFound@ " + _R_RequestType_ID);
}
if (!type.IsInvoiced())
{
throw new Exception("@R_RequestType_ID@ <> @IsInvoiced@");
}
String sql = "SELECT * FROM R_Request r"
+ " INNER JOIN R_Status s ON (r.R_Status_ID=s.R_Status_ID) "
+ "WHERE s.IsClosed='Y'"
+ " AND r.R_RequestType_ID=@Param1";
if (_R_Group_ID != 0 && _R_Group_ID != -1)
{
sql += " AND r.R_Group_ID=@Param2";
lenth = lenth + 1;
}
if (_R_Category_ID != 0 && _R_Category_ID != -1)
{
sql += " AND r.R_Category_ID=@Param3";
lenth = lenth + 1;
}
if (_C_BPartner_ID != 0)
{
sql += " AND r.C_BPartner_ID=@Param4";
lenth = lenth + 1;
}
sql += " AND r.IsInvoiced='Y' "
+ "ORDER BY C_BPartner_ID";
SqlParameter[] Param = new SqlParameter[lenth];
IDataReader idr = null;
DataTable dt = null;
try
{
int index = 0;
Param[index] = new SqlParameter("@Param1", _R_RequestType_ID);
if (_R_Group_ID != 0 && _R_Group_ID != -1)
{
index++;
Param[index] = new SqlParameter("@Param2", _R_Group_ID);
}
if (_R_Category_ID != 0 && _R_Category_ID != -1)
{
index++;
Param[index] = new SqlParameter("@Param3", _R_Category_ID);
}
if (_C_BPartner_ID != 0)
{
index++;
Param[index] = new SqlParameter("@Param4", _C_BPartner_ID);
}
idr = DataBase.DB.ExecuteReader(sql, Param, Get_TrxName());
dt = new DataTable();
dt.Load(idr);
idr.Close();
int oldC_BPartner_ID = 0;
foreach (DataRow dr in dt.Rows)
{
MRequest request = new MRequest(GetCtx(), dr, Get_TrxName());
if (!request.IsInvoiced())
{
continue;
}
if (oldC_BPartner_ID != request.GetC_BPartner_ID())
{
InvoiceDone();
}
if (_m_invoice == null)
{
InvoiceNew(request);
oldC_BPartner_ID = request.GetC_BPartner_ID();
}
InvoiceLine(request);
}
InvoiceDone();
//
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql, e);
}
finally
{
dt = null;
if (idr != null)
{
idr.Close();
}
}
if (string.IsNullOrEmpty(_msg))
{
_msg = "No Invoice Generated";
}
// R_Category_ID
return(_msg);
} // doIt