protected void Page_Load(object sender, System.EventArgs e) { prop_category = BookDBProvider.getDataSet("uspGetPropertyCategory", new List <SqlParameter>()); all_amenities = BookDBProvider.getDataSet("uspGetAllAmenity", new List <SqlParameter>()); allfurnitures = BookDBProvider.getDataSet("uspGetAllFurniture", new List <SqlParameter>()); json_allfurnitures = CommonProvider.getJsonStringFromDs(allfurnitures); allattractions = BookDBProvider.getDataSet("uspGetAllAttraction", new List <SqlParameter>()); //For new property if (propertyid == -1) { } else if (propertyid > 0) { //For the existed property propinfo = AjaxProvider.getPropertyDetailInfo(propertyid); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@propid", propertyid)); prop_amenities = BookDBProvider.getDataSet("uspGetPropertyAmenity", param); json_amenity = CommonProvider.getJsonStringFromDs(prop_amenities); json_propinfo = new JavaScriptSerializer().Serialize(propinfo); param.Clear(); param.Add(new SqlParameter("@propid", propertyid)); json_roomfurnitures = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetRoomFurnitures", param)); param.Clear(); param.Add(new SqlParameter("@propid", propertyid)); json_attractions = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetPropertyAttractionByID", param)); } }
public JsonResult processRequest() { JsonResult jsonresult = new JsonResult(); if (!AuthenticationManager.IfAuthenticated || !User.Identity.IsAuthenticated) { jsonresult.error = "Not Signed"; return(jsonresult); } else if (HttpContext.Current.Request.HttpMethod != "POST") { jsonresult.error = "The function works in POST method"; return(jsonresult); } //else{} //If the user is signed if (!Int32.TryParse(Request["propid"], out propid)) { propid = -1; } //Validate parameters from the request int wizard_step = -1; if (!Int32.TryParse(Request["wizardstep"], out wizard_step)) { wizard_step = -1; } if (wizard_step == -1) { jsonresult.error = "Wizard Step is not set."; return(jsonresult); } if (!ValdateWizardStep(wizard_step)) //Valdation for step parameters by step number { jsonresult.error = "Wizard Step is not set."; return(jsonresult); } if (wizard_step == 0 && (propid == -1 || propid == 0)) { propid = createNewProperty(); if (propid == -1) { jsonresult.error = "Server something wrong error: get new property id"; return(jsonresult); } } else //For the existed property { if (propid == -1 || propid == 0) { jsonresult.error = "Server something wrong error: step is not 0, and propid is -1"; return(jsonresult); } propinfo = AjaxProvider.getPropertyDetailInfo(propid); if (propinfo.UserID != userid && !AuthenticationManager.IfAdmin) { jsonresult.error = "You are trying to do malicious action. Property doesn't include to you."; return(jsonresult); } if (UpdatePropertyInfo(wizard_step) == -1) { jsonresult.error = "Server something wrong error: update property info step " + wizard_step; return(jsonresult); } } List <SqlParameter> param = new List <SqlParameter>(); if (propid > 0) { propinfo = AjaxProvider.getPropertyDetailInfo(propid); //Get the property id jsonresult.propinfo = propinfo; if (wizard_step == 1) { param.Add(new SqlParameter("@propid", propid)); amenity_list = MainHelper.getListFromDB <AmenityInfo>("uspGetPropertyAmenity", param); jsonresult.amenity_list = amenity_list; param.Clear(); param.Add(new SqlParameter("@propid", propid)); jsonresult.room_furniture = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetRoomFurnitures", param)); } else if (wizard_step == 2) { param.Clear(); param.Add(new SqlParameter("@propid", propid)); jsonresult.attractions = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetPropertyAttractionByID", param)); } } jsonresult.propid = propid; if (propid == propinfo.ID) { jsonresult.status = 0; } return(jsonresult); }