public ActionResult Add(TravelProjectDto travelProject)
        {
            WebResult result = new WebResult
            {
                Code    = SystemConst.MSG_SUCCESS,
                Message = SystemConst.MSG_ERR_UNKNOWN
            };

            using (var db = new TravelEntities())
            {
                T_TravelProjects selectTravelProject = new T_TravelProjects
                {
                    ProjectName   = travelProject.ProjectName,
                    AdultFee      = travelProject.AdultFee,
                    ChildFee      = travelProject.ChildFee,
                    SupplierID    = travelProject.SupplierID,
                    AgentAdultFee = travelProject.AgentAdultFee,
                    AgentChildFee = travelProject.AgentChildFee,
                    Description   = travelProject.Description,
                    ProjectTypeID = travelProject.ProjectTypeID,
                    Remark        = travelProject.Remark,
                    CoverPic      = travelProject.CoverPic
                };
                db.T_TravelProjects.Add(selectTravelProject);
                db.SaveChanges();
            }

            return(Content(AppUtils.JsonSerializer(result)));
        }
        public ActionResult Modify(TravelProjectDto travelProject)
        {
            WebResult result = new WebResult
            {
                Code    = SystemConst.MSG_SUCCESS,
                Message = SystemConst.MSG_ERR_UNKNOWN
            };

            using (var db = new TravelEntities())
            {
                T_TravelProjects selectTravelProject = db.T_TravelProjects.FirstOrDefault(a => a.ProjectID == travelProject.ProjectID);
                selectTravelProject.ProjectName   = travelProject.ProjectName;
                selectTravelProject.AdultFee      = travelProject.AdultFee;
                selectTravelProject.ChildFee      = travelProject.ChildFee;
                selectTravelProject.AgentAdultFee = travelProject.AgentAdultFee;
                selectTravelProject.AgentChildFee = travelProject.AgentChildFee;
                selectTravelProject.Description   = travelProject.Description;
                selectTravelProject.ProjectTypeID = travelProject.ProjectTypeID;
                selectTravelProject.Remark        = travelProject.Remark;
                selectTravelProject.CoverPic      = travelProject.CoverPic;
                db.T_TravelProjects.Attach(selectTravelProject);
                db.Entry(selectTravelProject).State = System.Data.Entity.EntityState.Modified;
                db.SaveChanges();
            }

            return(Content(AppUtils.JsonSerializer(result)));
        }
Example #3
0
        public ActionResult Add(SupplierPara param)
        {
            WebResult result = new WebResult
            {
                Code    = SystemConst.MSG_ERR_UNKNOWN,
                Message = String.Empty
            };

            try
            {
                using (var db = new TravelEntities())
                {
                    var supplier = new T_Suppliers
                    {
                        SupplierName = param.supplier.SupplierName,
                        Contact      = param.supplier.Contact,
                        HasHotel     = SystemConst.TRUE,
                        HasService   = SystemConst.TRUE
                    };
                    db.T_Suppliers.Add(supplier);
                    db.SaveChanges();

                    bool needSave = false;
                    if (param.travelProjects != null)
                    {
                        for (var i = 0; i < param.travelProjects.Count; i++)
                        {
                            TravelProjectDto travelProjectDto = param.travelProjects[i];
                            var travelProject = new T_TravelProjects
                            {
                                ProjectName   = travelProjectDto.ProjectName,
                                AdultFee      = travelProjectDto.AdultFee,
                                ChildFee      = travelProjectDto.ChildFee,
                                SupplierID    = supplier.SupplierID,
                                AgentAdultFee = travelProjectDto.AgentAdultFee,
                                AgentChildFee = travelProjectDto.AgentChildFee,
                                CoverPic      = travelProjectDto.CoverPic,
                                Remark        = travelProjectDto.Remark,
                                Description   = travelProjectDto.Description,
                                ProjectTypeID = travelProjectDto.ProjectTypeID
                            };
                            db.T_TravelProjects.Add(travelProject);
                            needSave = true;
                        }
                    }

                    if (param.hotels != null)
                    {
                        for (var i = 0; i < param.hotels.Count; i++)
                        {
                            HotelDto hotelDto = param.hotels[i];
                            var      hotel    = new T_LiveProjects
                            {
                                HouseName   = hotelDto.HouseName,
                                Fee         = hotelDto.Fee,
                                SupplierID  = supplier.SupplierID,
                                AgentFee    = hotelDto.AgentFee,
                                CoverPic    = hotelDto.CoverPic,
                                Description = hotelDto.Description,
                                Remark      = hotelDto.Remark,
                                Pics        = hotelDto.Pics,
                                Location    = hotelDto.Location,
                                RoomCount   = hotelDto.RoomCount
                            };
                            db.T_LiveProjects.Add(hotel);
                            needSave = true;
                        }
                    }

                    if (needSave)
                    {
                        db.SaveChanges();
                    }

                    result.Code = SystemConst.MSG_SUCCESS;
                    return(Content(AppUtils.JsonSerializer(result)));
                }
            }
            catch (Exception ex)
            {
                result.Message = ex.Message;
                return(Content(AppUtils.JsonSerializer(result)));
            }
        }