protected void Button1_Click(object sender, EventArgs e) { Users_DAL USErs = new Users_DAL(); foreach (var z in USErs.select_All()) { if (z.Email == TextBox1.Text && z.User_Password == TextBox2.Text) { if (z.FK_Role == 3) { HttpCookie local1 = new HttpCookie("admin_server"); local1.Values.Add("admin_email", TextBox1.Text); local1.Values.Add("admin_password", TextBox2.Text); Response.Cookies.Add(local1); Response.Redirect("/Admin_Pages/Apartment_Page.aspx"); } else if (z.FK_Role == 1) { HttpCookie local = new HttpCookie("user_server"); local.Values.Add("user_email", TextBox1.Text); local.Values.Add("user_password", TextBox2.Text); local.Values.Add("user_ID", z.ID.ToString()); Response.Cookies.Add(local); Response.Redirect("User_Main_Page.aspx"); } } else { Label3.Text = "wrong"; } } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie local = Request.Cookies["user_server"]; if (Request.Cookies["user_server"] != null) { local = Request.Cookies["user_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label1.Text = local.Values["user_ID"]; } } } else { Response.Redirect("/User_Pages/Update_To_Appartment.aspx"); } }
/// <summary> /// demo /// </summary> /// <param name="userM"></param> /// <returns></returns> public Enums.TickLingEnum InsertEntity(Users userM) { using (var dal = new Users_DAL()) { return(dal.Insert(userM)); } }
//Update HR/CLERK Information public static int UpdateClerk_BLL(Users user) { int rowsAffected = 0; try { if (ValidateUser(user)) { rowsAffected = Users_DAL.UpdateClerk(user); } else { throw new HRMSException("Please provide valid HR/Clerk Information"); } } catch (HRMSException ex) { throw ex; } catch (SqlException ex) { throw ex; } catch (SystemException ex) { throw ex; } return(rowsAffected); }
protected void Page_Load(object sender, EventArgs e) { HttpCookie local = Request.Cookies["user_server"]; if (Request.Cookies["user_server"] != null) { TextBox1.Text = local.Values["user_ID"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label1.Text = "Hi" + " " + item.First_Name; } } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } if (Page.IsPostBack == false) { Messages_DAL get_message = new Messages_DAL(); var messages = get_message.select_All(); Users_DAL usres = new Users_DAL(); List <Users_DATA> all_users = usres.select_All(); List <Users_DATA> Users_Message_Recipient = new List <Users_DATA>(); foreach (var item in messages) { if (Users_Message_Recipient.All(x => x.ID != item.FK_Users_Message_Recipient && (Convert.ToInt16(local.Values["user_ID"]) == item.FK_Users_Message_Recipient || Convert.ToInt16(local.Values["user_ID"]) == item.FK_Users_Message_sender))) { Users_Message_Recipient.Add(all_users.Single(x => x.ID == item.FK_Users_Message_Recipient)); } } foreach (var item in Users_Message_Recipient) { if (Convert.ToInt16(local.Values["user_ID"]) != item.ID) { ListItem n = new ListItem(); n.Text = item.First_Name; n.Value = item.ID.ToString(); ListBox1.Items.Add(n); } } } }
protected void Button2_Click1(object sender, EventArgs e) { HttpCookie local = Request.Cookies["user_server"]; Apartments_DATA apartment = new Apartments_DATA(); Building_DATA building = new Building_DATA(); Roles_DATA roles = new Roles_DATA(); Users_DATA user = new Users_DATA(); Location_OF_Building_DATA location = new Location_OF_Building_DATA(); Purpose_Apartment_DATA purpose = new Purpose_Apartment_DATA(); Apartments_DAL apartment_inset = new Apartments_DAL(); Building_DAL building_inset = new Building_DAL(); Roles_DAL roles_inset = new Roles_DAL(); Users_DAL user_inset = new Users_DAL(); Location_OF_Building_DAL location_inset = new Location_OF_Building_DAL(); Purpose_Apartment_DAL purpose_inset = new Purpose_Apartment_DAL(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["admin_server"] != null) { HttpCookie local = Request.Cookies["admin_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["admin_email"]) { Label1.Text = "Hi" + " " + item.First_Name; } } } }
//Add User Validation Information public static int AddClerk_BLL(Users newUser) { int rowsAffected = 0; try { if (ValidateUser(newUser)) { rowsAffected = Users_DAL.AddClerk(newUser); } else { throw new HRMSException("\nPlease provide valid User Information"); } } catch (HRMSException ex) { throw ex; } catch (SqlException se) { throw se; } catch (SystemException ex) { throw ex; } return(rowsAffected); }
//Login HR/CLERK Information public static bool ClerkLogin(Users userLogin, string userName, string password, int roleId) { bool rowsAffected = false; try { if (ValidateLogin(userLogin)) { rowsAffected = Users_DAL.VerifyLogin(userName, password, roleId); } else { throw new Exception("\nPlease provide valid Login Details"); } } catch (HRMSException ex) { throw ex; } return(rowsAffected); }
protected void Button1_Click(object sender, EventArgs e) { Users_DAL INsrt_users = new Users_DAL(); Users_DATA User = new Users_DATA(); User.City = city.Text; User.Country = country.Text; User.Email = email.Text; User.First_Name = first_name.Text; User.Gender = Gender.SelectedItem.Text; User.Governorate = government.Text; User.Phone_Number = int.Parse(phone.Text); User.Last_Name = last_name.Text; User.FK_Role = 1; User.User_Password = password.Text; INsrt_users.insert(User); }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user_server"] != null) { HttpCookie local = Request.Cookies["user_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label1.Text = "from " + item.First_Name; } } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } }
//Display HR/Clerk Information public static DataTable DisplayClerk_BLL() { DataTable dtEmp; try { dtEmp = Users_DAL.DisplayUsers(); } catch (HRMSException ex) { throw ex; } catch (SqlException se) { throw se; } catch (Exception ex) { throw ex; } return(dtEmp); }
//Search HR/CLERK Information public static DataTable SearchClerk_BLL(int userId) { DataTable dtEmp; try { dtEmp = Users_DAL.SearchUserById(userId); } catch (HRMSException ex) { throw ex; } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } return(dtEmp); }
//Delete HR/CLERK Information public static int DeleteClerk_BLL(int userId) { int rowsAffected = 0; try { rowsAffected = Users_DAL.DeleteClerk(userId); } catch (HRMSException ex) { throw ex; } catch (SqlException ex) { throw ex; } catch (SystemException ex) { throw ex; } return(rowsAffected); }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user_server"] != null) { HttpCookie local = Request.Cookies["user_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label13.Text = "Hi" + " " + item.First_Name; } } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } if (Page.IsPostBack) { ViewState.Add("Bulding_Max_area", Bulding_Max_area.Text); ViewState.Add("Bulding_Min_area", Bulding_Min_area.Text); ViewState.Add("Room_Max_Number", Room_Max_Number.Text); ViewState.Add("Room_Min_Number", Room_Min_Number.Text); ViewState.Add("Total_Max_Cost", Total_Max_Cost.Text); ViewState.Add("Total_Min_Cost", Total_Min_Cost.Text); // ViewState.Add("Purpose", Purpose.SelectedValue); // ViewState.Add("Purpose", TextBox1.Text); //TextBox1.Text = Purpose.SelectedItem.Value; ViewState.Add("Land_Max_area", Land_Max_area.Text); ViewState.Add("Land_Min_area", Land_Min_area.Text); ViewState.Add("Total_Max_Cost_Land", Total_Max_Cost_Land.Text); ViewState.Add("Total_Min_Cost_Land", Total_Min_Cost_Land.Text); } if (!Page.IsPostBack) { //Purpose_Apartment_DAL Purpose_item_building = new Purpose_Apartment_DAL(); //foreach (var item in Purpose_item_building.select_All()) //{ //} //{ // ListItem listitem = new ListItem(item.Name, item.ID.ToString()); // Purpose.Items.Add(listitem); //} Type_property.Items.Add("Building"); Type_property.Items.Add("Lands"); MultiView1.ActiveViewIndex = 0; //Apartments_DAL Apartment = new Apartments_DAL(); //List<string> list = new List<string>(); //foreach (var item in Apartment.select_All()) //{ // ListItem listitem = new ListItem(item.Apartments_Type, item.Apartments_Type); // Type_Of_Building.Items.Add(listitem); // foreach (var item_list in list) // { if (item.Apartments_Type == item_list.ToString()) // Type_Of_Building.Items.Remove(listitem); // } // list.Add(item.Apartments_Type); //} } //............................................................. //Filter_DATA filter_obj=new Filter_DATA(); //int n =int.Parse( Bulding_Max_area.Text); // int x = Convert.ToInt16(Bulding_Miv_area.Text); // int y = Convert.ToInt16(Room_Max_Number.Text); // int z = Convert.ToInt16(Room_Min_Number.Text); // int v = Convert.ToInt16(Total_Max_Cost.Text); // int b = Convert.ToInt16(Total_Min_Cost.Text); //filter_obj.Filter(n,x,y,z,v,b, Location_Search_Building.Text); }
public Users_BL() { dal = new Users_DAL(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user_server"] != null) { HttpCookie local = Request.Cookies["user_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label13.Text = "Hi" + " " + item.First_Name; } } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } if (Page.IsPostBack) { ViewState.Add("Bulding_Max_area", Bulding_Max_area.Text); ViewState.Add("Bulding_Min_area", Bulding_Min_area.Text); ViewState.Add("Room_Max_Number", Room_Max_Number.Text); ViewState.Add("Room_Min_Number", Room_Min_Number.Text); ViewState.Add("Total_Max_Cost", Total_Max_Cost.Text); ViewState.Add("Total_Min_Cost", Total_Min_Cost.Text); // ViewState.Add("Purpose", Purpose.SelectedValue); // ViewState.Add("Purpose", TextBox1.Text); //TextBox1.Text = Purpose.SelectedItem.Value; ViewState.Add("Land_Max_area", Land_Max_area.Text); ViewState.Add("Land_Min_area", Land_Min_area.Text); ViewState.Add("Total_Max_Cost_Land", Total_Max_Cost_Land.Text); ViewState.Add("Total_Min_Cost_Land", Total_Min_Cost_Land.Text); } if (!Page.IsPostBack) { //Purpose_Apartment_DAL Purpose_item_building = new Purpose_Apartment_DAL(); //foreach (var item in Purpose_item_building.select_All()) //{ //} //{ // ListItem listitem = new ListItem(item.Name, item.ID.ToString()); // Purpose.Items.Add(listitem); //} Type_property.Items.Add("Building"); Type_property.Items.Add("Lands"); MultiView1.ActiveViewIndex = 0; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user_server"] != null) { HttpCookie local = Request.Cookies["user_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label1.Text = item.First_Name; } } Apartments_DAL apartment = new Apartments_DAL(); Apartments_DATA a = apartment.select_Item(Convert.ToInt16(Request.QueryString["ID"])); Area.Text = a.Area.ToString(); Disription.Text = a.Descriptions; //price_per_meter.Text = a.Price_Per_meter.ToString(); Design_img.ImageUrl = "../images/" + a.Design_Image; Image1.ImageUrl = "../images/" + a.Image_1; Image2.ImageUrl = "../images/" + a.Image_2; Image3.ImageUrl = "../images/" + a.Image_3; Design_img1.ImageUrl = "../images/" + a.Design_Image; Image4.ImageUrl = "../images/" + a.Image_1; Image5.ImageUrl = "../images/" + a.Image_2; Image6.ImageUrl = "../images/" + a.Image_3; Total_Price.Text = (a.Price_Per_meter * a.Area).ToString(); // price_per_meter.Text = a.Price_Per_meter.ToString(); Building_DAL b = new Building_DAL(); Building_DATA d = new Building_DATA(); d = b.select_All().SingleOrDefault(x => x.ID == a.FK_Building); Location_OF_Building_DAL location = new Location_OF_Building_DAL(); Location_OF_Building_DATA l = new Location_OF_Building_DATA(); l = location.select_All().SingleOrDefault(x => x.ID == d.FK_Location_OF_Building); Country.Text = l.Country; City.Text = l.City; Govern.Text = l.Governorate; List <Room_DATA> room = new List <Room_DATA>(); Room_DAL room_Dal = new Room_DAL(); room = room_Dal.select_All().Where(x => x.FK_Apartment == a.ID).ToList(); Who_See_Announce_DAL who_see_announce_Insert = new Who_See_Announce_DAL(); Who_See_Announce_DATA who_see_announce = new Who_See_Announce_DATA(); who_see_announce.Owner_ID = a.FK_Users; who_see_announce.Visitor_ID = Convert.ToInt16(local.Values["user_ID"]); who_see_announce.ID_Apartment = a.ID; who_see_announce.Owner_visitor_apartment_ID = (who_see_announce.Visitor_ID.ToString() + who_see_announce.ID_Apartment.ToString() + who_see_announce.ID_Apartment.ToString()); if (who_see_announce.Visitor_ID != who_see_announce.Owner_ID) { who_see_announce_Insert.insert(who_see_announce); } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } }
protected void apply_Click1(object sender, EventArgs e) { try { HttpCookie local = Request.Cookies["user_server"]; Apartments_DATA apartment = new Apartments_DATA(); Building_DATA building = new Building_DATA(); Roles_DATA roles = new Roles_DATA(); Users_DATA user = new Users_DATA(); Location_OF_Building_DATA location = new Location_OF_Building_DATA(); Purpose_Apartment_DATA purpose = new Purpose_Apartment_DATA(); Apartments_DAL apartment_inset = new Apartments_DAL(); Building_DAL building_inset = new Building_DAL(); Roles_DAL roles_inset = new Roles_DAL(); Users_DAL user_inset = new Users_DAL(); Location_OF_Building_DAL location_inset = new Location_OF_Building_DAL(); Purpose_Apartment_DAL purpose_inset = new Purpose_Apartment_DAL(); location.ID = Convert.ToInt16(Label2.Text); location.City = city.Text; location.Country = country.Text; location.Governorate = government.Text; location.Numer_of_Building = Convert.ToInt16(building_number.Text); location.Street_NAME = street_name.Text; location_inset.update(location); building.ID = Convert.ToInt16(Label3.Text); building.Area = Convert.ToInt16(building_area.Text); building.Descriptions = building_description.Text; building.Floor_Number = Convert.ToInt16(floor.Text); building.Year_Of_Building = building_year.SelectedDate; building.Image_1 = ViewState["building_img1"].ToString(); building.Desgin_Image = ViewState["building_deign"].ToString(); building.FK_Location_OF_Building = location.ID; building_inset.update(building); apartment.ID = Convert.ToInt16(Label4.Text); apartment.Area = Convert.ToInt16(apartment_area.Text); apartment.Avalable = 1; apartment.Descriptions = apartment_Description.Text; apartment.Image_1 = ViewState["imge1"].ToString(); apartment.Image_2 = ViewState["imge2"].ToString(); apartment.Image_3 = ViewState["imge3"].ToString(); apartment.Design_Image = ViewState["apartment_design"].ToString(); apartment.Price_Per_meter = Convert.ToInt16(price.Text); apartment.Apartments_Type = apartment_type.Text; apartment.FK_Building = building.ID; apartment.FK_Purpoes_Apartment = Convert.ToInt16(apartment_purpose.SelectedValue); apartment.FK_Users = Convert.ToInt16(local.Values["user_ID"]); apartment_inset.update(apartment); Room_DATA room = new Room_DATA(); Room_DAL room_update = new Room_DAL(); List <Room_DATA> room_list = new List <Room_DATA>(); room_list = room_update.select_All().Where(x => x.FK_Apartment == apartment.ID).ToList(); for (int i = 0; i < update_panel; i++) { try { Panel mylable = new Panel(); TextBox area = new TextBox(); FileUpload imge1 = new FileUpload(); Image image = new Image(); TextBox Room_Name = new TextBox(); TextBox ID = new TextBox(); DropDownList FK_Room_Type = new DropDownList(); Button button = new Button(); Button cancel = new Button(); TextBox lable_ID = new TextBox(); Room_Type_DAL room_type = new Room_Type_DAL(); room_type.select_All(); foreach (var item in room_type.select_All()) { ListItem listitem = new ListItem(); listitem.Text = item.Room_Type_Name; listitem.Value = item.ID.ToString(); FK_Room_Type.Items.Add(listitem); } mylable = (Panel)View4.FindControl("panal" + i); image = (Image)mylable.FindControl("image" + mylable.ID); room.Image_1 = image.ImageUrl; ID.ID = "ID" + mylable.ID; area = (TextBox)mylable.FindControl("Area" + mylable.ID); room.Area = Convert.ToInt16(area.Text); Room_Name = (TextBox)mylable.FindControl("Room_Name" + mylable.ID); room.Room_Name = Room_Name.Text; FK_Room_Type = (DropDownList)mylable.FindControl("FK_Room_Type" + mylable.ID); room.FK_Room_Type = Convert.ToInt16(FK_Room_Type.SelectedValue); room.FK_Apartment = apartment.ID; ID = (TextBox)mylable.FindControl("ID" + mylable.ID); room.ID = Convert.ToInt16(ID.Text); //lable_ID= (TextBox)mylable.FindControl("ID" + mylable.ID); //room.ID =Convert.ToInt16( lable_ID.Text); //lable_ID.Visible = false; //room =room_list[i]; room_update.update(room); room_list = room_list.Where(x => x.ID != room.ID).ToList(); } catch { } } foreach (var item in room_list) { room_update.delete(item); } for (int i = update_panel; i < count; i++) { Panel mylable = new Panel(); TextBox area = new TextBox(); FileUpload imge1 = new FileUpload(); Image image = new Image(); TextBox Room_Name = new TextBox(); DropDownList FK_Room_Type = new DropDownList(); Button button = new Button(); Button cancel = new Button(); mylable.ID = "IDpanal" + i; button.ID = "button_ADD" + "panal" + i; button.Text = "add"; button.Click += Button_Click; cancel.ID = "button_cancel" + "panal" + i; cancel.Text = "cancel"; cancel.Click += Cancel_Click; image.ID = "image" + mylable.ID; area.ID = "area" + mylable.ID; imge1.ID = "imge1" + mylable.ID; Room_Name.ID = "Room_Name" + mylable.ID; FK_Room_Type.ID = "FK_Room_Type" + mylable.ID; Room_Type_DAL room_type = new Room_Type_DAL(); room_type.select_All(); foreach (var item in room_type.select_All()) { ListItem listitem = new ListItem(); listitem.Text = item.Room_Type_Name; listitem.Value = item.ID.ToString(); FK_Room_Type.Items.Add(listitem); } //mylable.Controls.Add(area); //mylable.Controls.Add(Room_Name); //mylable.Controls.Add(FK_Room_Type); //mylable.Controls.Add(imge1); //mylable.Controls.Add(button); //mylable.Controls.Add(cancel); //mylable.Controls.Add(image); //View4.Controls.Add(mylable); //room.Image_1 = image.ImageUrl; //room.Area = Convert.ToInt16(area.Text); //room.Room_Name = Room_Name.Text; //room.FK_Room_Type = Convert.ToInt16(FK_Room_Type.SelectedValue); //room.FK_Apartment = apartment.ID; mylable = (Panel)View4.FindControl("panal" + i); area = (TextBox)mylable.FindControl("area" + mylable.ID); imge1 = (FileUpload)mylable.FindControl("imge1" + mylable.ID); Room_Name = (TextBox)mylable.FindControl("Room_Name" + mylable.ID); FK_Room_Type = (DropDownList)mylable.FindControl("FK_Room_Type" + mylable.ID); image = (Image)mylable.FindControl("image" + mylable.ID); room.Area = Convert.ToInt16(area.Text); room.Image_1 = image.ImageUrl; room.Room_Name = Room_Name.Text; room.FK_Room_Type = Convert.ToInt16(FK_Room_Type.SelectedValue); room.FK_Apartment = apartment.ID; // room = room_list[i]; room_update.insert(room); } } catch { }; }
// List<int> list_ID = new List<int>(); protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { Apartments_DATA apartment = new Apartments_DATA(); Building_DATA building = new Building_DATA(); Roles_DATA roles = new Roles_DATA(); Location_OF_Building_DATA location = new Location_OF_Building_DATA(); Purpose_Apartment_DATA purpose = new Purpose_Apartment_DATA(); Apartments_DAL apartment_select_item = new Apartments_DAL(); Building_DAL building_select_item = new Building_DAL(); Roles_DAL roles_select_item = new Roles_DAL(); Users_DAL user_select_item = new Users_DAL(); Location_OF_Building_DAL location_select_item = new Location_OF_Building_DAL(); Purpose_Apartment_DAL purpose_select_item = new Purpose_Apartment_DAL(); //Room_DAL room_select = new Room_DAL(); Room_DATA room = new Room_DATA(); Apartments_DATA apartments = new Apartments_DATA(); Apartments_DAL apartment_select = new Apartments_DAL(); apartments = apartment_select.select_Item(Convert.ToInt16(Request.QueryString["id"])); HttpCookie local2 = Request.Cookies["user_server"]; if (Request.QueryString["id"] != "" && apartments.FK_Users == Convert.ToInt16(local2.Values["user_ID"])) { Users_DATA user = new Users_DATA(); id = Convert.ToInt16(Request.QueryString["id"]); HttpCookie local = Request.Cookies["user_server"]; apartment = apartment_select_item.select_Item(id); apartment_area.Text = apartment.Area.ToString(); apartment_Description.Text = apartment.Descriptions; Image3.ImageUrl = "~/images/" + apartment.Image_1; Image4.ImageUrl = "~/images/" + apartment.Image_2; Image7.ImageUrl = "~/images/" + apartment.Image_3; Image6.ImageUrl = "~/images/" + apartment.Design_Image; Label4.Text = apartment.ID.ToString(); price.Text = apartment.Price_Per_meter.ToString(); apartment_type.Text = apartment.Apartments_Type; building = building_select_item.select_Item(apartment.FK_Building); Label3.Text = building.ID.ToString(); Image1.ImageUrl = "~/images/" + building.Image_1; Image2.ImageUrl = "~/images/" + building.Desgin_Image; List <Room_DATA> list_Rooms = room_select.select_All().Where(x => x.FK_Apartment == apartment.ID).ToList(); for (int i = 0; i < list_Rooms.Count(); i++) { update_panel++; } count = update_panel; ViewState.Add("count", count); ViewState.Add("update_panel", update_panel); building_area.Text = building.Area.ToString(); building_description.Text = building.Descriptions; floor.Text = building.Floor_Number.ToString(); building_year.SelectedDate = building.Year_Of_Building; //building.Image_1 = ViewState["building_img1"].ToString(); // building.Desgin_Image = ViewState["building_deign"].ToString(); location = location_select_item.select_Item(building.FK_Location_OF_Building); city.Text = location.City; country.Text = location.Country; government.Text = location.Governorate; building_number.Text = location.Numer_of_Building.ToString(); street_name.Text = location.Street_NAME; Label2.Text = building.FK_Location_OF_Building.ToString(); } if (Page.IsPostBack == false) { MultiView1.ActiveViewIndex = 0; } if (Request.Cookies["user_server"] != null) { HttpCookie local = Request.Cookies["user_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label1.Text = "Hi" + " " + item.First_Name; } } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } } count = Convert.ToInt16(ViewState["count"]); update_panel = Convert.ToInt16(ViewState["update_panel"]); Apartments_DAL apartment_select_items = new Apartments_DAL(); Apartments_DATA Update_apartment = new Apartments_DATA(); id = Convert.ToInt16(Request.QueryString["id"]); Update_apartment = apartment_select_items.select_Item(id); //Room_DATA room = new Room_DATA(); List <Room_DATA> list_Room = room_select.select_All().Where(x => x.FK_Apartment == Update_apartment.ID).ToList(); if (Page.IsPostBack == true && MultiView1.ActiveViewIndex == 3) { for (int i = 0; i < update_panel; i++) { try { Panel mylable = new Panel(); TextBox area = new TextBox(); FileUpload imge1 = new FileUpload(); Image image = new Image(); TextBox Room_Name = new TextBox(); DropDownList FK_Room_Type = new DropDownList(); Button button = new Button(); Button cancel = new Button(); TextBox ID = new TextBox(); mylable.ID = "panal" + i; button.ID = "button_ADD" + "panal" + i; button.Text = "add"; button.Click += Button_Click; cancel.ID = "button_cancel" + "panal" + i; cancel.Text = "cancel"; cancel.Click += Cancel_Click1;; image.ID = "image" + mylable.ID; area.ID = "area" + mylable.ID; imge1.ID = "imge1" + mylable.ID; Room_Name.ID = "Room_Name" + mylable.ID; ID.ID = "ID" + mylable.ID; FK_Room_Type.ID = "FK_Room_Type" + mylable.ID; Room_Type_DAL room_type = new Room_Type_DAL(); room_type.select_All(); foreach (var item in room_type.select_All()) { ListItem listitem = new ListItem(); listitem.Text = item.Room_Type_Name; listitem.Value = item.ID.ToString(); FK_Room_Type.Items.Add(listitem); } area.Text = list_Room[i].Area.ToString(); Room_Name.Text = list_Room[i].Room_Name.ToString(); image.ImageUrl = list_Room[i].Image_1.ToString(); image.Height = 100; image.Width = 100; FK_Room_Type.SelectedValue = list_Room[i].FK_Room_Type.ToString(); ID.Text = list_Room[i].ID.ToString(); mylable.Controls.Add(area); mylable.Controls.Add(Room_Name); mylable.Controls.Add(FK_Room_Type); mylable.Controls.Add(imge1); mylable.Controls.Add(ID); mylable.Controls.Add(button); mylable.Controls.Add(cancel); mylable.Controls.Add(image); View4.Controls.Add(mylable); ID.Visible = false; } catch { } } if (count > update_panel) { for (int i = update_panel; i < count; i++) { Panel mylable = new Panel(); TextBox area = new TextBox(); FileUpload imge1 = new FileUpload(); Image image = new Image(); TextBox Room_Name = new TextBox(); DropDownList FK_Room_Type = new DropDownList(); Button button = new Button(); Button cancel = new Button(); mylable.ID = "panal" + i; button.ID = "button_ADD" + "panal" + i; button.Text = "add"; button.Click += Button_Click; cancel.ID = "button_cancel" + "panal" + i; cancel.Text = "cancel"; cancel.Click += Cancel_Click; image.ID = "image" + mylable.ID; area.ID = "area" + mylable.ID; imge1.ID = "imge1" + mylable.ID; Room_Name.ID = "Room_Name" + mylable.ID; FK_Room_Type.ID = "FK_Room_Type" + mylable.ID; Room_Type_DAL room_type = new Room_Type_DAL(); room_type.select_All(); foreach (var item in room_type.select_All()) { ListItem listitem = new ListItem(); listitem.Text = item.Room_Type_Name; listitem.Value = item.ID.ToString(); FK_Room_Type.Items.Add(listitem); } mylable.Controls.Add(area); mylable.Controls.Add(Room_Name); mylable.Controls.Add(FK_Room_Type); mylable.Controls.Add(imge1); mylable.Controls.Add(button); mylable.Controls.Add(cancel); mylable.Controls.Add(image); View4.Controls.Add(mylable); } { } } } }
protected void apply_Click1(object sender, EventArgs e) { HttpCookie local = Request.Cookies["user_server"]; Apartments_DATA apartment = new Apartments_DATA(); Building_DATA building = new Building_DATA(); Roles_DATA roles = new Roles_DATA(); Users_DATA user = new Users_DATA(); Location_OF_Building_DATA location = new Location_OF_Building_DATA(); Purpose_Apartment_DATA purpose = new Purpose_Apartment_DATA(); Room_DATA room = new Room_DATA(); Apartments_DAL apartment_inset = new Apartments_DAL(); Building_DAL building_inset = new Building_DAL(); Roles_DAL roles_inset = new Roles_DAL(); Users_DAL user_inset = new Users_DAL(); Location_OF_Building_DAL location_inset = new Location_OF_Building_DAL(); Purpose_Apartment_DAL purpose_inset = new Purpose_Apartment_DAL(); Room_DAL room_insert = new Room_DAL(); location.City = city.Text; location.Country = country.Text; location.Governorate = government.Text; location.Numer_of_Building = Convert.ToInt16(building_number.Text); location.Street_NAME = street_name.Text; location_inset.insert(location); building.Area = Convert.ToInt16(building_area.Text); building.Descriptions = building_description.Text; building.Floor_Number = Convert.ToInt16(floor.Text); building.Year_Of_Building = building_year.SelectedDate; building.Image_1 = ViewState["building_img1"].ToString(); building.Desgin_Image = ViewState["building_deign"].ToString(); building.FK_Location_OF_Building = location_inset.select_All().Last().ID; building_inset.insert(building); building = building_inset.select_All().Last(); apartment.Area = Convert.ToInt16(apartment_area.Text); apartment.Avalable = 1; apartment.Descriptions = apartment_Description.Text; apartment.Image_1 = ViewState["imge1"].ToString(); apartment.Image_2 = ViewState["imge2"].ToString(); apartment.Image_3 = ViewState["imge3"].ToString(); apartment.Design_Image = ViewState["apartment_design"].ToString(); apartment.Price_Per_meter = Convert.ToInt16(price.Text); apartment.Apartments_Type = apartment_type.Text; apartment.FK_Building = building.ID; apartment.FK_Purpoes_Apartment = Convert.ToInt16(apartment_purpose.SelectedValue); apartment.FK_Users = Convert.ToInt16(local.Values["user_ID"]); apartment_inset.insert(apartment); apartment = apartment_inset.select_All().Last(); count = Convert.ToInt16(ViewState["count"]); for (int i = 0; i < count; i++) { Panel mylable = new Panel(); TextBox area = new TextBox(); FileUpload imge1 = new FileUpload(); Image image = new Image(); TextBox Room_Name = new TextBox(); DropDownList FK_Room_Type = new DropDownList(); mylable = (Panel)View4.FindControl("panal" + i); area = (TextBox)mylable.FindControl("area" + mylable.ID); imge1 = (FileUpload)mylable.FindControl("imge1" + mylable.ID); Room_Name = (TextBox)mylable.FindControl("Room_Name" + mylable.ID); FK_Room_Type = (DropDownList)mylable.FindControl("FK_Room_Type" + mylable.ID); image = (Image)mylable.FindControl("image" + mylable.ID); room.Area = Convert.ToInt16(area.Text); room.Image_1 = image.ImageUrl; room.Room_Name = Room_Name.Text; room.FK_Room_Type = Convert.ToInt16(FK_Room_Type.SelectedValue); room.FK_Apartment = apartment.ID; room_insert.insert(room); } Response.Redirect("/User_Pages/announc.aspx"); }
protected void Page_Load(object sender, EventArgs e) { count = Convert.ToInt16(ViewState["count"]); //for (int i = 0; i < count; i++) //{ // TextBox mylable = new TextBox(); // mylable.ID = "" + i; // View4.Controls.Add(mylable); //} for (int i = 0; i < count; i++) { Panel mylable = new Panel(); TextBox area = new TextBox(); FileUpload imge1 = new FileUpload(); Image image = new Image(); TextBox Room_Name = new TextBox(); Label Room_Name_lab = new Label(); Label area_lab = new Label(); DropDownList FK_Room_Type = new DropDownList(); Button button = new Button(); Button cancel = new Button(); mylable.ID = "panal" + i; button.ID = "button_ADD" + "panal" + i; button.Text = "add"; button.Click += Button_Click; cancel.ID = "button_cancel" + "panal" + i; cancel.Text = "cancel"; cancel.Click += Cancel_Click; image.ID = "image" + mylable.ID; image.Height = 100; image.Width = 100; area.ID = "area" + mylable.ID; imge1.ID = "imge1" + mylable.ID; Room_Name.ID = "Room_Name" + mylable.ID; FK_Room_Type.ID = "FK_Room_Type" + mylable.ID; Room_Name_lab.Text = "room name"; area_lab.Text = "room area"; Room_Name_lab.ControlStyle.ForeColor = System.Drawing.Color.Blue; area_lab.ControlStyle.ForeColor = System.Drawing.Color.Blue; Room_Type_DAL room_type = new Room_Type_DAL(); room_type.select_All(); foreach (var item in room_type.select_All()) { ListItem listitem = new ListItem(); listitem.Text = item.Room_Type_Name; listitem.Value = item.ID.ToString(); FK_Room_Type.Items.Add(listitem); } mylable.Controls.Add(area_lab); mylable.Controls.Add(area); mylable.Controls.Add(Room_Name_lab); mylable.Controls.Add(Room_Name); mylable.Controls.Add(FK_Room_Type); mylable.Controls.Add(imge1); mylable.Controls.Add(button); mylable.Controls.Add(cancel); mylable.Controls.Add(image); View4.Controls.Add(mylable); } if (Page.IsPostBack == false) { MultiView1.ActiveViewIndex = 0; } if (Request.Cookies["user_server"] != null) { HttpCookie local = Request.Cookies["user_server"]; Users_DAL user = new Users_DAL(); foreach (var item in user.select_All()) { if (item.Email == local.Values["user_email"]) { Label1.Text = "Hi" + " " + item.First_Name; } } } else { Response.Redirect("/User_Pages/User_Main_Page.aspx"); } }