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