/// <summary>
/// Created By : Ashwajit Bansod
/// Created Date : 17-April-2019
/// Created For : To get the details of PO by PO Id.
/// </summary>
/// <param name="objPaymentModel"></param>
/// <param name="ObjData"></param>
/// <returns></returns>
public POApproveRejectModel GetPODetails(PaymentModel objPaymentModel, PaymentModel ObjData)
{
var obj = new POApproveRejectModel();
try
{
if (ObjData != null)
{
var getBill = _workorderems.LogBills.Where(x => x.LBLL_BLL_Id == ObjData.BillNo).FirstOrDefault();
if (getBill.LBLL_POD_Id > 0)
{
obj = _workorderems.PODetails.Where(x => x.POD_Id == getBill.LBLL_POD_Id).
Select(a => new POApproveRejectModel()
{
POId = a.POD_Id,
QuickBookPOId = a.POD_QBKId
}).FirstOrDefault();
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public POApproveRejectModel GetPODetails(PaymentModel objPaymentModel, PaymentModel ObjData)", "Exception While geting PO details.", objPaymentModel);
throw;
}
return(obj);
}
/// <summary>
/// Created By : Ashwajit Bansod
/// Created By : 29-Sept-2018
/// Created For : To Open List Page of PO
/// </summary>
/// <returns></returns>
public ActionResult AllPOList()
{
long UserId = 0;
POApproveRejectModel model = new POApproveRejectModel();
eTracLoginModel ObjLoginModel = null;
if (Session != null && Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
UserId = ObjLoginModel.UserId;
}
model = _IPOTypeDetails.GetPODetailsForGraphs(UserId);
return(View(model));
}
public JsonResult ApprovePO(POApproveRejectModel objPOApproveRejectModel, POListModel objListData, List <POTypeDataModel> ProductListData)
{
var ObjLoginModel = new eTracLoginModel();
long LocationId = 0; string result = "";
long POId = 0;
try
{
if (Session != null && Session["eTrac"] != null)
{
ObjLoginModel = (eTracLoginModel)(Session["eTrac"]);
if (objPOApproveRejectModel.LocationId == 0)
{
LocationId = ObjLoginModel.LocationID;
}
}
if (!string.IsNullOrEmpty(objPOApproveRejectModel.POApproveRemoveId))
{
objPOApproveRejectModel.POApproveRemoveId = Cryptography.GetDecryptedData(objPOApproveRejectModel.POApproveRemoveId, true);
long.TryParse(objPOApproveRejectModel.POApproveRemoveId, out POId);
}
objPOApproveRejectModel.UserId = ObjLoginModel.UserId;
objPOApproveRejectModel.POModifiedId = POId;
if (objPOApproveRejectModel.POModifiedId > 0)
{
//var getResponseForQB = _IPOTypeDetails.GetApprovalResponseToSaveQBKId(objPOApproveRejectModel, objListData);
result = _IPOTypeDetails.ApprovePOByPOId(objPOApproveRejectModel, objListData);
if (objPOApproveRejectModel.Comment != null)
{
string realmId = CallbackController.RealMId.ToString();//Session["realmId"].ToString();
if (realmId != null)
{
try
{
string AccessToken = CallbackController.AccessToken.ToString();// Session["access_token"].ToString();
string refreshToken = CallbackController.RefreshToken;
var principal = User as ClaimsPrincipal;
OAuth2RequestValidator oauthValidator = new OAuth2RequestValidator(AccessToken);
ServiceContext serviceContext = new ServiceContext(realmId, IntuitServicesType.QBO, oauthValidator);
serviceContext.IppConfiguration.MinorVersion.Qbo = "23";
DataService commonServiceQBO = new DataService(serviceContext);
QueryService <PurchaseOrder> querySvcCompany = new QueryService <PurchaseOrder>(serviceContext);
List <PurchaseOrder> listPO = querySvcCompany.ExecuteIdsQuery("SELECT * FROM PurchaseOrder MaxResults 1000")
.ToList();
var getResponseForQB = _IPOTypeDetails.GetApprovalResponseToSaveQBKId(objPOApproveRejectModel, objListData);
if (getResponseForQB != null)
{
var dataget = listPO.Where(x => x.Id == getResponseForQB.POD_QBKId.ToString()).FirstOrDefault();
if (dataget != null)
{
dataget.POStatus = PurchaseOrderStatusEnum.Closed;
var update = commonServiceQBO.Update(dataget) as PurchaseOrder;
}
}
else
{
result = CommonMessage.NoRecordMessage();
}
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
}
}
else
{
result = "Not getting PO Number";
}
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
