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