protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string cityID = GridView1.DataKeys[e.RowIndex].Value.ToString(); CityDAO.DeleteCity(cityID); ShowDataCity(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = CityDAO.GetDataCity(); int t = dt.Rows.Count; cboFromCity.DataSource = CityDAO.GetDataCity(); cboFromCity.DataTextField = "CityName"; cboFromCity.DataValueField = "CityID"; cboToCity.DataSource = CityDAO.GetDataCity(); cboToCity.DataTextField = "CityName"; cboToCity.DataValueField = "CityID"; cboFromCity.DataBind(); cboToCity.DataBind(); } if (Session["msg"] != null) { string msg = Session["msg"].ToString(); lbNeedSearch.Text = msg; Session.Remove("msg"); } else { lbNeedSearch.Text = ""; } }
public AddUserViewModel() { AddUserCommand = new RelayCommand(AddUser); ToUsersManagementTabCommand = new RelayCommand(ToUsersManagementTab); SelectedDate = new DateTime(1970, 1, 1); Cities = CityDAO.GetCitiesQuery().ToObservableCollection(); }
public UsersManagementViewModel(User selectedUser) { EditCommand = new RelayCommand(Edit); ToEditTabCommand = new RelayCommand(ToEditTab); GetListUsersCommand = new RelayCommand(GetListUsers); ToAddTabCommand = new RelayCommand(ToAddTab); RemoveCommand = new RelayCommand(Remove); ToUsersManagementTabCommand = new RelayCommand(ToUsersManagementTab); Cities = CityDAO.GetCitiesQuery().ToObservableCollection(); LoadData(selectedUser); SelectedUser = selectedUser; }
public UsersManagementViewModel() { EditCommand = new RelayCommand(Edit); ToEditTabCommand = new RelayCommand(ToEditTab); GetListUsersCommand = new RelayCommand(GetListUsers); ToAddTabCommand = new RelayCommand(ToAddTab); RemoveCommand = new RelayCommand(Remove); ToAddAppointmentTabCommand = new RelayCommand(ToAddAppointmentTab); ToUsersManagementTabCommand = new RelayCommand(ToUsersManagementTab); ToAdminPanelCommand = new RelayCommand(ToAdminPanel); Cities = CityDAO.GetCitiesQuery().ToObservableCollection(); }
public User(string firstname, string lastname, string cin, DateTime selectedDate, string password, bool superUser, string phoneNumber, string role, string city) { this.Fisrtname = firstname; this.Lastname = lastname; this.CIN = cin; this.DateOfBirth = selectedDate; this.Password = password; this.IsSuperUser = superUser; this.PhoneNumber = phoneNumber; this.Role = role; this.City = CityDAO.GetCityByName(city); }
public void Create(string city,string country, string street, int house, int flat, string firstName, string name, string lastName, string telephone) { adress adress = context.adresses.Create(); CityDAO cityDAO = new CityDAO(); adress.idCity = cityDAO.FindCity(city, country); adress.street = street; adress.house = house; adress.flat = flat; PersonDAO personDAO = new PersonDAO(); adress.idPerson = personDAO.FindPerson(firstName,name,lastName,telephone); context.adresses.Add(adress); context.SaveChanges(); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string cityID = GridView1.DataKeys[e.RowIndex].Value.ToString(); GridViewRow row = GridView1.Rows[e.RowIndex]; TextBox cityName = (TextBox)row.Cells[1].Controls[0]; TextBox nationalID = (TextBox)row.Cells[2].Controls[0]; GridView1.EditIndex = -1; //update data City c = new City(); c.CityID = cityID; c.CityName = cityName.Text; c.NationalID = nationalID.Text; CityDAO.UpdateCity(c); ShowDataCity(); }
protected void ShowDataCity() { DataTable dt = CityDAO.GetDataCity(); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } else { dt.Rows.Add(dt.NewRow()); GridView1.DataSource = dt; GridView1.DataBind(); int columncount = GridView1.Rows[0].Cells.Count; GridView1.Rows[0].Cells.Clear(); GridView1.Rows[0].Cells.Add(new TableCell()); GridView1.Rows[0].Cells[0].ColumnSpan = columncount; GridView1.Rows[0].Cells[0].Text = "No Records Found"; } }
/// <summary> /// Search city /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SearchCity(object sender, EventArgs e) { DataTable searchTBL = CityDAO.GetDataCityByName(txtSearch.Text.Trim()); if (searchTBL.Rows.Count > 0) { GridView1.DataSource = searchTBL; GridView1.DataBind(); } else { searchTBL.Rows.Add(searchTBL.NewRow()); GridView1.DataSource = searchTBL; GridView1.DataBind(); int columncount = GridView1.Rows[0].Cells.Count; GridView1.Rows[0].Cells.Clear(); GridView1.Rows[0].Cells.Add(new TableCell()); GridView1.Rows[0].Cells[0].ColumnSpan = columncount; GridView1.Rows[0].Cells[0].Text = "No Records Found"; } }
/// <summary> /// Add new city /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { string cityID = txtID.Text; string cityName = txtName.Text; string nationalID = txtNationalID.Text; if (CityDAO.DulicateCity(cityID)) { phError.Controls.Add(new LiteralControl("<div class='alert alert-danger'>")); Label error = new Label(); error.Text = "CityID has been dupplicated!"; phError.Controls.Add(error); phError.Controls.Add(new LiteralControl("</div>")); return; } else if (string.IsNullOrEmpty(cityID) || string.IsNullOrEmpty(cityName) || string.IsNullOrEmpty(nationalID)) { phError.Controls.Add(new LiteralControl("<div class='alert alert-danger'>")); Label error = new Label(); error.Text = "All data must not be empty!"; phError.Controls.Add(error); phError.Controls.Add(new LiteralControl("</div>")); return; } else { City c = new City(); c.CityID = cityID; c.CityName = cityName; c.NationalID = nationalID; if (CityDAO.AddCity(c)) { Session["addOK"] = "New CITY has been added!"; Response.Redirect("AdminCity.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = CityDAO.GetDataCity(); cbFromCity.DataSource = dt; cbFromCity.DataValueField = "CityID"; cbFromCity.DataTextField = "CityName"; cbFromCity.DataBind(); cbToCity.DataSource = dt; cbToCity.DataValueField = "CityID"; cbToCity.DataTextField = "CityName"; cbToCity.DataBind(); txtRoute.Text = cbFromCity.SelectedItem.ToString() + " to " + cbToCity.SelectedItem.ToString(); } btnSave.Click += BtnSave_Click; btnBack.Click += BtnBack_Click; cbFromCity.SelectedIndexChanged += CbFromCity_SelectedIndexChanged; cbToCity.SelectedIndexChanged += CbToCity_SelectedIndexChanged; }
public static async Task CreateOneCity(string cityName, string provinceName, string provinceCode, string countryName, string countryCode) { CityDAO cityDAO = new CityDAO(); await cityDAO.CreateOneCity(cityName, provinceName, provinceCode, countryName, countryCode); }
/// <summary> /// 构造函数 /// </summary> public CityBLL(LoggingSessionInfo pUserInfo) { this.CurrentUserInfo = pUserInfo; this._currentDAO = new CityDAO(pUserInfo); }
public static List <City> GetCityByCityNameAndProvinceAndCountry(string cityName, string province, string country) { CityDAO cityDAO = new CityDAO(); return(cityDAO.GetCityByCityNameAndProvinceAndCountry(cityName, province, country)); }
public static List <City> GetCityByKeyword(string keyword) { CityDAO cityDAO = new CityDAO(); return(cityDAO.GetCityByKeyword(keyword)); }
public static async Task <List <City> > GetAllCityList() { CityDAO cityDAO = new CityDAO(); return(await cityDAO.GetAllCityList()); }
public static async Task <long> DeleteCityById(string id) { CityDAO cityDAO = new CityDAO(); return(await cityDAO.DeleteCityById(id)); }
public static async Task <long> UpdateCityById(string id, string cityName, string provinceName, string provinceCode, string countryName, string countryCode) { CityDAO cityDAO = new CityDAO(); return(await cityDAO.UpdateCityById(id, cityName, provinceName, provinceCode, countryName, countryCode)); }
public void Create(City city) { CityDAO cityDAO = new CityDAO(); cityDAO.Create(TABLE, city.AssembleDictionary()); }
/// <summary> Retrieves Entity rows in a datatable which match the specified filter. It will always create a new connection to the database.</summary> /// <param name="selectFilter">A predicate or predicate expression which should be used as filter for the entities to retrieve.</param> /// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param> /// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param> /// <param name="relations">The set of relations to walk to construct to total query.</param> /// <param name="pageNumber">The page number to retrieve.</param> /// <param name="pageSize">The page size of the page to retrieve.</param> /// <returns>DataTable with the rows requested.</returns> public static DataTable GetMultiAsDataTable(IPredicate selectFilter, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, int pageNumber, int pageSize) { CityDAO dao = DAOFactory.CreateCityDAO(); return(dao.GetMultiAsDataTable(maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, pageNumber, pageSize)); }