public ActionResult ActionSaveUpdate(AirPackageInquiryModel model, string tranMode)
        {
            int    id       = model.PId;
            string saveMode = string.Empty;

            GetViewModel(id, tranMode, true);

            string viewPagePath = string.Empty;
            string vucPagePath  = "VUC_Add";

            if (ModelState.IsValid)
            {
                try
                {
                    _response = _provider.ActionSaveUpdate(model, tranMode);
                }
                catch (Exception ex)
                {
                    _response = new ServiceResponse(ex.Message, MessageType.Exception, false);
                }
            }
            else
            {
                _response = new ServiceResponse("Invalid Fields. Please fill mandatory fields!!", MessageType.Error, false);
            }
            TempData["ActionResponse"] = _response;
            if (Request.IsAjaxRequest())
            {
                return(PartialView(vucPagePath, _modObj));
            }
            else
            {
                return(View(viewPagePath, _modObj));
            }
        }
        private AirPackageInquiryModel GetViewModel(int id, string tranMode, bool isPost = false)
        {
            ///tranMode = "N" , "U", "L", "V"

            if (id != 0 && isPost == false)
            {
                _modObj = _provider.GetDetails(id);
            }
            _modObj.packageDetail = new ATLTravelPortal.Repository.PackageProvider().GetDetail(_modObj.PackageId);
            SetUpFormParams(tranMode);
            return(_modObj);
        }
 public ActionResult Add(AirPackageInquiryModel model)
 {
     //return ActionSaveUpdate(model, "N");
     ActionSaveUpdate(model, "N");
     if (_response.ResponseStatus == true)
     {
         return(RedirectToAction("Index"));
     }
     else
     {
         return(View("Add", _modObj));
     }
 }
        public ServiceResponse Edit(AirPackageInquiryModel model)
        {
            try
            {
                using (var ts = new TransactionScope(TransactionScopeOption.Required))
                {
                    var result = _ent.Core_PackagesInquiries.Where(x => x.PackagesInquiryId == model.PId).FirstOrDefault();
                    if (result != null)
                    {
                        result.PackagesInquiryId = model.PId;
                        result.AgentId           = model.AgentId;
                        result.PackageId         = model.PackageId;
                        result.Title             = model.Title;
                        result.TravelDate        = model.TravelDate;
                        result.Name         = model.Name;
                        result.EmailAddress = model.EmailAddress;
                        result.NoOfAdult    = model.NoOfAdult;
                        result.NoOfChild    = model.NoOfChild;
                        result.ContactNo    = model.ContactNo;
                        result.Remark       = model.Remark;
                        result.CreatedBy    = model.CreatedBy;
                        result.CreatedDate  = model.CreatedDate;

                        _ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
                        _ent.SaveChanges();
                    }
                    ts.Complete();
                    _response = new ServiceResponse("Record successfully updated!!", MessageType.Success, true, "Edit");
                }
            }
            catch (SqlException ex)
            {
                _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
            }
            catch (Exception ex)
            {
                _response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Edit");
            }
            return(_response);
        }
 public ServiceResponse Save(AirPackageInquiryModel model)
 {
     try
     {
         using (var ts = new TransactionScope(TransactionScopeOption.Required))
         {
             Core_PackagesInquiries obj = new Core_PackagesInquiries
             {
                 AgentId      = model.AgentId,
                 PackageId    = model.PackageId,
                 Title        = model.Title,
                 TravelDate   = model.TravelDate,
                 Name         = model.Name,
                 EmailAddress = model.EmailAddress,
                 NoOfAdult    = model.NoOfAdult,
                 NoOfChild    = model.NoOfChild,
                 ContactNo    = model.ContactNo,
                 Remark       = model.Remark,
                 CreatedBy    = model.CreatedBy,
                 CreatedDate  = model.CreatedDate,
             };
             _ent.AddToCore_PackagesInquiries(obj);
             _ent.SaveChanges();
             ts.Complete();
             _response = new ServiceResponse("Record successfully created!!", MessageType.Success, true, "Edit");
             return(_response);
         }
     }
     catch (SqlException ex)
     {
         _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
     }
     catch (Exception ex)
     {
         _response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Edit");
     }
     return(_response);
 }
        public AirPackageInquiryModel GetDetails(int PId)
        {
            var result = _ent.Core_PackagesInquiries.Where(x => x.PackagesInquiryId == PId).FirstOrDefault();
            AirPackageInquiryModel obj = new AirPackageInquiryModel
            {
                PId          = result.PackagesInquiryId,
                AgentId      = result.AgentId,
                PackageId    = result.PackageId,
                PackageName  = result.PackageId == -1?result.PackageName : result.Air_Packages.Name,
                Title        = result.Title,
                TravelDate   = result.TravelDate,
                Name         = result.Name,
                EmailAddress = result.EmailAddress,
                NoOfAdult    = result.NoOfAdult,
                NoOfChild    = result.NoOfChild,
                ContactNo    = result.ContactNo,
                Remark       = result.Remark,
                CreatedBy    = result.CreatedBy,
                CreatedDate  = result.CreatedDate,
            };

            return(obj);
        }
        public IEnumerable <AirPackageInquiryModel> GetList()
        {
            int sno = 0;
            List <AirPackageInquiryModel> model = new List <AirPackageInquiryModel>();
            var result = (from a in _ent.Core_PackagesInquiries
                          join b in _ent.Air_Packages on a.PackageId equals b.PackageId
                          select new{ a, PackageName = b.Name }
                          )
                         .OrderBy(x => x.PackageName).OrderByDescending(x => x.a.CreatedDate);

            foreach (var item in result)
            {
                sno++;
                AirPackageInquiryModel obj = new AirPackageInquiryModel
                {
                    SNO       = sno,
                    PId       = item.a.PackagesInquiryId,
                    AgentId   = item.a.AgentId,
                    PackageId = item.a.PackageId,
                    //PackageName = item.PackageName,
                    PackageName  = item.a.PackageId == -1? item.a.PackageName : item.a.Air_Packages.Name,
                    Title        = item.a.Title,
                    TravelDate   = item.a.TravelDate,
                    Name         = item.a.Name,
                    EmailAddress = item.a.EmailAddress,
                    NoOfAdult    = item.a.NoOfAdult,
                    NoOfChild    = item.a.NoOfChild,
                    ContactNo    = item.a.ContactNo,
                    Remark       = item.a.Remark,
                    CreatedBy    = item.a.CreatedBy,
                    CreatedDate  = item.a.CreatedDate,
                };
                model.Add(obj);
            }

            return(model.AsEnumerable());
        }
        public ServiceResponse ActionSaveUpdate(AirPackageInquiryModel model, string tranMode)
        {
            try
            {
                if (tranMode == "N")
                {
                    return(Save(model));
                }
                else if (tranMode == "U")
                {
                    return(Edit(model));
                }
            }
            catch (SqlException ex)
            {
                _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
            }
            catch (Exception ex)
            {
                _response = new ServiceResponse(ex.Message, MessageType.Exception, false);
            }

            return(_response);
        }
 public ActionResult Edit(int id, AirPackageInquiryModel model)
 {
     model.PId = id;
     return(ActionSaveUpdate(model, "U"));
 }
 public ActionResult Page(int?page, string extraParams)
 {
     _modObj = GetViewModelList(page);
     return(View("Index", _modObj));
 }