/// <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)); }
protected override string DoIt() { _req = new MRequest(GetCtx(), GetRecord_ID(), null); // check mail template if found on request or request type. mailText_ID = _req.GetR_MailText_ID(); if (mailText_ID == 0) { MRequestType reqType = new MRequestType(GetCtx(), _req.GetR_RequestType_ID(), null); if (reqType.GetR_MailText_ID() > 0) { mailText_ID = reqType.GetR_MailText_ID(); } } if (mailText_ID == 0) { GetReqHistory(); if (_reqAction == null) { return(Msg.GetMsg(GetCtx(), "R_NoReqChanges")); } string changedValues = _reqAction.GetChangedValues(); bool _changed = false; sendInfo = new List <String>(); if (!string.IsNullOrEmpty(changedValues)) { string[] strValues = changedValues.Split(','); if (strValues.Length > 0) { for (int i = 0; i < strValues.Length; i++) { _changed = true; sendInfo.Add(strValues[i]); } } } #region commented // //if (_req.GetR_RequestType_ID() != _reqAction.GetR_RequestType_ID() && _reqAction.GetR_RequestType_ID() > 0) //{ // _changed = true; // sendInfo.Add("R_RequestType_ID"); //} //if (_req.GetR_Group_ID() != _reqAction.GetR_Group_ID() && _reqAction.GetR_Group_ID() > 0) //{ // _changed = true; // sendInfo.Add("R_Group_ID"); //} //if (_req.GetR_Category_ID() != _reqAction.GetR_Category_ID() && _reqAction.GetR_Category_ID() > 0) //{ // _changed = true; // sendInfo.Add("R_Category_ID"); //} //if (_req.GetR_Status_ID() != _reqAction.GetR_Status_ID() && _reqAction.GetR_Status_ID() > 0) //{ // _changed = true; // sendInfo.Add("R_Status_ID"); //} //if (_req.GetR_Resolution_ID() != _reqAction.GetR_Resolution_ID() && _reqAction.GetR_Resolution_ID() > 0) //{ // _changed = true; // sendInfo.Add("R_Resolution_ID"); //} //// //if (_req.GetSalesRep_ID() != _reqAction.GetSalesRep_ID() && _reqAction.GetSalesRep_ID() > 0) //{ // _changed = true; // sendInfo.Add("SalesRep_ID"); //} //// //if (_req.GetPriority() != _reqAction.GetPriority() && !string.IsNullOrEmpty(_reqAction.GetPriority())) //{ // _changed = true; // sendInfo.Add("Priority"); //} //if (_req.GetPriorityUser() != _reqAction.GetPriorityUser() && !string.IsNullOrEmpty(_reqAction.GetPriorityUser())) //{ // _changed = true; // sendInfo.Add("PriorityUser"); //} //if (_req.GetSummary() != _reqAction.GetSummary() && !string.IsNullOrEmpty(_reqAction.GetSummary())) //{ // _changed = true; // sendInfo.Add("Summary"); //} #endregion if (sendInfo.Count > 0 && _changed) { prepareNotificMsg(sendInfo); // For Role Changes Thread thread = new Thread(new ThreadStart(() => SendNotices(sendInfo))); thread.Start(); return(Msg.GetMsg(GetCtx(), "R_EmailBackgrndRun")); } else { return(Msg.GetMsg(GetCtx(), "R_NoReqChanges")); } } else { prepareNotificMsg(sendInfo); // For Role Changes Thread thread = new Thread(new ThreadStart(() => SendNotices(sendInfo))); thread.Start(); return(Msg.GetMsg(GetCtx(), "R_EmailBackgrndRun")); } return(""); }
} // 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