Beispiel #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        // 관리자 체크
        EmployeeInfo loginEmployee = new EmployeeInfo();

        loginEmployee = (EmployeeInfo)Session["loginMember"];
        if (loginEmployee == null)
        {
            Response.Redirect("~/login.aspx", true);
        }

        if (loginEmployee.ManagerLevel < 2)
        {
            Response.Redirect("~/login.aspx", true);
        }

        Office     bll    = new Office();
        OfficeInfo office = new OfficeInfo();

        office.OfficeCode = Convert.ToInt32(Request.QueryString["officeCode"]);

        int result = bll.deleteOffice(office);

        Response.Redirect("officeList.aspx", true);
    }
Beispiel #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="rdr"></param>
        /// <param name="obj"></param>
        /// <returns></returns>
        private OfficeInfo bindOffice(SqlDataReader rdr, OfficeInfo obj)
        {
            obj.OfficeCode = rdr.GetInt32(0);
            obj.OfficeName = rdr.GetString(1);
            obj.RegDate    = rdr.GetDateTime(2);
            obj.Status     = rdr.GetString(4);

            return(obj);
        }
Beispiel #3
0
 public void SaveOfficeInformation([FromBody] OfficeInfo officeInfo, string practiceLocationId)
 {
     AccessControl.VerifyUserAccessToMultiLocationOffice(practiceLocationId);
     this.officeIt2Manager.SaveOfficeInformation(officeInfo);
     if (officeInfo.TaxDetails != null)
     {
         officeInfo.TaxDetails.ForEach(PracticeInformationManager.SaveTaxInformation);
     }
 }
Beispiel #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        // 관리자 체크
        EmployeeInfo loginEmployee = new EmployeeInfo();

        loginEmployee = (EmployeeInfo)Session["loginMember"];
        if (loginEmployee == null)
        {
            Response.Redirect("~/login.aspx", true);
        }

        if (loginEmployee.ManagerLevel < 2)
        {
            Response.Redirect("~/login.aspx", true);
        }

        if (Page.IsPostBack)
        {
            OfficeInfo office = new OfficeInfo();
            office.OfficeCode = Convert.ToInt32(Request.QueryString["officeCode"]);
            office.OfficeName = txtOfficeName.Text;
            office.Status     = txtStatus.Text;

            // 수정하기 sửa
            if (mode.Value.Equals("modify"))
            {
                int result = bll.updateOffice(office);
                Response.Redirect("officeList.aspx");
            }
            // 등록하기 đăng ký
            else
            {
                int result = bll.insertOffice(office);
                Response.Redirect("officeList.aspx");;
            }
        }
        else
        {
            if (Request.QueryString["mode"].Equals("modify"))
            {
                OfficeInfo office = new OfficeInfo();
                office = bll.selectOffice(Request.QueryString["officeCode"]);

                txtOfficeName.Text = office.OfficeName;
                txtStatus.Text     = office.Status;

                lableCodeName.Text = " Sửa thông tin (정보 수정하기) : " + office.OfficeName;
                mode.Value         = Request.QueryString["mode"];
            }
            else
            {
                lableCodeName.Text = "Đăng ký (건물 등록하기)";
                mode.Value         = Request.QueryString["mode"];
            }
        }
    }
Beispiel #5
0
        /// <summary>
        /// update
        /// </summary>
        /// <param name="office"></param>
        /// <returns></returns>
        public int updateOffice(OfficeInfo office)
        {
            log.Debug("=================START updateOffice=================");
            log.Debug("office = " + office.ToString());

            StringBuilder sql_update = new StringBuilder();

            sql_update.Append("UPDATE Office SET officeName=N'" + office.OfficeName + "', status=N'" + office.Status + "' WHERE officeCode=" + office.OfficeCode);

            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);

            log.Debug(@"=================END updateOffice=================");

            return(result);
        }
Beispiel #6
0
        public ActionResult CreateOffice(string officename, string address, int empnumber)
        {
            var createoffice = new OfficeInfo()
            {
                OfficeName     = officename,
                Address        = address,
                OwnerId        = WebSecurity.CurrentUserId,
                EmployeeNumber = empnumber
            };

            dbContex.OfficeInfos.Add(createoffice);
            dbContex.SaveChanges();

            return(RedirectToAction("EmployeeList"));
        }
Beispiel #7
0
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            OfficeInfo obj = (OfficeInfo)e.Row.DataItem;

            HyperLink colModify = (HyperLink)e.Row.Cells[2].Controls[0];
            colModify.NavigateUrl = "officeEdit.aspx?officeCode=" + obj.OfficeCode + "&mode=modify";
            colModify.ImageUrl    = "~/images/icon/edit.gif";

            HyperLink colDelete = (HyperLink)e.Row.Cells[3].Controls[0];
            colDelete.NavigateUrl = "#";
            colDelete.Attributes.Add("onclick", "return confirmDelete('officeDelete.aspx?officeCode=" + obj.OfficeCode + "');");
            colDelete.ImageUrl = "~/images/icon/delete.gif";
        }
    }
Beispiel #8
0
        /// <summary>
        /// delete
        /// </summary>
        /// <param name="office"></param>
        /// <returns></returns>
        public int deleteOffice(OfficeInfo office)
        {
            log.Debug("=================START deleteOffice=================");
            log.Debug("office = " + office.ToString());

            StringBuilder sql_delete = new StringBuilder();

            //2010-12-21 김민우: 건물명 삭제시 FLAG값 변경으로 변경
            //sql_delete.Append("DELETE FROM Office WHERE officeCode=" + office.OfficeCode);
            sql_delete.Append("UPDATE Office SET DEL_FLAG ='Y' WHERE officeCode=" + office.OfficeCode);

            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_delete.ToString(), null);

            log.Debug(@"=================END deleteOffice=================");

            return(result);
        }
Beispiel #9
0
        /// <summary>
        /// insert
        /// </summary>
        /// <param name="office"></param>
        /// <returns></returns>
        public int insertOffice(OfficeInfo office)
        {
            log.Debug("=================START insertOffice=================");
            log.Debug("office = " + office.ToString());

            StringBuilder sql_insert = new StringBuilder();

            sql_insert.Append("INSERT INTO Office");
            sql_insert.Append(" (officeName,regDate,status) ");
            sql_insert.Append(" VALUES ");
            sql_insert.Append(" (N'" + office.OfficeName + "',GETDATE(),N'" + office.Status + "')");

            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_insert.ToString(), null);

            log.Debug(@"=================END insertOffice=================");

            return(result);
        }
Beispiel #10
0
        /// <summary>
        /// list
        /// </summary>
        /// <param name="keyWord"></param>
        /// <param name="key"></param>
        /// <returns></returns>
        public List <OfficeInfo> selectOfficeList(string keyWord, string key)
        {
            log.Debug("=================START selectOfficeList=================");
            log.Debug("keyWord = " + keyWord);
            log.Debug("key = " + key);

            List <OfficeInfo> list = new List <OfficeInfo>();

            StringBuilder sql_select = new StringBuilder();

            sql_select.Append("SELECT * FROM Office WHERE DEL_FLAG is null ");

            if (!String.IsNullOrEmpty(key))
            {
                if (key.Equals("A"))
                {
                    sql_select.Append("AND status = 'Y' ");
                }
                else
                {
                    sql_select.Append("AND " + keyWord + " LIKE '%" + key + "%'");
                }
            }



            sql_select.Append("ORDER BY officeName");

            //Execute the query against the database
            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_select.ToString(), null))
            {
                // Scroll through the results
                while (rdr.Read())
                {
                    OfficeInfo obj = new OfficeInfo();
                    obj = bindOffice(rdr, obj);
                    list.Add(obj);
                }
            }

            log.Debug(@"=================END selectOfficeList=================");

            return(list);
        }
        public List <TaskInfoVM> GetDoneWork(int currentUserId)
        {
            var officeInfo = new OfficeInfo();
            var data       = (from o in dbContex.OfficeInfos
                              join t in dbContex.TaskInfos on o.Id equals t.OfficeId
                              join u in dbContex.UserProfiles on t.EmployeeId equals u.UserId
                              where t.TaskStatus && o.OwnerId == currentUserId
                              select new TaskInfoVM()
            {
                Id = t.Id,
                EmployeeId = t.EmployeeId,
                TaskDescription = t.TaskDescription,
                OfficeName = o.OfficeName,
                TaskDeadline = t.TaskDeadline,
                TaskName = t.TaskName,
                EmployeeName = u.UserName,
                IsAccept = t.IsAccept
            }).ToList();

            return(data);
        }
Beispiel #12
0
        /// <summary>
        /// select
        /// </summary>
        /// <param name="officeCode"></param>
        /// <returns></returns>
        public OfficeInfo selectOffice(string officeCode)
        {
            log.Debug(@"=================START selectOffice=================");
            log.Debug(@"officeCode = " + officeCode);

            OfficeInfo obj = new OfficeInfo();

            StringBuilder sql_select = new StringBuilder();

            sql_select.Append("SELECT * FROM Office WHERE officeCode=" + officeCode);

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_select.ToString(), null))
            {
                if (rdr.Read())
                {
                    obj = bindOffice(rdr, obj);
                }
            }

            log.Debug(@"=================END selectOffice=================");
            return(obj);
        }
Beispiel #13
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="data"></param>
 /// <param name="collection"></param>
 /// <returns></returns>
 public static dynamic InsertNewOfficeInfo(OfficeInfo data, IMongoCollection <OfficeInfo> collection)
 {
     try
     {
         #region Create index
         //collection.Indexes.CreateOne("{ OfficeId: " + data.OfficeId + " }");
         #endregion
         collection.InsertOne(data);
         return(true);
     }
     catch (Exception ex)
     {
         if (ex.Message.Contains("duplicate key error"))
         {
             return(ex.Message);
         }
         else
         {
             SL.CreateLog("MongoHelper", "InsertNewOfficeInfo", ex.Message);
             return(false);
         }
     }
 }
Beispiel #14
0
 public int deleteOffice(OfficeInfo office)
 {
     return(dal.deleteOffice(office));
 }
Beispiel #15
0
 public int insertOffice(OfficeInfo office)
 {
     return(dal.insertOffice(office));
 }
Beispiel #16
0
 public int updateOffice(OfficeInfo office)
 {
     return(dal.updateOffice(office));
 }
Beispiel #17
0
        static void Main(string[] arguments)
        {
            ICommandLineParser commandLineParser = new PosixParser();
            CommandLine        commandLine       = commandLineParser.Parse(Options, arguments);

            int port = SocketOpenOfficeConnection.DefaultPort;

            if (commandLine.HasOption(OptionPort.Opt))
            {
                port = Convert.ToInt32(commandLine.GetOptionValue(OptionPort.Opt));
            }

            String outputFormat = null;

            if (commandLine.HasOption(OptionOutputFormat.Opt))
            {
                outputFormat = commandLine.GetOptionValue(OptionOutputFormat.Opt);
            }

            bool verbose = commandLine.HasOption(OptionVerbose.Opt);

            IDocumentFormatRegistry registry = new DefaultDocumentFormatRegistry();

            String[] fileNames = commandLine.Args;
            if ((outputFormat == null && fileNames.Length != 2) || fileNames.Length < 1)
            {
                String        syntax        = "Convert [options] input-file output-file; or\n" + "[options] -f output-format input-file [input-file...]";
                HelpFormatter helpFormatter = new HelpFormatter();
                helpFormatter.PrintHelp(syntax, Options);
                Environment.Exit(ExitCodeTooFewArgs);
            }

            IOpenOfficeConnection connection = new SocketOpenOfficeConnection(port);
            OfficeInfo            oo         = EnvUtils.Get();

            if (oo.Kind == OfficeKind.Unknown)
            {
                Console.Out.WriteLine("please setup OpenOffice or LibreOffice!");
                return;
            }
            try
            {
                if (verbose)
                {
                    Console.Out.WriteLine("-- connecting to OpenOffice.org on port " + port);
                }
                connection.Connect();
            }
            catch (Exception)
            {
                string CmdArguments = string.Format("-headless -accept=\"socket,host={0},port={1};urp;\" -nofirststartwizard", SocketOpenOfficeConnection.DefaultHost, SocketOpenOfficeConnection.DefaultPort);
                if (!EnvUtils.RunCmd(oo.OfficeUnoPath, "soffice", CmdArguments))
                {
                    Console.Error.WriteLine("ERROR: connection failed. Please make sure OpenOffice.org is running and listening on port " + port + ".");
                    Environment.Exit(ExitCodeConnectionFailed);
                }
            }
            try
            {
                IDocumentConverter converter = new OpenOfficeDocumentConverter(connection, registry);
                if (outputFormat == null)
                {
                    FileInfo inputFile  = new FileInfo(fileNames[0]);
                    FileInfo outputFile = new FileInfo(fileNames[1]);
                    ConvertOne(converter, inputFile, outputFile, verbose);
                }
                else
                {
                    foreach (var t in fileNames)
                    {
                        var inputFile  = new FileInfo(t);
                        var outputFile = new FileInfo(inputFile.FullName.Remove(inputFile.FullName.LastIndexOf(".", StringComparison.Ordinal)) + "." + outputFormat);
                        ConvertOne(converter, inputFile, outputFile, verbose);
                    }
                }
            }
            finally
            {
                if (verbose)
                {
                    Console.Out.WriteLine("-- disconnecting");
                }
                connection.Disconnect();
            }
        }
Beispiel #18
0
        /// <summary>
        /// 房源编辑页面
        /// </summary>
        /// <param name="posttype">信息类型 1 出售 2 求购 3 出租 4求租</param>
        /// <returns></returns>
        public ActionResult GetHouse(int posttype = 1, int buildingType = 1, int buildingId = 0, int editType = 0, int chouseId = 0, int cloneSuccess = 0)
        {
            ViewBag.ShowColned = cloneSuccess;
            PublicUserModel loginUser   = this.GetLoginUser();
            HouseModels     houseModels = new HouseModels();

            if (posttype < 1 || posttype > 4)
            {
                posttype = 1;
            }
            if (buildingType < 1 || buildingType > 5)
            {
                buildingType = 1;
            }
            ViewBag.Posttype      = posttype;
            ViewBag.EditType      = editType;
            ViewBag.ChouseId      = chouseId;
            ViewBag.BuildingType  = buildingType;
            ViewData["LoginUser"] = loginUser;
            if (cloneSuccess == 1)
            {
                return(View(houseModels));
            }
            else
            {
                HouseBasicInfo    houseBasicInfo = new HouseBasicInfo();
                List <HouseImage> houseImages    = new List <HouseImage>();
                HouseInfo         houseInfo      = new HouseInfo();
                VillaInfo         villaInfo      = new VillaInfo();
                ShopInfo          shopInfo       = new ShopInfo();
                OfficeInfo        officeInfo     = new OfficeInfo();
                FactoryInfo       factoryInfo    = new FactoryInfo();

                if (buildingId > 0)
                {
                    houseBasicInfo =
                        ncBase.CurrentEntities.HouseBasicInfo.Where(o => o.HouseID == buildingId && o.BuildType == buildingType && o.TradeType == posttype).FirstOrDefault();
                    byte bTradeType = BitConverter.GetBytes(posttype)[0];
                    if (houseBasicInfo.IsNull()) //房屋类型不匹配 或者发布类型不匹配
                    {
                        houseBasicInfo = new HouseBasicInfo();

                        houseModels.HouseBasicInfo = houseBasicInfo;
                        houseModels.HouseInfo      = houseInfo;
                        houseModels.HouseImages    = houseImages;
                        houseModels.VillaInfo      = villaInfo;
                        houseModels.ShopInfo       = shopInfo;
                        houseModels.OfficeInfo     = officeInfo;
                        houseModels.FactoryInfo    = factoryInfo;

                        return(View(houseModels));
                    }

                    houseImages =
                        ncBase.CurrentEntities.HouseImage.Where(o => o.HouseID == buildingId && o.Status == 1).ToList();
                    if (houseImages.IsNoNull())
                    {
                        houseImages = houseImages.OrderBy(o => o.OrderID).ToList();
                    }

                    switch (buildingType)
                    {
                    case (int)BuildingType.House:
                        houseInfo = ncBase.CurrentEntities.HouseInfo.Where(o => o.HouseID.Equals(buildingId)).FirstOrDefault();
                        if (houseInfo.IsNull())
                        {
                            houseInfo = new HouseInfo();
                        }
                        break;

                    case (int)BuildingType.Villa:
                        villaInfo = ncBase.CurrentEntities.VillaInfo.Where(o => o.HouseID.Equals(buildingId)).FirstOrDefault();
                        if (villaInfo.IsNull())
                        {
                            villaInfo = new VillaInfo();
                        }
                        break;

                    case (int)BuildingType.Shop:
                        shopInfo = ncBase.CurrentEntities.ShopInfo.Where(o => o.HouseID.Equals(buildingId)).FirstOrDefault();
                        if (shopInfo.IsNull())
                        {
                            shopInfo = new ShopInfo();
                        }
                        break;

                    case (int)BuildingType.Office:
                        officeInfo = ncBase.CurrentEntities.OfficeInfo.Where(o => o.HouseID.Equals(buildingId)).FirstOrDefault();
                        if (officeInfo.IsNull())
                        {
                            officeInfo = new OfficeInfo();
                        }
                        break;

                    case (int)BuildingType.Factory:
                        factoryInfo = ncBase.CurrentEntities.FactoryInfo.Where(o => o.HouseID.Equals(buildingId)).FirstOrDefault();
                        if (factoryInfo.IsNull())
                        {
                            factoryInfo = new FactoryInfo();
                        }
                        break;
                    }
                }

                if (string.IsNullOrEmpty(houseBasicInfo.InternalNum))
                {
                    houseBasicInfo.InternalNum = "WX" + DateTime.Now.ToString("yyyyMMdd") + StringUtility.GetValiCode(4);
                }

                houseModels.HouseBasicInfo = houseBasicInfo;
                houseModels.HouseInfo      = houseInfo;
                houseModels.HouseImages    = houseImages;
                houseModels.VillaInfo      = villaInfo;
                houseModels.ShopInfo       = shopInfo;
                houseModels.OfficeInfo     = officeInfo;
                houseModels.FactoryInfo    = factoryInfo;

                CommunityDetailModel result      = new CommunityDetailModel();
                List <RegionsModel>  regionsList = regionBll.GetRegionList(loginUser.CityID);
                result.DistrctList   = regionsList.FindAll(x => (x.Layer == 2));
                result.RegionList    = regionsList.FindAll(x => (x.Layer == 3));
                ViewBag.RegionsModel = result;

                return(View(houseModels));
            }
        }
Beispiel #19
0
        public ActionResult OperateHouse(FormCollection form)
        {
            PublicUserModel loginUser = this.GetLoginUser();

            #region 基本信息
            int houseId = 0, buildingType, city, uid = loginUser.UserID;
            int.TryParse(form["houseId"], out houseId);           //房源ID
            int.TryParse(form["buildingType"], out buildingType); //房屋类型
            int tradeType;
            int.TryParse(form["postType"], out tradeType);        //发布类型
            int isChange = 0;
            int.TryParse(form["isChange"], out isChange);         //表单是否被修改

            int.TryParse(form["city"], out city);                 //城市ID
            int communityId;
            int.TryParse(form["cellCode"], out communityId);      // 小区ID
            string communityName = form["cell"];                  //小区名

            int distrct;
            int.TryParse(form["distrct"], out distrct);  //行政区

            int region;
            int.TryParse(form["area"], out region); //路段

            string address = form["addr"];          //地址

            double buildArea, usedArea;
            double.TryParse(form["houseArea"], out buildArea);  //建筑面积
            double.TryParse(form["areaUsed"], out usedArea);    //使用面积
            if (usedArea > buildArea)
            {
                return(Content("建筑面积必须大于使用面积"));
            }
            int room, hall, kitchen, toilet, balcony;
            int.TryParse(form["room"], out room);       //房
            int.TryParse(form["hall"], out hall);       //厅
            int.TryParse(form["kitchen"], out kitchen); //厨房
            int.TryParse(form["toilet"], out toilet);   //卫生间
            int.TryParse(form["balcony"], out balcony); //阳台

            double price;
            double.TryParse(form["price"], out price); //价格

            double lowpay = 0;                         //最低首付


            string priceUnit;  //价格单位
            double unitPrice = 0;

            switch (tradeType)
            {
            case (int)TradeType.Sell:
                priceUnit = "万";
                unitPrice = buildArea > 0 ? price * 10000 / buildArea : 0; //出售计算单价
                lowpay    = price * 10000 * 0.30;                          //最低首付计算
                ; break;

            case (int)TradeType.Rent:
                switch (buildingType)
                {
                case (int)BuildingType.House:
                case (int)BuildingType.Villa:
                    priceUnit = "元/月"; break;

                default: priceUnit = form["priceType"]; break;
                }
                break;

            default: priceUnit = form["priceType"]; break;
            }

            string payType = form["payType"].IsNoNull() ? form["payType"] : "";  //支付方式

            int usedYear = 0;
            int.TryParse(form["ddlUsedYear"], out usedYear);  //建造年代

            Int16 curFloor = 0;
            Int16.TryParse(form["curFloor"], out curFloor);  //所在楼层

            Int16 maxFloor = 0;
            Int16.TryParse(form["maxFloor"], out maxFloor);  //总层数

            if (curFloor > maxFloor)
            {
                return(Content("总层数必须大于所在楼层"));
            }

            string pointTo = form["pointTo"];                                                           //朝向

            string lookTime      = form["lookTime"];                                                    //看房时间
            string fitmentStatus = form["fitmentStatus"];                                               //装修程度
            string internalNum   = form["internalNum"];                                                 //内部编号
            string cellLabel     = form["cellLabel"];                                                   //小区特色
            string houseLabel    = form["houseLabel"];                                                  //房源标签
            string yijuhua       = form["yijuhua"];                                                     //一句话广告

            string video = form["video"];                                                               //视频
            string title = form["title"].IsNoNull() ? form["title"] : communityName;                    //房源标题

            string contacts      = form["contacts"].IsNoNull() ? form["contacts"] : loginUser.NickName; //委托人
            string tel           = form["tel"].IsNoNull() ? form["tel"] : loginUser.Tel;                //委托人联系方式
            string houseDescribe = form["houseDescribe"];                                               //房源描述

            string imgUrlCover = "";                                                                    //房源图封面

            string imgUrl      = form["imgUrl"].IsNoNull() ? form["imgUrl"] : "";                       //房源图
            string imageType   = form["imageType"].IsNoNull() ? form["imageType"] : "";                 //房源图类型
            string imgDescribe = "," + (form["imgDescribe"].IsNoNull()? form["imgDescribe"] : "");      //房源图说明

            string[] imgUrlLists      = imgUrl.Split(',');
            string[] imageTypeLists   = imageType.Split(',');
            string[] imgDescribeLists = imgDescribe.Split(',');

            if (imgUrlLists.Length > 0 && string.IsNullOrEmpty(imgUrlCover))
            {
                imgUrlCover = imgUrlLists[0];
            }
            //   return JsonReturnValue(new { Message = imgUrl + " | " + imageType + " | " + imgDescribe + " | " + imgUrlCover + " | " + imageTypeCover + " | " + imgDescribeCover, id = houseId, }, JsonRequestBehavior.AllowGet);


            HouseBasicInfo houseBasicInfo = new HouseBasicInfo();
            if (houseId < 1)
            {
                return(Content("管理后台不能发布房源"));
            }
            houseBasicInfo = ncBase.CurrentEntities.HouseBasicInfo.Where(o => o.HouseID == houseId).FirstOrDefault();
            if (houseBasicInfo.IsNull())
            {
                return(Content("该房源不存在"));
            }

            houseBasicInfo.TradeType     = BitConverter.GetBytes(tradeType)[0];
            houseBasicInfo.CityID        = city;
            houseBasicInfo.Distrctid     = distrct;
            houseBasicInfo.RegionID      = region;
            houseBasicInfo.CommunityID   = communityId;
            houseBasicInfo.CommunityName = communityName;
            houseBasicInfo.BuildType     = BitConverter.GetBytes(buildingType)[0];
            houseBasicInfo.BuildArea     = Convert.ToDecimal(buildArea);
            houseBasicInfo.UsedArea      = Convert.ToDecimal(usedArea);;
            houseBasicInfo.PointTo       = pointTo;
            houseBasicInfo.UnitPrice     = Convert.ToDecimal(unitPrice);
            houseBasicInfo.Price         = Convert.ToDecimal(price);
            houseBasicInfo.PriceUnit     = priceUnit;
            houseBasicInfo.CurFloor      = curFloor;
            houseBasicInfo.MaxFloor      = maxFloor;
            houseBasicInfo.UsedYear      = usedYear;
            houseBasicInfo.ExpireDay     = DateTime.Now.AddDays(30);
            houseBasicInfo.FitmentStatus = fitmentStatus;
            int picNum = imgUrlLists.Length > 1 ? imgUrlLists.Length - 1 : 0;
            houseBasicInfo.PicNum        = BitConverter.GetBytes(picNum)[0];
            houseBasicInfo.Title         = title;
            houseBasicInfo.Note          = houseDescribe;
            houseBasicInfo.Status        = BitConverter.GetBytes((int)HouseStatus.Release)[0];
            houseBasicInfo.IP            = IpUtility.GetIp();
            houseBasicInfo.PostTime      = DateTime.Now;
            houseBasicInfo.Address       = address;
            houseBasicInfo.LookHouseTime = lookTime;
            houseBasicInfo.HouseLabel    = houseLabel;
            houseBasicInfo.InternalNum   = internalNum;
            houseBasicInfo.CellLabel     = cellLabel;
            houseBasicInfo.YiJuHua       = yijuhua;
            houseBasicInfo.Room          = BitConverter.GetBytes(room)[0];
            houseBasicInfo.Hall          = BitConverter.GetBytes(hall)[0];
            houseBasicInfo.Kitchen       = BitConverter.GetBytes(kitchen)[0];
            houseBasicInfo.Toilet        = BitConverter.GetBytes(toilet)[0];
            houseBasicInfo.Balcony       = BitConverter.GetBytes(balcony)[0];
            houseBasicInfo.PayType       = payType;
            houseBasicInfo.HouseImgPath  = imgUrlCover;
            houseBasicInfo.LowPay        = Convert.ToDecimal(lowpay);
            houseBasicInfo.Tel           = tel;
            houseBasicInfo.Contacts      = contacts;
            houseBasicInfo.Video         = video;

            if (houseId.Equals(0)) //添加操作时候
            {
                houseBasicInfo.Tag        = "";
                houseBasicInfo.AddDate    = DateTime.Now;
                houseBasicInfo.PushTime   = Convert.ToDateTime("1900-1-1");
                houseBasicInfo.DeleteTime = Convert.ToDateTime("1900-1-1");
                ncBase.CurrentEntities.AddToHouseBasicInfo(houseBasicInfo);
            }
            ncBase.CurrentEntities.SaveChanges();

            houseId = houseBasicInfo.HouseID;
            #endregion

            #region 添加房源图片

            if (imgUrlLists.Length > 0 && imgUrlLists.Length == imageTypeLists.Length &&
                (imgUrlLists.Length == imgDescribeLists.Length) && isChange == 1)
            {
                HouseBll houseBll = new HouseBll();
                houseBll.DelHouseImageByHouseID(houseId, uid);
                for (int i = 0; i < imgUrlLists.Length; i++)
                {
                    bool value = false;
                    if (imgUrlLists.Length > 1)
                    {
                        for (int j = i + 1; j < imgUrlLists.Length; j++)
                        {
                            if (i != j && imgUrlLists[i] == imgUrlLists[j])
                            {
                                value = true;
                            }
                        }
                    }

                    if (value == false && !string.IsNullOrEmpty(imgUrlLists[i]))
                    {
                        bool isCover = false;
                        if (imgUrlCover == imgUrlLists[i])
                        {
                            isCover = true;
                        }
                        HouseImage houseImage = new HouseImage();
                        houseImage.HouseID     = houseId;
                        houseImage.ImagePath   = imgUrlLists[i];
                        houseImage.ImagePos    = imgDescribeLists[i];
                        houseImage.ImageType   = HouseUtility.GetHouseImgType(imageTypeLists[i]);
                        houseImage.IsCover     = isCover;
                        houseImage.OrderID     = i;
                        houseImage.CommunityID = communityId;
                        houseImage.UserID      = uid;
                        houseImage.AddTime     = DateTime.Now;
                        houseImage.Status      = BitConverter.GetBytes(1)[0];;
                        ncBase.CurrentEntities.AddToHouseImage(houseImage);
                        ncBase.CurrentEntities.SaveChanges();
                    }
                }
            }

            #endregion

            bool isAdd = false;
            #region 房屋类型扩展信息
            switch (buildingType)
            {
            case (int)BuildingType.House:

                #region 住宅信息
                string basicEquipHouse = form["basicEquip"].IsNoNull() ? form["basicEquip"] : "";         //住宅基础设施
                string houseType       = form["houseType"].IsNoNull() ? form["houseType"] : "";           //房屋类别
                string houseSubType    = form["houseSubType"].IsNoNull() ? form["houseSubType"] : "";     //住宅子类型
                string houseProperty   = form["houseProperty"].IsNoNull() ? form["houseProperty"] : "";   //房屋产权
                string landYear        = form["landYear"].IsNoNull() ? form["landYear"] : "";             //产权年限
                string houseStructure  = form["houseStructure"].IsNoNull() ? form["houseStructure"] : ""; //房屋结构
                bool   fiveYears       = form["fiveYears"].IsNoNull() && form["fiveYears"] == "1";        //产证满二
                bool   onlyHouse       = form["onlyHouse"].IsNoNull() && form["onlyHouse"] == "1";        //唯一住房
                string advEquip        = form["advEquip"].IsNoNull() ? form["advEquip"] : "";             //配套设施

                HouseInfo houseInfo =
                    ncBase.CurrentEntities.HouseInfo.Where(o => o.HouseID.Equals(houseId)).FirstOrDefault();
                if (houseInfo.IsNull())
                {
                    houseInfo = new HouseInfo();
                    isAdd     = true; //标记为新增加
                }

                houseInfo.HouseID        = houseId;
                houseInfo.HouseType      = houseType;
                houseInfo.HouseSubType   = houseSubType;
                houseInfo.HouseProperty  = houseProperty;
                houseInfo.LandYear       = landYear;
                houseInfo.HouseStructure = houseStructure;
                houseInfo.FiveYears      = fiveYears;
                houseInfo.OnlyHouse      = onlyHouse;
                houseInfo.BasicEquip     = basicEquipHouse;
                houseInfo.AdvEquip       = advEquip;

                if (isAdd)
                {
                    ncBase.CurrentEntities.AddToHouseInfo(houseInfo);
                }
                ncBase.CurrentEntities.SaveChanges();
                #endregion

                break;

            case (int)BuildingType.Villa:

                #region 别墅信息

                string villaType   = form["villaType"].IsNoNull() ? form["villaType"] : "";      //别墅形式
                string hallType    = form["hallType"].IsNoNull() ? form["hallType"] : "";        //厅结构
                string landYear2   = form["landYear2"].IsNoNull() ? form["landYear2"] : "";      //产权年限
                bool   fiveYears2  = form["fiveYears2"].IsNoNull() && form["fiveYears2"] == "1"; //产证满二
                bool   onlyHouse2  = form["onlyHouse2"].IsNoNull() && form["onlyHouse2"] == "1"; //唯一住房
                bool   basement    = form["basement"].IsNoNull() && form["basement"] == "1";     //地下室
                bool   garden      = form["garden"].IsNoNull() && form["garden"] == "1";         //花园
                bool   garage      = form["garage"].IsNoNull() && form["garage"] == "1";         //车库
                bool   parkLot     = form["parkLot"].IsNoNull() && form["parkLot"] == "1";       //停车位
                string basicEquip1 = form["basicEquip1"].IsNoNull() ? form["basicEquip1"] : "";  //配套设施
                string advEquip1   = form["advEquip1"].IsNoNull() ? form["advEquip1"] : "";      //室内设施

                VillaInfo villaInfo =
                    ncBase.CurrentEntities.VillaInfo.Where(o => o.HouseID.Equals(houseId)).FirstOrDefault();
                if (villaInfo.IsNull())
                {
                    villaInfo = new VillaInfo();
                    isAdd     = true; //标记为新增加
                }

                villaInfo.HouseID    = houseId;
                villaInfo.VillaType  = villaType;
                villaInfo.HallType   = hallType;
                villaInfo.LandYear   = landYear2;
                villaInfo.OnlyHouse  = onlyHouse2;
                villaInfo.FiveYears  = fiveYears2;
                villaInfo.Basement   = basement;
                villaInfo.Garden     = garden;
                villaInfo.Garage     = garage;
                villaInfo.ParkLot    = parkLot;
                villaInfo.BasicEquip = basicEquip1;
                villaInfo.AdvEquip   = advEquip1;

                if (isAdd)
                {
                    ncBase.CurrentEntities.AddToVillaInfo(villaInfo);
                }
                ncBase.CurrentEntities.SaveChanges();
                #endregion

                break;

            case (int)BuildingType.Shop:

                #region 商铺信息

                string  shopType    = form["shopType"].IsNoNull() ? form["shopType"] : "";;       //商铺类型
                string  shopStatus  = form["shopStatus"].IsNoNull() ? form["shopStatus"] : "";;   //商铺状态
                string  targetField = form["targetField"].IsNoNull() ? form["targetField"] : "";; //目标业态
                decimal feeShop;
                decimal.TryParse(form["fee2"], out feeShop);                                      //物业费
                bool   divideShop  = form["divide2"].IsNoNull() && form["divide2"] == "1";        //是否分割
                string basicEquip2 = form["basicEquip2"].IsNoNull() ? form["basicEquip2"] : "";   //配套设施

                ShopInfo shopInfo =
                    ncBase.CurrentEntities.ShopInfo.Where(o => o.HouseID.Equals(houseId)).FirstOrDefault();
                if (shopInfo.IsNull())
                {
                    shopInfo = new ShopInfo();
                    isAdd    = true;  //标记为新增加
                }

                shopInfo.HouseID     = houseId;
                shopInfo.ShopType    = shopType;
                shopInfo.ShopStatus  = shopStatus;
                shopInfo.TargetField = targetField;
                shopInfo.Fee         = feeShop;
                shopInfo.Divide      = divideShop;
                shopInfo.BasicEquip  = basicEquip2;


                if (isAdd)
                {
                    ncBase.CurrentEntities.AddToShopInfo(shopInfo);
                }
                ncBase.CurrentEntities.SaveChanges();
                #endregion

                break;

            case (int)BuildingType.Office:

                #region 写字楼信息

                string  officeType  = form["officeType"].IsNoNull() ? form["officeType"] : "";   //写字楼类别
                string  officeLevel = form["officeLevel"].IsNoNull() ? form["officeLevel"] : ""; //写字楼级别
                decimal fee3;
                decimal.TryParse(form["fee3"], out fee3);                                        //物业费
                bool   divide3     = form["divide3"].IsNoNull() && form["divide3"] == "1";       //是否分割
                string basicEquip3 = form["basicEquip3"].IsNoNull() ? form["basicEquip3"] : "";  //配套设施


                OfficeInfo officeInfo =
                    ncBase.CurrentEntities.OfficeInfo.Where(o => o.HouseID.Equals(houseId)).FirstOrDefault();
                if (officeInfo.IsNull())
                {
                    officeInfo = new OfficeInfo();
                    isAdd      = true; //标记为新增加
                }

                officeInfo.HouseID     = houseId;
                officeInfo.OfficeType  = officeType;
                officeInfo.OfficeLevel = officeLevel;
                officeInfo.BasicEquip  = basicEquip3;
                officeInfo.Fee         = fee3;
                officeInfo.Divide      = divide3;


                if (isAdd)
                {
                    ncBase.CurrentEntities.AddToOfficeInfo(officeInfo);
                }
                ncBase.CurrentEntities.SaveChanges();
                #endregion

                break;

            case (int)BuildingType.Factory:

                #region 厂房信息

                string factoryType = form["factoryType"].IsNoNull() ? form["factoryType"] : "";      //厂房类别

                string basicEquip4 = form["basicEquip4"].IsNoNull() ? form["basicEquip4"] : "";      //基础设施


                FactoryInfo factoryInfo =
                    ncBase.CurrentEntities.FactoryInfo.Where(o => o.HouseID.Equals(houseId)).FirstOrDefault();
                if (factoryInfo.IsNull())
                {
                    factoryInfo = new FactoryInfo();
                    isAdd       = true; //标记为新增加
                }

                factoryInfo.HouseID     = houseId;
                factoryInfo.BasicEquip  = basicEquip4;
                factoryInfo.FactoryType = factoryType;

                if (isAdd)
                {
                    ncBase.CurrentEntities.AddToFactoryInfo(factoryInfo);
                }
                ncBase.CurrentEntities.SaveChanges();
                #endregion

                break;
            }
            #endregion

            return(RedirectToAction("GetHouseMainView", new { posttype = tradeType, buildType = buildingType }));
            // return JsonReturnValue(new { Message = "房源提交成功", id = houseId, }, JsonRequestBehavior.AllowGet);
        }
        public ActionResult InsertOfficeInfo([FromBody] OfficeInfo data, string username)
        {
            try
            {
                if (data != null && username != null)
                {
                    var checkOffice = MH.GetSingleObject(officeinfo_collection, "OfficeName", data.OfficeName, "Address", data.Address).Result;
                    if (checkOffice != null)
                    {
                        var officeInfo = BsonSerializer.Deserialize <OfficeInfo>(checkOffice);
                        if (officeInfo.IsActive == true)
                        {
                            return(BadRequest(new ResponseData
                            {
                                Code = "401",
                                Message = "Office with same office name and address is already added"
                            }));
                        }
                        else
                        {
                            var updateDefinition = Builders <BsonDocument> .Update.Set("IsActive", true);

                            update = MH.UpdateSingleObject(officeinfo_collection, "OfficeName", data.OfficeName, "Address", data.Address, updateDefinition);
                            var detail = officeInfo;
                            detail.IsActive = true;
                            AL.CreateLog(username, "InsertOfficeInfo", officeInfo, detail, activitylog_collection);
                            return(BadRequest(new ResponseData
                            {
                                Code = "402",
                                Message = "Office already added and its made active"
                            }));
                        }
                    }
                    else
                    {
                        #region Calculate office id
                        var getOffices = MH.GetListOfObjects(officeinfo_collection, null, null, null, null).Result;
                        if (getOffices.Count == 0)
                        {
                            data.OfficeId = "OF-1";
                        }
                        else
                        {
                            List <long> idList = new List <long>();
                            foreach (var office in getOffices)
                            {
                                OfficeInfo officeInfo  = BsonSerializer.Deserialize <OfficeInfo>(office);
                                long       seperatedId = Convert.ToInt64(officeInfo.OfficeId.Substring(officeInfo.OfficeId.LastIndexOf('-') + 1));
                                idList.Add(seperatedId);
                            }
                            var maxId = idList.Max();
                            data.OfficeId = "OF-" + (maxId + 1);
                            #endregion
                        }
                        data.IsActive = true;
                        var insert = MH.InsertNewOfficeInfo(data, officeinfoCollection);
                        if (insert == true)
                        {
                            AL.CreateLog(username, "InsertOfficeInfo", null, data, activitylog_collection);
                            return(Ok(new ResponseData
                            {
                                Code = "200",
                                Message = "Inserted",
                                Data = data
                            }));
                        }
                        else if (insert == false)
                        {
                            return(BadRequest(new ResponseData
                            {
                                Code = "403",
                                Message = "Office info with same id is already added"
                            }));
                        }
                        else
                        {
                            return(BadRequest(new ResponseData
                            {
                                Code = "400",
                                Message = "Failed",
                                Data = insert
                            }));
                        }
                    }
                }
                else
                {
                    return(BadRequest(new ResponseData
                    {
                        Code = "405",
                        Message = "Bad Request"
                    }));
                }
            }
            catch (Exception ex)
            {
                SL.CreateLog("OfficeController", "InsertOfficeInfo", ex.Message);
                return(BadRequest(new ResponseData
                {
                    Code = "400",
                    Message = "Failed",
                    Data = ex.Message
                }));
            }
        }
 public async Task OfficeInfoList_Get()
 {
     await Assert.ThrowsAsync <DataPortalException>(() => OfficeInfo.GetOfficeInfo(999));
 }