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");
}
}
