public int Insert(string connectString, Q_User obj) { using (db = new QMSSystemEntities(connectString)) { db.Q_User.Add(obj); db.SaveChanges(); return(obj.Id); } }
public int Insert(Q_User obj) { using (db = new QMSSystemEntities()) { db.Q_User.Add(obj); db.SaveChanges(); return(obj.Id); } }
private void gridViewUser_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Name").ToString())) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Name").ToString())) { MessageBox.Show("Vui lòng nhập tên nhân viên.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_User(); obj.Id = Id; obj.Name = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Name").ToString(); obj.Sex = (bool)gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Sex"); obj.Address = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Address") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Address").ToString() : ""; obj.Help = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Help") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Help").ToString() : ""; obj.Position = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Position") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Position").ToString() : ""; obj.UserName = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "UserName") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "UserName").ToString() : ""; obj.Password = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Password") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Password").ToString() : ""; obj.Professional = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Professional") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Professional").ToString() : ""; obj.WorkingHistory = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "WorkingHistory") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "WorkingHistory").ToString() : ""; obj.Counters = gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Counters") != null?gridViewUser.GetRowCellValue(gridViewUser.FocusedRowHandle, "Counters").ToString() : "0"; if (obj.Id == 0) { BLLUser.Instance.Insert(connect, obj); } else { BLLUser.Instance.Update(connect, obj); } GetGridUser(); } } catch (Exception ex) { } End: { } }
private void btSave_Click(object sender, EventArgs e) { try { var newUser = new Q_User() { Id = FrmMain.loginObj.UserId, Name = txtName.Text, Position = txtCV.Text, Professional = txtCM.Text, Address = txtAdd.Text, WorkingHistory = txtQTCT.Text, UserName = username, Password = pass }; if (changeImg) { if (openFileDialog1 != null && !string.IsNullOrEmpty(openFileDialog1.FileName)) { string f = openFileDialog1.FileName; var path = Path.GetDirectoryName(Application.ExecutablePath) + "\\Images\\" + Path.GetFileName(f); if (!File.Exists(path)) { File.Copy(f, path); } newUser.Avatar = Path.GetFileName(f); } } newUser.Sex = rbNam.Checked ? true : false; if (BLLUser.Instance.Update(connectString, newUser)) { MessageBox.Show("Lưu thông tin nhân viên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); GetUserInfo(); changeImg = false; this.Close(); } else { MessageBox.Show("Lỗi : lưu thông tin nhân viên bị lỗi ", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("Lỗi : " + ex.Message, "Lỗi lấy thông tin Nhân viên", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool Update(string connectString, Q_User model) { using (db = new QMSSystemEntities(connectString)) { var obj = db.Q_User.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id); if (obj != null) { obj.Name = model.Name; obj.Sex = model.Sex; obj.Address = model.Address; obj.UserName = model.UserName; obj.Password = model.Password; obj.Help = model.Help; obj.Avatar = model.Avatar; obj.Professional = model.Professional; obj.Position = model.Position; obj.WorkingHistory = model.WorkingHistory; obj.Counters = model.Counters; db.SaveChanges(); return(true); } return(false); } }
public ResponseBase CreateOrUpdate(string connectString, Q_User model) { using (db = new QMSSystemEntities(connectString)) { try { var rs = new ResponseBase(); if (CheckExists(model.Id, model.Name.Trim().ToUpper())) { rs.IsSuccess = false; rs.Errors.Add(new Error() { MemberName = "Insert", Message = "Tên Nhân Viên này đã được sử dụng. Vui lòng nhập Tên khác !." }); } else { Q_User obj; if (model.Id == 0) { obj = new Q_User(); Parse.CopyObject(model, ref obj); db.Q_User.Add(model); rs.IsSuccess = true; } else { obj = db.Q_User.FirstOrDefault(m => m.Id == model.Id); if (obj == null) { rs.IsSuccess = false; rs.Errors.Add(new Error() { MemberName = "Update", Message = "Dữ liệu bạn đang thao tác đã bị xóa hoặc không tồn tại. Vui lòng kiểm tra lại !." }); } else { obj.Name = model.Name; obj.Address = model.Address; obj.Sex = model.Sex; obj.Help = model.Help; obj.UserName = model.UserName; if (model.Password != obj.Password) { obj.Password = model.Password; } if (!string.IsNullOrEmpty(model.Avatar)) { obj.Avatar = model.Avatar; } obj.Position = model.Position; obj.WorkingHistory = model.WorkingHistory; obj.Professional = model.Professional; obj.Counters = model.Counters; rs.IsSuccess = true; } } if (rs.IsSuccess) { db.SaveChanges(); rs.IsSuccess = true; } } return(rs); } catch (Exception ex) { throw ex; } } }