public static string GetUsersByDepartment(string departmentId) { Sys_CanBoRepository repository = new Sys_CanBoRepository(); List <Sys_CanBo> staff = repository.GetStaffByDepartment(int.Parse(departmentId));// repository.GetAll().ToList(); return(JsonConvert.SerializeObject(new { items = staff })); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["trang"] != null) { trang = Request.QueryString["trang"].ToString(); } if (string.IsNullOrEmpty(trang)) { trang = "1"; } if (Request.QueryString["s"] != null) { keyword = Request.QueryString["s"].ToString(); } txtTimKiem.Text = keyword; int.TryParse(trang, out pageIndex); StartIndex = pageSize * (pageIndex - 1); Sys_CanBoRepository repository = new Sys_CanBoRepository(); List <Sys_CanBo> data = repository.GetTable().Where(x => string.IsNullOrEmpty(keyword) || x.UserName.Contains(keyword) || x.TenCanBo.Contains(keyword)).OrderByDescending(x => x.NgayThayDoi).ToList(); CollectionPager1.MaxPages = 10000; CollectionPager1.PageSize = pageSize; // số items hiển thị trên một trang. CollectionPager1.DataSource = data; CollectionPager1.BindToControl = rptData; rptData.DataSource = CollectionPager1.DataSourcePaged; rptData.DataBind(); }
public static string DeleteStaffItem(string itemID) { AjaxResponse response = new AjaxResponse(); try { //Initial data context variable, this class is declared in .dbml file in xRPDAL namespace int temp = 0; int.TryParse(itemID, out temp); Sys_CanBoRepository repository = new Sys_CanBoRepository(); repository.Delete(temp); repository.SubmitChanges(); response.IsSuccess = true; response.Message = "OK"; } catch (Exception ex) { response.IsSuccess = false; response.Message = (ex.Message + ex.StackTrace).EncodeJsString(); } return(JsonConvert.SerializeObject(response)); }
protected void btnAdd_Click(object sender, EventArgs e) { Sys_CanBoRepository repository = new Sys_CanBoRepository(); Sys_CanBo staff = new Sys_CanBo(); if (!string.IsNullOrEmpty(id) && id != "0") { staff = repository.GetById(int.Parse(id)); } //Update thông tin cơ bản bool isExistEmail = false; if (id == "0") { if (repository.IsEmailExist(txtEmail.Text)) { lblEmailError.Visible = true; lblEmailError.Text = "Email đã tồn tại, vui lòng chọn email khác"; return; } } else { if (staff.Email.ToLower() != txtEmail.Text.ToLower()) { if (repository.IsEmailExist(txtEmail.Text)) { lblEmailError.Visible = true; lblEmailError.Text = "Email đã tồn tại, vui lòng chọn email khác"; return; } } } staff.UserName = ddlAccount.SelectedValue; staff.NgayThayDoi = DateTime.Now; staff.Email = txtEmail.Text; staff.MaNguoiTao = new Guid(Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey.ToString()); staff.MaNguoiThayDoi = new Guid(Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey.ToString()); staff.NgayTao = DateTime.Now; staff.SoDienThoai = txtSoDienThoai.Text; staff.TenCanBo = txtName.Text; staff.KichHoat = ckKichHoat.Checked; if (id == "0") { repository.Add(staff); } repository.SubmitChanges(); ///Update thông tin chức vụ phòng ban. int temp = 0; List <Sys_CanBo_Department_ChucVu> mappings = new List <Sys_CanBo_Department_ChucVu>(); foreach (RepeaterItem item in rptDepartment.Items) { CheckBox chkCheck = (CheckBox)item.FindControl("chkCheck"); DropDownList ddlPosition = (DropDownList)item.FindControl("ddlPosition"); HiddenField hdfID = (HiddenField)item.FindControl("hdfID"); int.TryParse(ddlPosition.SelectedValue, out temp); if (chkCheck.Checked && temp > 0) { Sys_CanBo_Department_ChucVu map = new Sys_CanBo_Department_ChucVu(); map.CanBoID = staff.ID; map.ChucVuID = temp; map.DepartmentID = int.Parse(hdfID.Value); mappings.Add(map); } } repository.UpdateDepartmentPosition(staff.ID, mappings); Page.Response.Redirect("default.aspx?page=staff&trang=" + trang); }