public void ReadInfoEmployeeFromData()
{
try {
DTO.Employee EmployeeSelected = infoEmployeeBLL.GetEmployee(EmployeeID);
txtEmployeeID.Text = EmployeeSelected.EmployeeID;
txtEmployeeName.Text = EmployeeSelected.EmployeeName;
cboSex.SelectedItem = EmployeeSelected.Sex;
txtNumberID.Text = EmployeeSelected.NumberID;
txtPhone.Text = EmployeeSelected.Phone;
dtmBirthDay.Value = DateTime.Parse(EmployeeSelected.BirthDay);
txtAddress.Text = EmployeeSelected.Address;
txtPlaceBrith.Text = EmployeeSelected.PlaceBirth;
txtAge.Text = EmployeeSelected.Age;
txtSalary.Text = EmployeeSelected.Salary;
txtPassword.Text = EmployeeSelected.PassWord;
cboStatus.SelectedItem = EmployeeSelected.StatusName;
SetSelectItemComboboxPosition(EmployeeSelected.PositionID);
// read control with controlID = EmployeeSelected.ControlID;
}
catch
{
DisplayNotify("Lỗi không đọc được chi tiết nhân viên từ csdl", -1);
}
}
/// <inheritdoc />
public void DeleteEmployee(DTO.Employee employee)
{
try
{
var entity = this.mapper.Map <Employee>(employee);
this.Delete(entity);
}
catch (Exception ex)
{
this.log.Error($"Failed to delete the {typeof(Employee)} record with Id = {employee.Id}", ex);
}
}
public DataSet ShowAllCustomer(DTO.Employee Ob)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Dry_EmployeeMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 3);
ds = PrjClass.GetData(cmd);
return(ds);
}
/// <inheritdoc />
public DTO.Employee UpdateEmployee(DTO.Employee employee)
{
try
{
var entity = this.mapper.Map <Employee>(employee);
this.Update(entity);
return(employee);
}
catch (Exception ex)
{
this.log.Error($"Failed to update the {nameof(employee)} record", ex);
}
return(null);
}
public string SaveEmployee(DTO.Employee Ob)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Dry_EmployeeMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmployeeSalutation", Ob.Title);
cmd.Parameters.AddWithValue("@EmployeeName", Ob.EmpName);
cmd.Parameters.AddWithValue("@EmployeeAddress", Ob.Address);
cmd.Parameters.AddWithValue("@EmployeePhone", Ob.PhoneNo);
cmd.Parameters.AddWithValue("@EmployeeMobile", Ob.Mobile);
cmd.Parameters.AddWithValue("@EmployeeEmailId", Ob.EmailId);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 1);
Common.Result = PrjClass.ExecuteNonQuery(cmd);
return(Common.Result);
}
public string DeleteEmployee(DTO.Employee Ob)
{
if (CheckEmployee(Ob) != "true")
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Dry_EmployeeMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmployeeCode", Ob.EmpCode);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 5);
Common.Result = PrjClass.ExecuteNonQuery(cmd);
}
else
{
Common.Result = "NO";
}
return(Common.Result);
}
private string CheckEmployee(DTO.Employee Ob)
{
Common.Result = "";
SqlCommand cmd = new SqlCommand();
SqlDataReader sdr = null;
cmd.CommandText = "sp_Dry_EmployeeMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmployeeCode", Ob.EmpCode);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 13);
sdr = PrjClass.ExecuteReader(cmd);
if (sdr.Read())
{
Common.Result = "true";
}
sdr.Dispose();
sdr.Close();
cmd.Dispose();
return(Common.Result);
}
private void dgvData_SelectionChanged(object sender, EventArgs e)
{
DevComponents.DotNetBar.Controls.DataGridViewX g = (DevComponents.DotNetBar.Controls.DataGridViewX)sender;
if (g.SelectedRows.Count == 1)
{
ClearTextboxToReload();
DTO.Employee EmployeeSelected = (DTO.Employee)g.SelectedRows[0].DataBoundItem;
txtEmployeeID.Text = EmployeeSelected.EmployeeID;
txtEmployeeName.Text = EmployeeSelected.EmployeeName;
cboSex.SelectedItem = EmployeeSelected.Sex;
txtNumberID.Text = EmployeeSelected.NumberID;
txtPhone.Text = EmployeeSelected.Phone;
dtmBirthDay.Value = DateTime.Parse(EmployeeSelected.BirthDay);
txtAddress.Text = EmployeeSelected.Address;
txtPlaceBrith.Text = EmployeeSelected.PlaceBirth;
txtAge.Text = EmployeeSelected.Age;
txtSalary.Text = EmployeeSelected.Salary;
//txtImagelink.Text = EmployeeSelected.ImageLink.ToString();
txtPassword.Text = EmployeeSelected.PassWord;
cboStatus.SelectedItem = EmployeeSelected.StatusName;
SetSelectItemComboboxPosition(EmployeeSelected.PositionID);
//image
try
{
byte[] b = employeeBLL.GetImage(EmployeeSelected.EmployeeID);
MemoryStream mem = new MemoryStream(b);
Image ima = Image.FromStream(mem, true);
picImage.BackgroundImage = ima;
}
catch (Exception ex) { };
//btn
btnSave.Enabled = false;
btnEdit.Enabled = true;
btnDelete.Enabled = true;
}
}
public bool RecordAllreadyExists(DTO.Employee Ob)
{
bool ReturnValue = true;
SqlConnection sqlcon = new SqlConnection(PrjClass.sqlConStr);
sqlcon.Open();
string sql = "Select Count(ID) From EmployeeMaster Where EmployeeName='" + Ob.EmpName + "' AND EmployeeAddress='" + Ob.Address + "' AND BranchId='" + Ob.BID + "'";
SqlCommand cmd = new SqlCommand(sql, sqlcon);
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
sdr.Read();
if ((int)sdr.GetValue(0) > 0)
{
ReturnValue = true;
}
else
{
ReturnValue = false;
}
sdr.Dispose();
sdr.Close();
cmd.Dispose();
return(ReturnValue);
}
public bool RecordAllreadyExists(DTO.Employee Ob)
{
return(DAL.DALFactory.Instance.DAL_Employee.RecordAllreadyExists(Ob));
}
public void DTO2BD(DTO.Employee dtoItem, ref Employee dbItem, string TmpFile, int userId)
{
//AutoMapper.Mapper.Map<DTO.Employee, Employee>(dtoItem, dbItem);
if (dtoItem.AnnualLeaveSettings != null)
{
//check for child rows deleted
foreach (AnnualLeaveSetting dbSetting in dbItem.AnnualLeaveSetting.ToArray())
{
if (!dtoItem.AnnualLeaveSettings.Select(o => o.AnnualLeaveSettingID).Contains(dbSetting.AnnualLeaveSettingID))
{
dbItem.AnnualLeaveSetting.Remove(dbSetting);
}
}
//map child row
foreach (DTO.AnnualLeaveSetting dtoSetting in dtoItem.AnnualLeaveSettings)
{
AnnualLeaveSetting dbSetting;
if (dtoSetting.AnnualLeaveSettingID <= 0)
{
dbSetting = new AnnualLeaveSetting();
dbItem.AnnualLeaveSetting.Add(dbSetting);
}
else
{
dbSetting = dbItem.AnnualLeaveSetting.FirstOrDefault(o => o.AnnualLeaveSettingID == dtoSetting.AnnualLeaveSettingID);
}
if (dbSetting != null)
{
AutoMapper.Mapper.Map <DTO.AnnualLeaveSetting, AnnualLeaveSetting>(dtoSetting, dbSetting);
}
}
}
if (dtoItem.EmployeeFactorys != null)
{
foreach (var item in dbItem.EmployeeFactory.ToArray())
{
if (!dtoItem.EmployeeFactorys.Select(o => o.EmployeeFactoryID).Contains(item.EmployeeFactoryID))
{
dbItem.EmployeeFactory.Remove(item);
}
}
//map child row
foreach (var item in dtoItem.EmployeeFactorys)
{
EmployeeFactory dbEmpFactory;
if (item.EmployeeFactoryID <= 0)
{
dbEmpFactory = new EmployeeFactory();
dbItem.EmployeeFactory.Add(dbEmpFactory);
}
else
{
dbEmpFactory = dbItem.EmployeeFactory.FirstOrDefault(o => o.EmployeeFactoryID == item.EmployeeFactoryID);
}
if (dbEmpFactory != null)
{
AutoMapper.Mapper.Map <DTO.EmployeeFactory, EmployeeFactory>(item, dbEmpFactory);
}
}
}
if (dtoItem.EmployeeResponsibleForDTOs != null)
{
foreach (var item in dbItem.EmployeeResponsibleFor.ToArray())
{
if (!dtoItem.EmployeeResponsibleForDTOs.Select(o => o.ResposibleForID).Contains(item.ResposibleForID))
{
dbItem.EmployeeResponsibleFor.Remove(item);
}
}
//map child row
foreach (var item in dtoItem.EmployeeResponsibleForDTOs)
{
EmployeeResponsibleFor dbEmployeeResponsibleFor;
if (item.ResposibleForID <= 0 || item.ResposibleForID == null)
{
dbEmployeeResponsibleFor = new EmployeeResponsibleFor();
dbItem.EmployeeResponsibleFor.Add(dbEmployeeResponsibleFor);
}
else
{
dbEmployeeResponsibleFor = dbItem.EmployeeResponsibleFor.FirstOrDefault(o => o.ResposibleForID == item.ResposibleForID);
}
if (dbEmployeeResponsibleFor != null)
{
Mapper.Map(item, dbEmployeeResponsibleFor);
}
}
}
Mapper.Map(dtoItem, dbItem);
dbItem.DateStart = dtoItem.DateStart.ConvertStringToDateTime();
dbItem.DateEnd = dtoItem.DateEnd.ConvertStringToDateTime();
dbItem.DateOfBirth = dtoItem.DateOfBirth.ConvertStringToDateTime();
dbItem.ContractPeriod = dtoItem.ContractPeriod.ConvertStringToDateTime();
dbItem.ContractStartDate = dtoItem.ContractStartDate.ConvertStringToDateTime();
//
// map the field only for user with special permission
//
if (dtoItem.NeedToUpdateManagerData && fwFactory.HasSpecialPermission(userId, Module.Framework.ConstantIdentifier.SPECIAL_PERMISSION_EMPLOYEE_MANAGER_NOTE))
{
dbItem.ManagerNote = dtoItem.ManagerNote;
// manager attached files
if (dtoItem.EmployeeFileDTOs != null)
{
foreach (var item in dbItem.EmployeeFile.ToArray())
{
if (!dtoItem.EmployeeFileDTOs.Select(o => o.EmployeeFileID).Contains(item.EmployeeFileID))
{
if (!string.IsNullOrEmpty(item.FileUD))
{
fwFactory.RemoveImageFile(item.FileUD);
}
dbItem.EmployeeFile.Remove(item);
}
}
//map child row
foreach (var item in dtoItem.EmployeeFileDTOs)
{
EmployeeFile dbFile;
if (item.EmployeeFileID <= 0)
{
dbFile = new EmployeeFile();
dbItem.EmployeeFile.Add(dbFile);
}
else
{
dbFile = dbItem.EmployeeFile.FirstOrDefault(o => o.EmployeeFileID == item.EmployeeFileID);
}
if (dbFile != null)
{
AutoMapper.Mapper.Map <DTO.EmployeeFileDTO, EmployeeFile>(item, dbFile);
if (item.HasChanged)
{
dbFile.FileUD = fwFactory.CreateNoneImageFilePointer(TmpFile, item.NewFile, dbFile.FileUD, item.FriendlyName);
}
}
}
}
// contract files
if (dtoItem.EmployeeContractDTOs != null)
{
foreach (var item in dbItem.EmployeeContract.ToArray())
{
if (!dtoItem.EmployeeContractDTOs.Select(o => o.EmployeeContractID).Contains(item.EmployeeContractID))
{
if (!string.IsNullOrEmpty(item.FileUD))
{
fwFactory.RemoveImageFile(item.FileUD);
}
dbItem.EmployeeContract.Remove(item);
}
}
//map child row
foreach (var item in dtoItem.EmployeeContractDTOs)
{
EmployeeContract dbContract;
if (item.EmployeeContractID <= 0)
{
dbContract = new EmployeeContract();
dbItem.EmployeeContract.Add(dbContract);
}
else
{
dbContract = dbItem.EmployeeContract.FirstOrDefault(o => o.EmployeeContractID == item.EmployeeContractID);
}
if (dbContract != null)
{
AutoMapper.Mapper.Map <DTO.EmployeeContractDTO, EmployeeContract>(item, dbContract);
dbContract.ValidFrom = item.ValidFrom.ConvertStringToDateTime();
if (item.HasChanged)
{
dbContract.FileUD = fwFactory.CreateNoneImageFilePointer(TmpFile, item.NewFile, dbContract.FileUD, item.FriendlyName);
}
}
}
}
}
if (dtoItem.factoryAccesses != null)
{
foreach (var item in dbItem.QAQCFactoryAccess.ToArray())
{
if (!dtoItem.factoryAccesses.Select(o => o.QAQCFactoryAccessID).Contains(item.QAQCFactoryAccessID))
{
dbItem.QAQCFactoryAccess.Remove(item);
}
}
//map child row
foreach (var item in dtoItem.factoryAccesses)
{
QAQCFactoryAccess dbfac;
if (item.QAQCFactoryAccessID <= 0)
{
dbfac = new QAQCFactoryAccess();
dbItem.QAQCFactoryAccess.Add(dbfac);
}
else
{
dbfac = dbItem.QAQCFactoryAccess.FirstOrDefault(o => o.QAQCFactoryAccessID == item.QAQCFactoryAccessID);
}
if (dbfac != null)
{
Mapper.Map(item, dbfac);
}
}
}
}
public DTO.Employee DB2DTO_Employee(EmployeeMng_Employee_View dbItem, int userId)
{
DTO.Employee dtoItem = AutoMapper.Mapper.Map <EmployeeMng_Employee_View, DTO.Employee>(dbItem);
return(dtoItem);
}
public void updateEmployee(DTO.Employee emp)
{
int tid = getTypeID(emp.Typeservice);
DAL.DALConnect.Instance.MyExecuteNonQuery("update EMPLOYEES set tserviceid = " + tid + ", name = N'" + emp.Name + "',hiredate = '" + emp.Hiredate + "',phone = " + emp.Phone + ", salary = " + emp.Salary + " where eid =" + emp.Id, CommandType.Text);
}
public void insertNewEmploy(DTO.Employee emp)
{
int tid = getTypeID(emp.Typeservice);
DAL.DALConnect.Instance.MyExecuteNonQuery("insert into EMPLOYEES(name,hiredate,tserviceid,phone,salary) values (N'" + emp.Name + "','" + emp.Hiredate + "'," + tid + "," + emp.Phone + "," + emp.Salary + ")", CommandType.Text);
}
public DataSet FillEmployee(DTO.Employee Ob)
{
return(DAL.DALFactory.Instance.DAL_Employee.FillEmployee(Ob));
}
public DataSet SearchEmployee(DTO.Employee Ob)
{
return(DAL.DALFactory.Instance.DAL_Employee.SearchEmployee(Ob));
}
/// <inheritdoc />
public int AddEmployee(DTO.Employee employee)
{
var entity = this.mapper.Map <Employee>(employee);
return(this.Add(entity).Id);
}
public DataSet ShowAllCustomer(DTO.Employee Ob)
{
return(DAL.DALFactory.Instance.DAL_Employee.ShowAllCustomer(Ob));
}
public string SaveEmployee(DTO.Employee Ob)
{
return(DAL.DALFactory.Instance.DAL_Employee.SaveEmployee(Ob));
}
