public async Task <IHttpActionResult> SaveUpdateHeadOfficeSalesDeliveryOrder(object[] data)
        {
            vmSalHDOMaster   model        = JsonConvert.DeserializeObject <vmSalHDOMaster>(data[0].ToString());
            UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[1].ToString());
            string           result       = string.Empty;

            //int recordsTotal = 0;
            try
            {
                result = await objDOService.SaveUpdateHeadOfficeSalesDeliveryOrder(model, commonEntity);

                NotificationHubs.BroadcastData(new NotificationEntity()); // for sending notification
            }
            catch (Exception e)
            {
                e.ToString();
                result = "";
            }

            return(Json(new
            {
                //recordsTotal,
                result
            }));

            //return objDOMaster.ToList();
        }
        public vmSalHDOMaster GetDOMasterById(vmCmnParameters objcmnParam)
        {
            GenericFactoryFor_HDOMaster_EF  = new SalHDOMaster_EF();
            GenericFactoryFor_HDODetails_EF = new SalHDODetail_EF();

            vmSalHDOMaster objDOMasterById = null;

            try
            {
                using (_ctxCmn = new ERP_Entities())
                {
                    var HDONoWiseID   = GenericFactoryFor_HDOMaster_EF.FindBy(HD => objcmnParam.ParamName == "" ? HD.HDOID == objcmnParam.id : HD.HDONo == objcmnParam.ParamName && HD.CompanyID == objcmnParam.loggedCompany && HD.IsDeleted == false && HD.IsActive == true && HD.IsAllApproved == true).Select(x => x.HDOID).FirstOrDefault();
                    var DODetailCount = GenericFactoryFor_HDODetails_EF.FindBy(HD => HD.HDOID == HDONoWiseID &&
                                                                               HD.CompanyID == objcmnParam.selectedCompany && HD.IsFDOCompleted == false && HD.IsDeleted == false &&
                                                                               HD.IsActive == true).ToList().Count;

                    objDOMasterById = (from m in _ctxCmn.SalHDOMasters
                                       join b in _ctxCmn.CmnUsers on m.BuyerID equals b.UserID
                                       //join l in _ctxCmn.SalLCMasters.Where(L => L.CompanyID == objcmnParam.loggedCompany && L.IsDeleted == false && L.IsActive == true)
                                       //on m.LCID equals (int)l.LCID
                                       where m.HDOID == HDONoWiseID
                                       orderby m.HDOID descending
                                       select new
                    {
                        HDOID = m.HDOID,
                        HDONo = m.HDONo,
                        DeliveredTo = b.ParAddress1,
                        UserId = b.UserID,
                        UserName = b.UserFullName,
                        CompanyID = m.CompanyID,
                        DODetailCount = DODetailCount
                    })
                                      .Select(x => new vmSalHDOMaster
                    {
                        HDOID         = x.HDOID,
                        HDONo         = x.HDONo,
                        DeliveredTo   = x.DeliveredTo,
                        UserId        = x.UserId,
                        UserName      = x.UserName,
                        CompanyID     = x.CompanyID,
                        DODetailCount = x.DODetailCount
                    }).FirstOrDefault();
                }
            }
            catch (Exception e)
            {
                e.ToString();
            }

            return(objDOMasterById);
        }
Example #3
0
        public IHttpActionResult GetDOMasterById(object[] data)
        {
            vmSalHDOMaster  objDoMasterById = null;
            vmCmnParameters objcmnParam     = JsonConvert.DeserializeObject <vmCmnParameters>(data[0].ToString());

            try
            {
                objDoMasterById = objDOService.GetDOMasterById(objcmnParam);
            }
            catch (Exception e)
            {
                e.ToString();
            }
            return(Json(new
            {
                objDoMasterById
            }));
        }
        public IHttpActionResult RevisedHeadOfficeSalesDeliveryOrder(object[] data)
        {
            vmSalHDOMaster    model       = JsonConvert.DeserializeObject <vmSalHDOMaster>(data[0].ToString());
            List <vmPIDetail> ListModel   = JsonConvert.DeserializeObject <List <vmPIDetail> >(data[1].ToString());
            vmCmnParameters   objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[2].ToString());
            string            result      = string.Empty;

            //int recordsTotal = 0;
            try
            {
                result = objDOService.RevisedHeadOfficeSalesDeliveryOrder(model, ListModel, objcmnParam);
            }
            catch (Exception e)
            {
                e.ToString();
                result = string.Empty;
            }

            return(Json(new
            {
                //recordsTotal,
                result
            }));
        }