public EmployeeBo Create(EmployeeBo item)
{
try
{
item.RegDate = DateTime.Now;
Employee obj = Mapper.Map <Employee>(item);
dba.Employees.Add(obj);
dba.SaveChanges();
return(Mapper.Map <EmployeeBo>(obj));
}
catch
{
throw;
}
}
static void Main()
{
//int recordCount = GetRecordCount();
//Employee[] employees = new Employee[recordCount];
//for (int i = 0; i < employees.Length; i++)
//{
PrintMenu();
int choice = GetChoice();
//Console.WriteLine($"\nRecord# {(i + 1)}");
Employee employee = Create(choice);
EmployeeBo bo = new EmployeeBo();
bo.Insert(employee);
}
public static EmployeeBo ToEmployeeBo(this Employee employee)
{
if (employee == null)
{
return(null);
}
EmployeeBo employeeBo = new EmployeeBo();
employeeBo.EmployeeID = employee.EmployeeID;
employeeBo.FirstName = employee.FirstName;
employeeBo.LastName = employee.LastName;
employeeBo.WorkExperience = employee.WorkExperience;
employeeBo.Salary = employee.Salary;
employeeBo.DepartmentId = employee.DepartmentId;
return(employeeBo);
}
public void Update(EmployeeBo item, int key)
{
try
{
var obj = dba.Employees.SingleOrDefault(p => p.Id == key);
if (obj == null)
{
throw new ObjectNotFoundException("Employee not founded");
}
obj.Name = item.Name;
obj.Phone = item.Phone;
obj.Email = item.Email;
dba.SaveChanges();
}
catch
{
throw;
}
}
public void AddNewEmployeeDataToDb()
{
#region Preconditions
Random random = new Random();
Int32 changesMark = random.Next(100, 999);
String departmentName = "Service";
EmployeeBo employeeNewData = new EmployeeBo
{
FirstName = $"Artem {changesMark}",
LastName = $"Ivanov {changesMark}",
WorkExperience = 4,
Salary = 1200,
DepartmentId = 2
};
#endregion
Int32 employeeCountForServiceDepartment = EmployeeService.GetEmployeeInfoByDepartment(departmentName).Count;
EmployeeService.CreateNewEmployee(employeeNewData);
Int32 employeeCountAfterAddNewEmployee = EmployeeService.GetEmployeeInfoByDepartment(departmentName).Count;
EmployeeBo addedEmployee = EmployeeService.GetEmployeeInfo()
.Where(x => x.FirstName == employeeNewData.FirstName).FirstOrDefault();
Assert.AreEqual(employeeCountAfterAddNewEmployee - 1, employeeCountForServiceDepartment,
"Count of employee for Service Department has been changed.");
Assert.AreEqual(employeeNewData.FirstName, addedEmployee.FirstName,
"Data was added to DB with appropriate First Name.");
Assert.AreEqual(employeeNewData.LastName, addedEmployee.LastName,
"Data was added to DB with appropriate Last Name.");
}
public void CreateNewEmployee(EmployeeBo employee)
{
EmployeeRepository.CreateNewEmployeeInfo(employee.ToEmployee());
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (hfIsUser.Value != "1")
{
rfUserName.Enabled = false;
rfPassword.Enabled = false;
rfRePassword.Enabled = false;
cvRePassword.Enabled = false;
}
if (Page.IsValid)
{
EmployeeBo objEmployeeBO = new EmployeeBo();
EmployeeBl objEmployeeBL = new EmployeeBl();
objEmployeeBO.Name = txtName.Text.Trim();
objEmployeeBO.Code = txtCode.Text.Trim();
objEmployeeBO.RoleId = Convert.ToInt32(ddlRole.SelectedValue);
objEmployeeBO.Address = txtAddress.Text.Trim();
objEmployeeBO.ContactNo = txtContactNo.Text.Trim();
objEmployeeBO.MobileNo = txtMobileNo.Text.Trim();
objEmployeeBO.Email = txtEmail.Text.Trim();
objEmployeeBO.UserName = txtUserName.Text.Trim();
objEmployeeBO.Password = txtPassword.Text.Trim();
objEmployeeBO.JoinDate = txtJoinDate.Text.Trim();
objEmployeeBO.BirthDate = txtBirthDate.Text.Trim();
objEmployeeBO.MarriageDate = txtMarriageDate.Text.Trim();
objEmployeeBO.AllowAccountAccess = 0;
if (ViewState["Mode"].ToString() == "Save")
{
objEmployeeBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objEmployeeBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToShortDateString();
var objResult = objEmployeeBL.Employee_Insert(objEmployeeBO);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Saved Successfully!');</script>");
BindEmployee();
ClearAll();
PanelVisibilityMode(1);
ViewState["Mode"] = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record already exist.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objEmployeeBO.Id = Convert.ToInt32(ViewState["Id"].ToString());
objEmployeeBO.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objEmployeeBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
var objResult = objEmployeeBL.Employee_Update(objEmployeeBO);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Updated Successfully.');</script>");
BindEmployee();
ClearAll();
PanelVisibilityMode(1);
ViewState["Mode"] = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record already exist.');</script>");
}
}
}
}
catch (Exception ex)
{
log.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
static void Main()
{
EmployeeBo employeeBo = null;
try
{
char toContinue = 'n';
do
{
ShowMenu();
int choice = GetManinMenuChoice();
employeeBo = new EmployeeBo();
switch (choice)
{
case 1:
ShowEmployeeSubMenu();
int empChoice = GetEmployeeChoice();
Employee newEmployee = Create(empChoice);
bool status = employeeBo.AddRecord(newEmployee);
Console.WriteLine($"{(status ? "Record added successfully" : "Either record exists or some other error. could not add record")}");
break;
case 2:
int empId = GetEmployeeIdFromUser();
Employee employee = employeeBo.FetchARecord(empId);
Console.WriteLine($"{(employee != null ? $"found record of {employee.EmployeeName}" : $"No record found with id: {empId}")}");
break;
case 3:
ShowSortMenu();
int sortChoice = GetSortChoice();
List <Employee> records = employeeBo.FetchAllRecords(sortChoice);
if (records.Count > 0)
{
foreach (Employee e in records)
{
Console.WriteLine(e);
}
}
else
{
Console.WriteLine("No records found...");
}
break;
default:
break;
}
Decide(ref toContinue);
} while (toContinue != 'n' && toContinue == 'y');
}
catch (NullReferenceException ex)
{
System.Console.WriteLine(ex);
}
catch (Exception ex)
{
System.Console.WriteLine(ex);
}
}
/// <summary>
/// To Update details of Employee in Employee table
/// Created By : Nirmal, 27-04-2015
/// Modified By :
/// </summary>
public ApplicationResult Employee_Update(EmployeeBo objEmployeeBo)
{
try
{
pSqlParameter = new SqlParameter[25];
pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objEmployeeBo.Id;
pSqlParameter[1] = new SqlParameter("@Name", SqlDbType.NVarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objEmployeeBo.Name;
pSqlParameter[2] = new SqlParameter("@Code", SqlDbType.NVarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objEmployeeBo.Code;
pSqlParameter[3] = new SqlParameter("@BranchId", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objEmployeeBo.BranchId;
pSqlParameter[4] = new SqlParameter("@OrganisationId", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objEmployeeBo.OrganisationId;
pSqlParameter[5] = new SqlParameter("@RoleId", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objEmployeeBo.RoleId;
pSqlParameter[6] = new SqlParameter("@DepartmentId", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objEmployeeBo.DepartmentId;
pSqlParameter[7] = new SqlParameter("@DesignationId", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objEmployeeBo.DesignationId;
pSqlParameter[8] = new SqlParameter("@ReportingToId", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objEmployeeBo.ReportingToId;
pSqlParameter[9] = new SqlParameter("@Address", SqlDbType.NVarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objEmployeeBo.Address;
pSqlParameter[10] = new SqlParameter("@ContactNo", SqlDbType.VarChar);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objEmployeeBo.ContactNo;
pSqlParameter[11] = new SqlParameter("@MobileNo", SqlDbType.VarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objEmployeeBo.MobileNo;
pSqlParameter[12] = new SqlParameter("@Email", SqlDbType.VarChar);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objEmployeeBo.Email;
pSqlParameter[13] = new SqlParameter("@IsUser", SqlDbType.Int);
pSqlParameter[13].Direction = ParameterDirection.Input;
pSqlParameter[13].Value = objEmployeeBo.IsUser;
pSqlParameter[14] = new SqlParameter("@UserName", SqlDbType.NVarChar);
pSqlParameter[14].Direction = ParameterDirection.Input;
pSqlParameter[14].Value = objEmployeeBo.UserName;
pSqlParameter[15] = new SqlParameter("@Password", SqlDbType.NVarChar);
pSqlParameter[15].Direction = ParameterDirection.Input;
pSqlParameter[15].Value = objEmployeeBo.Password;
pSqlParameter[16] = new SqlParameter("@JoinDate", SqlDbType.VarChar);
pSqlParameter[16].Direction = ParameterDirection.Input;
pSqlParameter[16].Value = objEmployeeBo.JoinDate;
pSqlParameter[17] = new SqlParameter("@BirthDate", SqlDbType.VarChar);
pSqlParameter[17].Direction = ParameterDirection.Input;
pSqlParameter[17].Value = objEmployeeBo.BirthDate;
pSqlParameter[18] = new SqlParameter("@MarriageDate", SqlDbType.VarChar);
pSqlParameter[18].Direction = ParameterDirection.Input;
pSqlParameter[18].Value = objEmployeeBo.MarriageDate;
pSqlParameter[19] = new SqlParameter("@AllowAccountAccess", SqlDbType.Int);
pSqlParameter[19].Direction = ParameterDirection.Input;
pSqlParameter[19].Value = objEmployeeBo.AllowAccountAccess;
pSqlParameter[20] = new SqlParameter("@IsResigned", SqlDbType.Int);
pSqlParameter[20].Direction = ParameterDirection.Input;
pSqlParameter[20].Value = objEmployeeBo.IsResigned;
pSqlParameter[21] = new SqlParameter("@ResignationDate", SqlDbType.VarChar);
pSqlParameter[21].Direction = ParameterDirection.Input;
pSqlParameter[21].Value = objEmployeeBo.ResignationDate;
pSqlParameter[22] = new SqlParameter("@LastWorkingDate", SqlDbType.VarChar);
pSqlParameter[22].Direction = ParameterDirection.Input;
pSqlParameter[22].Value = objEmployeeBo.LastWorkingDate;
pSqlParameter[23] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[23].Direction = ParameterDirection.Input;
pSqlParameter[23].Value = objEmployeeBo.LastModifiedBy;
pSqlParameter[24] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[24].Direction = ParameterDirection.Input;
pSqlParameter[24].Value = objEmployeeBo.LastModifiedDate;
sSql = "usp_tbl_Employee_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.Status = ApplicationResult.CommonStatusType.Success;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.Status = ApplicationResult.CommonStatusType.Failure;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objEmployeeBo = null;
}
}
