public ActionResult Delegate_Authority_Staff(string staff_name, string duty_start_date, string duty_end_date)
{
using (var db = new DataBaseContext())
{
staff staff_obj = db.staff_repository.Where(s => s.name == staff_name).FirstOrDefault();
staff_representative staff_representative_obj = new staff_representative(duty_start_date, duty_end_date, staff_obj, "Temporary_Head");
db.staff_representative_repository.Add(staff_representative_obj);
db.SaveChanges();
}
return(Json(new { status = "ok" }));
}
// GET: Staffs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
staff staff = db.staffs.Find(id);
if (staff == null)
{
return(HttpNotFound());
}
return(View(staff));
}
public ActionResult Delegate_Authority(string name)
{
using (var db = new DataBaseContext())
{
staff staff_obj = db.staff_repository.Where(s => s.name == name).Select(x => x).FirstOrDefault();
string department_name = staff_obj.department_obj.department_name;
List <staff> staff_lis = db.staff_repository.Where(s => s.department_obj.department_name == department_name && (s.position == "Employee" || s.position == "Representative")).ToList();
return(Json(new { status = "ok", staff_lis }));
}
}
public ActionResult Delete(int id)
{
StaffDao dao = new StaffDao();
staff exists_sta = dao.GetById(id);
var image_old = Path.Combine(Server.MapPath("~/Areas/Admins/Content/Photo/Staff/"),
System.IO.Path.GetFileName(exists_sta.sta_image));
if (System.IO.File.Exists(image_old))
{
System.IO.File.Delete(image_old);
}
dao.Delete(id);
return(RedirectToAction("Index"));
}
public static void UpdateStaffSync(staff cust)
{
SqlCommand sqlite_cmd;
using (var cnn = SimpleDbConnection())
{
cnn.Open();
sqlite_cmd = cnn.CreateCommand();
sqlite_cmd.CommandText = "UPDATE AspNetUsers SET DateSynced=getdate(),SyncStatus=0,SyncTrackId=@trackid,UnSyncedEvents=1 WHERE id=@id";
sqlite_cmd.Parameters.Add(new SqlParameter("@trackid", cust.SyncTrackId));
sqlite_cmd.Parameters.Add(new SqlParameter("@id", cust.Id));
sqlite_cmd.ExecuteNonQuery();
cnn.Close();
}
}
public ActionResult Delete(int id, staff u)
{
ause.DeleteUserById(id);
List <staff> users = ause.getAllUsers();
List <staff> insurers = new List <staff>();
foreach (staff i in users)
{
if (u.DTYPE == "isinsurer")
{
insurers.Add(i);
}
}
return(RedirectToAction("Index", insurers));
}
public ActionResult Register(staff h)
{
if (ModelState.IsValid)
{
ause.CreateUser(h);
return(RedirectToAction("Login"));
}
else
{
return(View());
}
}
public ActionResult savestaff(staff sstaff)
{
using (QuanLyCafeEntities3 db = new QuanLyCafeEntities3())
{
var nv = db.staffs.Find(sstaff.idstaff);
nv.name = sstaff.name;
nv.email = sstaff.email;
nv.position = sstaff.position;
nv.status = sstaff.status;
nv.idaccount = sstaff.idaccount;
db.SaveChanges();
}
return(RedirectToAction("setting", "Home"));
}
// GET: InsuranceAgent/Edit/5
public ActionResult Edit(int id)
{
staff u = new staff();
foreach (staff i in ause.getAllUsers())
{
if (i.id == id)
{
u = i;
}
}
ause.DeleteUserById(id);
return(View(u));
}
/// <summary>
/// Giris yapan personelin ait oldugu sirket anketlerini dondurur.
/// </summary>
/// <param name="ownerid">istegi atan kullanici</param>
/// <param name="staffid">istegi atan kullanici</param>
/// <param name="authkey">Dogrulama keyi</param>
/// <returns></returns>
public string GetCompanyPollList(dynamic jsonData)
{
long ownerid = jsonData.ownerid;
long staffid = jsonData.staffid;
string authKey = jsonData.authkey;
staff loggedUser = DatabaseService.CheckStaffAuth(staffid, authKey, ownerid);
if (loggedUser == null)
{
return(Helper.GetResult(false, "0x0009"));
}
return(PollBusiness.GetPollList(ownerid, "C"));
}
public IHttpActionResult Deletestaff(string accessToken)
{
staff staff = db.staffs.Where(s => s.auth_token == accessToken).FirstOrDefault();
if (staff == null)
{
return(NotFound());
}
StaffDto dto = staffRepository.getStaff(staff.auth_token);
db.staffs.Remove(staff);
db.SaveChanges();
return(Ok(dto));
}
// GET: Staff/Edit/5
public ActionResult Edit(byte?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
staff staff = db.staff.Find(id);
if (staff == null)
{
return(HttpNotFound());
}
ViewBag.store_id = new SelectList(db.store, "store_id", "store_id", staff.store_id);
return(View(staff));
}
public void Add()
{
var staff = new staff()
{
full_name = _view.TxtStaffName,
date_of_birth = DateTime.ParseExact(_view.TxtDoB, dateTimeFormats,
CultureInfo.InvariantCulture, DateTimeStyles.None),
phone_number = _view.TxtPhone,
salary = Int64.Parse(_view.TxtSalary),
permission_id = _view.CbPermission_id,
is_still_working = true
};
_repository.InsertStaff(staff);
}
private StaffViewModel ConvertStaffToStaffVM(staff staff)
{
var newStaffVM = new StaffViewModel()
{
DateOfBirth = staff.date_of_birth,
FullName = staff.full_name,
Id = staff.id == 0 ? _staffViewModelList.Count() + 1 : staff.id,
PhoneNumber = staff.phone_number,
Salary = staff.salary,
PositionName = _permissionRepository.GetPermissionList()
.FirstOrDefault(p => p.id == staff.permission_id).position_name
};
return(newStaffVM);
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
//界面控制
btnAdd.Visibility = Visibility.Collapsed;
btnSaveAdd.Visibility = Visibility.Visible;
btnEdit.Visibility = Visibility.Collapsed;
btnDelete.Visibility = Visibility.Collapsed;
txtBoxName.IsReadOnly = false;
txtBoxID.IsReadOnly = false;
//数据处理
staff staff = new staff();
gridMemberInfo.DataContext = staff;
}
public void InsertStaff_HasNewPhoneNumber_InsertToDatabaseSuccessfully()
{
var mockStaff = new staff()
{
full_name = "nv4",
date_of_birth = new DateTime(1999, 1, 3),
phone_number = "1945664870",
salary = 4500000,
is_still_working = true,
permission_id = 1,
};
_sut.InsertStaff(mockStaff);
_stubDbContext.Verify(c => c.staffs.Add(mockStaff), Times.Once);
_stubDbContext.Verify(c => c.SaveChanges(), Times.Once);
}
// GET: staffs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
staff staff = db.staffs.Find(id);
if (staff == null)
{
return(HttpNotFound());
}
ViewBag.position_id = new SelectList(db.positions, "position_id", "prosition_name", staff.position_id);
ViewBag.project_id = new SelectList(db.projects.OrderBy(p => p.project_name), "project_id", "project_name", staff.project_id);
return(PartialView("_EditPartial", staff));
}
public int deletePhones(staff employee)
{
try
{
var phones = employee.phones.ToList();
foreach (phones item in phones)
{
fmp.phones.Remove(item);
}
return(1);
}
catch (Exception e)
{
return(0);
}
}
public bool Delete(staff nv)
{
try
{
staff_permission p = db.staff_permissions.Where(t => t.staff_id.Equals(nv.id)).FirstOrDefault();
if (p != null)
{
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(staff sta)
{
staff staff = GetById(sta.sta_id);
if (staff != null)
{
staff.group_role_id = sta.group_role_id;
staff.sta_email = sta.sta_email;
staff.sta_image = sta.sta_image;
staff.sta_fullname = sta.sta_fullname;
staff.sta_password = sta.sta_password;
staff.sta_username = sta.sta_username;
staff.sta_update_at = sta.sta_update_at;
db.SaveChanges();
}
}
public void simpan()
{
staff s = new staff();
s.staffid = txtstaffid.Text;
s.namastaff = txtnamastaff.Text;
s.rolesid = txtrolesid.Text;
s.passwords = txtpassword.Text;
s.createdby = txtcreatedby.Text;
s.createdon = DateTime.Now;
s.modifedtime = null;
s.modifiedby = null;
dbe.staff.AddOrUpdate(s);
dbe.SaveChanges();
datagrid();
}
// GET: Staffs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
staff staff = db.staffs.Find(id);
if (staff == null)
{
return(HttpNotFound());
}
ViewBag.manager_id = new SelectList(db.staffs, "staff_id", "first_name", staff.manager_id);
ViewBag.store_id = new SelectList(db.stores, "store_id", "store_name", staff.store_id);
return(View(staff));
}
public void Execute(object parameter)
{
try {
staff staff = new staff();
StaffControl bo = new StaffControl();
DataTable dt = new DataTable();
dt = bo.getTable();
staff.datagridview.ItemsSource = dt.DefaultView;
MessageBox.Show("Staff members successfully updated");
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong");
}
}
public void UpdateStaff(staff cust)
{
SQLiteCommand sqlite_cmd;
using (var cnn = SimpleDbConnection())
{
cnn.Open();
sqlite_cmd = cnn.CreateCommand();
sqlite_cmd.CommandText = @"UPDATE staff SET DateSynced=getdate(),SyncStatus=0,SyncTrackId=$trackid,UnSyncedEvents=1 " +
"WHERE id=$id";
sqlite_cmd.Parameters.Add(new SQLiteParameter("$trackid", cust.SyncTrackId));
sqlite_cmd.Parameters.Add(new SQLiteParameter("$id", cust.Id));
sqlite_cmd.ExecuteNonQuery();
cnn.Close();
}
}
public ActionResult Create([Bind(Include = "staff_id,fname,lname,position_id,project_id")] staff staff)
{
if (ModelState.IsValid)
{
db.staffs.Add(staff);
db.SaveChanges();
TempData["success"] = "Staff " + staff.fname + " " + staff.lname + " was created successfully.";
return(RedirectToAction("Index"));
}
ViewBag.position_id = new SelectList(db.positions, "position_id", "prosition_name", staff.position_id);
ViewBag.project_id = new SelectList(db.projects.OrderBy(p => p.project_name), "project_id", "project_name", staff.project_id);
return(View(staff));
}
public int deletePhones(staff employee)
{
try
{
var phones = employee.phones.ToList();
foreach (phones item in phones)
{
fmp.phones.Remove(item);
}
return 1;
}
catch (Exception e)
{
return 0;
}
}
public ActionResult Create(staff staff, AddressViewModel address)
{
if (ModelState.IsValid)
{
//Save infor staff
var code = db.staffs.OrderByDescending(x => x.sta_id).FirstOrDefault();
if (code == null)
{
staff.sta_code = "NV000001";
}
else
{
staff.sta_code = Utilis.CreateCodeByCode("NV", code.sta_code, 8);
}
staff.sta_created_date = DateTime.Now;
staff.sta_status = 1;
//Mail
string content = System.IO.File.ReadAllText("D:/Ki2Nam3/ttn/Tien_TTNhom/CodeAllTTNhom/Common/Template/sendmail.html");
content = content.Replace("{{Username}}", staff.sta_username);
content = content.Replace("{{Password}}", staff.sta_password);
new MailHelper().SendMail(staff.sta_email, "Thông tin tài khoản", content);
db.staffs.Add(staff);
db.SaveChanges();
//Save address of staff
staff staff_last = db.staffs.OrderByDescending(x => x.sta_id).FirstOrDefault();
address create_add = new address();
create_add.add_province = db.Provinces.Where(x => x.Id == address.provinceID).FirstOrDefault().Name;
create_add.add_district = db.Districts.Where(x => x.Id == address.districtID).FirstOrDefault().Name;
create_add.add_ward = db.Wards.Where(x => x.Id == address.wardID).FirstOrDefault().Name;
create_add.staff_id = staff_last.sta_id;
db.addresses.Add(create_add);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.department_id = new SelectList(db.departments, "de_id", "de_name", staff.department_id);
ViewBag.group_role_id = new SelectList(db.group_role, "gr_id", "gr_name", staff.group_role_id);
ViewBag.position_id = new SelectList(db.positions, "pos_id", "pos_name", staff.position_id);
ViewBag.provinceID = new SelectList(db.Provinces, "Id", "Name", address.provinceID);
ViewBag.districtID = new SelectList(db.Districts, "Id", "Name", address.districtID);
ViewBag.wardID = new SelectList(db.Wards, "Id", "Name", address.wardID);
return(View(staff));
}
// ------------------------------------------------------------------------------------------------
// ------------------- COLLECTION POINT -----------------------------------------------------------
public ActionResult Collection_Point_Change()
{
using (var db = new DataBaseContext())
{
String username = Session["UserName"].ToString();
staff staff_obj = db.staff_repository.Where(s => s.name == username).Select(x => x).FirstOrDefault();
string department_name = staff_obj.department_obj.department_name;
department depart_obj = db.department_repository.Where(d => d.department_name == department_name).FirstOrDefault();
ViewBag.Dept_name = department_name;
ViewBag.Department_Obj = depart_obj;
}
return(View());
}
//返回单个员工信息
public JsonResult LoadSingleStaff(int id)
{
CheckConnect();
string query1 = "SELECT * FROM STAFF_BASE WHERE staffID = @Id";
string query2 = "SELECT * FROM DEPART_BASE WHERE departID = @Id";
string query4 = "SELECT * FROM DEPART_BASE WHERE departLevel = @Level";
staff sta = (staff)db.Query <staff>(query1, new { Id = id }).SingleOrDefault();
depart dep = (depart)db.Query <depart>(query2, new { Id = sta.departID }).SingleOrDefault();
List <depart> deps = (List <depart>)db.Query <depart>(query4, new { Level = dep.departLevel });
string query3 = "SELECT classNum,className FROM CLASS_ITEM WHERE classNum LIKE '020" + dep.departLevel.ToString() + "%'";
List <position> pos = (List <position>)db.Query <position>(query3);
staffInfoModel model = new staffInfoModel {
sta = sta, dep = dep, deps = deps, pos = pos
};
return(Json(model, JsonRequestBehavior.AllowGet));
}
public List <staff> GetLst(staff model, int?page, int numberRecord, out int totalRecord)
{
var a = (from u in _db.staffs
where (string.IsNullOrEmpty(model.user_cd) || u.user_cd.Equals(model.user_cd)) &&
(string.IsNullOrEmpty(model.name) || u.name.Contains(model.name)) &&
(string.IsNullOrEmpty(model.user_name) || u.user_name.Equals(model.user_name)) &&
(string.IsNullOrEmpty(model.pass_word) || u.pass_word.Equals(model.pass_word)) &&
(string.IsNullOrEmpty(model.mobile) || u.mobile.Equals(model.mobile)) &&
(string.IsNullOrEmpty(model.adress) || u.adress.Equals(model.adress)) &&
(model.sex == null || u.sex == model.sex) &&
u.del_flg.Equals(false)
select u);
totalRecord = a.Count();
return(a.ToList().Skip((page.GetValueOrDefault() - 1) * numberRecord).Take(numberRecord).ToList());
}
public async Task <IActionResult> OnPostAsync(string returnUrl = null)
{
//var newUser;
//this.CreateRole();
if (ModelState.IsValid)
{
var user = userManager.FindByEmailAsync(regInput.email).Result;
if (user == null)
{
var newUser = new staff()
{
UserName = regInput.username,
Email = regInput.email,
PhoneNumber = regInput.Phonenumber,
fullName = regInput.fullname,
address = regInput.address,
gaurantorName = regInput.gaurantorname,
gaurantorPhoneNumber = regInput.gaurantorphoneno,
gender = regInput.gender,
shopId = regInput.shopId
};
var result = userManager.CreateAsync(newUser, regInput.password).Result;
if (result.Succeeded)
{
await userManager.AddToRoleAsync(newUser, regInput.roletype);
statusMsg = "Staff Added Successfully";
return(Page());
}
else
{
statusMsg = "Failed to Add Staff" + result.Errors.ToString();
}
}
else
{
statusMsg = "User Already Exist !";
}
}
return(Page());
}
public void update(staff editItem)
{
staff selectedItem = db.staffs.SingleOrDefault(item => item.id == editItem.id);
selectedItem.code = editItem.code;
selectedItem.lastname = editItem.lastname;
selectedItem.firstname = editItem.firstname;
selectedItem.dateofbirth = editItem.dateofbirth;
selectedItem.designation = editItem.designation;
selectedItem.phone = editItem.phone;
selectedItem.mobile = editItem.mobile;
selectedItem.email = editItem.email;
selectedItem.hiredate = editItem.hiredate;
selectedItem.status = editItem.status;
selectedItem.address_id = editItem.address_id;
selectedItem.department_id = editItem.department_id;
selectedItem.image = editItem.image;
db.SaveChanges();
}
void HandleBtSearchGoClicked(object sender, EventArgs e)
{
tvResults.Destroy();
tvResults = new TreeView ();
Console.WriteLine("Searched: "+tbSearch.Text);
staff staffMember = new staff();
staffMember.fName = "ted";
List<staff> searchResults = new List<staff> ();
searchResults = staffMember.search_staff(tbSearch.Text);
Console.WriteLine("Search Results found: "+searchResults.Count.ToString());
//staffMember.get_staff_member();
foreach(staff sr in searchResults)
{
Console.WriteLine(sr.fName+" "+sr.lName);
}
//Console.WriteLine(staffMember.fName);
Gtk.ListStore searchResultsStore = new Gtk.ListStore (typeof (string));
searchResultsStore.AppendValues ("Gerry");
Gtk.CellRendererText staffResult = new Gtk.CellRendererText ();
tvResults.Model = searchResultsStore;
vboxVpLeft.PackStart(tvResults);
TreeViewColumn tvcName = new TreeViewColumn ();
tvcName.Title="Name";
tvcName.PackStart(staffResult,true);
tvResults.AppendColumn(tvcName);
tvcName.AddAttribute (staffResult, "text", 0);
tvResults.Show();
vboxVpLeft.PackStart(tvResults);
}
void HandleTbSearchKeyReleaseEvent(object o, KeyReleaseEventArgs args)
{
//get results live on key up
staff staffMember = new staff();
staffMember.fName = "ted";
List<staff> searchResults = new List<staff> ();
searchResults = staffMember.search_staff(tbSearch.Text);
Console.WriteLine("Search Results found: "+searchResults.Count.ToString());
//staffMember.get_staff_member();
foreach(staff sr in searchResults)
{
Console.WriteLine(sr.fName+" "+sr.lName);
}
}
void HandleTbClientsClicked(object sender, EventArgs e)
{
viewPortRight.Remove(viewPortLeft.Child);
Label lbClients =new Label ();
lbClients.Text ="Im the clients bit";
viewPortLeft.Remove(viewPortLeft.Child);
viewPortLeft.Add(lbClients);
viewPortLeft.Show();
lbClients.Show();
Console.WriteLine("Clients Clicked");
staff s = new staff ();
List<staff> staffList = new List<staff>();
staffList= s.get_all_staff_members();
foreach(staff sm in staffList)
{
Console.WriteLine(sm.fName);
}
}
public void delete(staff deleteItem)
{
staff selectedItem = db.staffs.First(item => item.id == deleteItem.id);
db.staffs.Remove(selectedItem);
db.SaveChanges();
}
public void insert(staff newItem)
{
db.staffs.Add(newItem);
db.SaveChanges();
}
public staff selectSingle(staff findItem)
{
staff selectedItem = db.staffs.SingleOrDefault(item => item.id == findItem.id);
return selectedItem;
}
