public ActionResult EditEmployeeDetail(string empId)
{
int id = Convert.ToInt32(empId);
var employeeDetails = EmployeeBAL.EditEmployeeDetail(id);
return(Json(employeeDetails.ToList(), JsonRequestBehavior.AllowGet));
}
// GET api/<controller>/5
public EmployeeDTO Get(int id)
{
EmployeeBAL employeeBAL = new EmployeeBAL();
EmployeeDTO emp = employeeBAL.GetEmployeeByID(id);
return(emp);
}
public ActionResult LeaveReport(FormCollection frm)
{
EmployeeLeaveApplyVM viewModel = new EmployeeLeaveApplyVM();
if (frm["EmployeeId"] != null && !string.IsNullOrEmpty(frm["EmployeeId"]))
{
viewModel.EmployeeId = Convert.ToInt32(frm["EmployeeId"]);
}
if (ModelState.IsValid)
{
PresentationLayer.Helpers.SessionHelper.ReportIndex = 5;
PresentationLayer.Helpers.SessionHelper.TempId = viewModel.EmployeeId;
return(Redirect(@"~\Report.aspx"));
}
else
{
EmployeeBAL employeeBAL = new EmployeeBAL();
viewModel.EmployeeList = from obj in employeeBAL.GetAll() select new SelectListItem()
{
Text = obj.FirstName.Trim() + " " + obj.MiddleName.Trim() + " " + obj.LastName.Trim(), Value = obj.EmployeeId.ToString()
};
return(View(viewModel));
}
}
public static void Upload(CloudBlockBlob blockBlob)
{
List <Employee> employeelist = new List <Employee>();
EmployeeBAL employeebal = new EmployeeBAL();
List <Employee> employeegenericlist = employeebal.GetEmployees(0);
Employee firstemployee = employeegenericlist[1];
Stream stream = new MemoryStream();
stream.Position = 0;
try
{
stream.Seek(0, SeekOrigin.Begin);
BinaryFormatter f = new BinaryFormatter();
f.Serialize(stream, firstemployee);
stream.Position = 0;
blockBlob.UploadFromStream(stream);
}
catch (Exception ex)
{
throw ex;
}
finally
{
stream.Close();
stream.Dispose();
}
}
// GET api/<controller>
public IEnumerable <EmployeeDTO> GetAllEmployees()
{
EmployeeBAL employeeBAL = new EmployeeBAL();
List <EmployeeDTO> emps = employeeBAL.getEmployees();
return(emps);
}
public ActionResult Index()
{
EmployeeBAL emp = new EmployeeBAL();
List <Employee> FirstEmployee = emp.GetAll.ToList();
return(View(FirstEmployee));
}
public ActionResult Delete(int Id, FormCollection collection)
{
EmployeeBAL emp = new EmployeeBAL();
int NewId = emp.Delete(Id);
return(RedirectToAction("Index", "Employee"));
}
public ActionResult Create(EmployeeViewModel employeemodel)
{
try
{
EmployeeBAL employeebal = new EmployeeBAL();
var employeeDto = Mapper.Map <Employee>(employeemodel);
if (ModelState.IsValid)
{
employeebal.InsertEmployee(employeeDto);
}
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudQueueClient queueClient = storageAccount.CreateCloudQueueClient();
CloudQueue queue = queueClient.GetQueueReference("employeequeue");
queue.CreateIfNotExists();
CloudQueueMessage message =
new CloudQueueMessage(employeeDto.FName + " " + employeeDto.LName + " added to blob!");
queue.AddMessage(message);
return(RedirectToAction("List"));
}
catch (Exception ex)
{
return(View());
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (selectedRecordId != 0)
{
try
{
Cursor = Cursors.WaitCursor;
EmployeeBAL _objBAL = new EmployeeBAL();
_objBAL.DeleteEmployee(selectedRecordId);
MessageBox.Show("Record has been deleted successfully!");
Cursor = Cursors.Default;
MakeEmpty();
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number == 547)
{
MessageBox.Show("You cannot delete this record. Its refference exists in other documents.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
MakeEmpty();
}
}
public void FillForm(Int32 _EmployeeId)
{
try
{
EmployeeBAL _objBAL = new EmployeeBAL();
EmployeeModel _objModel = _objBAL.SearchEmployee(_EmployeeId);
tbxAL.Text = _objModel._AL.ToString();
tbxCL.Text = _objModel._CL.ToString();
tbxCNIC.Text = _objModel._CNIC;
tbxEmployeeCode.Text = _objModel._Code.ToString();
tbxFatherName.Text = _objModel._FatherName;
tbxFirstName.Text = _objModel._FirstName;
tbxLastName.Text = _objModel._LastName;
tbxMobileNo.Text = _objModel._MobileNo;
tbxSalary.Text = _objModel._Salary.ToString();
tbxSL.Text = _objModel._SL.ToString();
dtpDOB.Text = _objModel._DOB.ToString();
dtpDOJ.Text = _objModel._DOJ.ToString();
cmbDepartment.SelectedValue = _objModel._DepartmentID;
cmbDesignation.SelectedValue = _objModel._DesignationID;
cmbShift.SelectedValue = _objModel._ShiftID;
cbxIsActive.Checked = _objModel._IsActive;
cbxMarried.Checked = _objModel._IsMarried;
richTextBox1.Text = _objModel._Address;
tbxResignDate.Text = _objModel._ResignDate;
pictureBox1.ImageLocation = string.IsNullOrEmpty(_objModel._ImageUrl) ? "F:\\Final Year Project\\Final\\SmartManger(V.1)\\SmartManger(V.1)\\Resources\\User_Avatar-128.png" : _objModel._ImageUrl;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public ActionResult Delete(int id)
{
var bal = new EmployeeBAL();
bal.Delete(id);
return(RedirectToAction("Index", "Employee"));
}
//
// GET: /SysAdmin/Employee/k
public ActionResult Index()
{
List <EmployeeVM> viewModels = new List <EmployeeVM>();
EmployeeBAL balObject = new EmployeeBAL();
IQueryable <Entities.Employee> entites = balObject.GetAll(SessionHelper.SchoolId);
foreach (Entities.Employee entity in entites)
{
EmployeeVM viewModel = new EmployeeVM();
viewModel.EmployeeId = entity.EmployeeId;
viewModel.EmployeeCode = entity.EmployeeCode;
viewModel.Password = entity.Password;
viewModel.FirstName = entity.FirstName;
viewModel.MiddleName = entity.MiddleName;
viewModel.LastName = entity.LastName;
viewModel.Category = entity.Category;
viewModel.Address = entity.Address;
viewModel.ContactNo = entity.ContactNo;
viewModel.DOB = entity.DOB;
viewModel.JoiningDate = entity.JoiningDate;
viewModels.Add(viewModel);
}
return(View(new GridModel <EmployeeVM> {
Data = viewModels
}));
}
/// <summary>
///This function is called when the update button is clicked on the form and passes the DTO object to the bussiness layer.
/// </summary>
private void bttn_update_Click(object sender, EventArgs e)
{
EmployeeBAL employeebalobj = new EmployeeBAL();
employeebalobj.update(add_to_DTOobj());
MessageBox.Show("updated successfully");
}
public ActionResult Delete(int Id)
{
EmployeeBAL emp = new EmployeeBAL();
Employee FirstEmployee = emp.GetById(Id);
return(View(FirstEmployee));
}
/// <summary>
///This function is called when the view button is clicked on the form
/// </summary>
private void bttn_view_Click(object sender, EventArgs e)
{
EmployeeBAL employeebalobj = new EmployeeBAL();
DataTable dt = new DataTable();
dt = employeebalobj.get();
grid_output.DataSource = dt;
}
public ActionResult Edit(int id)
{
var bal = new EmployeeBAL();
var model = new EmployeeModel();
model = bal.DetailByID(id);
return(View(model));
}
/// <summary>
/// This function get executed when the submit button is clicked and passes the DTO object to the Bussiness Layer
/// </summary>
private void submit_button_Click(object sender, EventArgs e)
{
EmployeeBAL employeebalobj = new EmployeeBAL();
employeebalobj.addusingDAL(add_to_DTOobj());
MessageBox.Show("Added successfully");
clearentries();
}
public JsonResult GetLeaveBalance(int EmployeeId)
{
decimal iBal = 0;
EmployeeBAL employeeBAL = new EmployeeBAL();
iBal = employeeBAL.getLeaveBalance(EmployeeId);
return(this.Json(iBal, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
var bal = new EmployeeBAL();
var model = new List <EmployeeModel>();
model = bal.EmpList();
return(View(model));
}
public ActionResult EmployeeLeaveApply()
{
EmployeeBAL employeeBAL = new EmployeeBAL();
EmployeeLeaveApplyVM viewModel = new EmployeeLeaveApplyVM();
viewModel.EmployeeList = from obj in employeeBAL.GetAll() select new SelectListItem()
{
Text = obj.FirstName.Trim() + " " + obj.MiddleName.Trim() + " " + obj.LastName.Trim(), Value = obj.EmployeeId.ToString()
};
return(View(viewModel));
}
public ActionResult Create(FormCollection formCollection)
{
Employee employee = new Employee();
employee.FirstName = formCollection["FirstName"];
employee.LastName = formCollection["LastName"];
employee.Age = Convert.ToByte(formCollection["Age"]);
EmployeeBAL emp = new EmployeeBAL();
int NewId = emp.Add(employee);
return(RedirectToAction("Details", "Employee", new { id = NewId }));
}
private void fxGetBranchZone()
{
List <clsMasBranchZone> clsMasBranchZones = EmployeeBAL.fxGetMasBranchZone();
if ((clsMasBranchZones != null) && clsMasBranchZones.Count > 0)
{
Response.Write(clsMasBranchZones.ToJSON());
}
else
{
Response.Write("No Result");
}
}
private void GetPosition()
{
List <EmployeePosition> maritalStatuses = EmployeeBAL.GetPosition();
if ((maritalStatuses != null) && maritalStatuses.Count > 0)
{
Response.Write(maritalStatuses.ToJSON());
}
else
{
Response.Write("No Result");
}
}
private void GetEmployee()
{
List <Employee> customers = EmployeeBAL.GetEmployee(Request.QueryString);
if ((customers != null) && customers.Count > 0)
{
Response.Write(customers.ToJSON());
}
else
{
Response.Write("No Result");
}
}
public ActionResult Delete(int id)
{
try
{
// TODO: Add delete logic here
EmployeeBAL balObject = new EmployeeBAL();
balObject.Delete(id);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(EmployeeModel emp)
{
if (ModelState.IsValid)
{
var bal = new EmployeeBAL();
bal.Update(emp);
return(RedirectToAction("Index", "Employee"));
}
else
{
return(View());
}
}
/*https://dotnettutorials.net/lesson/dependency-injection-design-pattern-csharp/*/
// GET: Employee
public ActionResult Index()
{
/*EmployeeBAL employeeBAL = new EmployeeBAL(); /* Now Employee BAL directly creates an object of Employee DAL
* Makes, Employee DAL a dependancy of EmployeeBAL class , tightly bound class object creation makes not independently testable*/
/* EmployeeBAL employeeBAL = new EmployeeBAL(new EmployeeDAL()); /* Now passing the EmployeeDAL object, but at receiver end, receive it as
* interface of the dependancy class, so that when unit testing we can create a dummy class with that same interface and sample method implementation,
* can test the class successfuly independently --> This is called as Construction Injection*/
EmployeeBAL employeeBAL = new EmployeeBAL();
//employeeBAL.IemployeeDAL = new EmployeeDAL();//Property Injection - can be used when injection can happen as late as possible, not like constructor injection.
IList <Employee> employees = employeeBAL.GetEmployees();
// IList<Employee> employees = employeeBAL.GetEmployees(new EmployeeDAL());//Method injection - can be used if only one method has dependancy involved, but not other methods
return(View(employees));
}
public ActionResult Search(int id)
{
if (id != 0)
{
var bal = new EmployeeBAL();
var model = new EmployeeModel();
model = bal.DetailByID(id);
return(View(model));
}
else
{
return(RedirectToAction("Index", "Employee"));
}
}
static int UpdateEmployeeDOB()
{
int noofemployeesupdated = 0;
try
{
EmployeeBAL employeebal = new EmployeeBAL();
noofemployeesupdated = employeebal.UpdateEmployeeDOB();
}
catch (Exception ex)
{
throw ex;
}
return(noofemployeesupdated);
}
public ActionResult _EmployeeLeaveAssign()
{
List <EmployeeLeaveAssignVM> viewModels = new List <EmployeeLeaveAssignVM>();
List <Entities.EmployeeLeaveTransaction> employeeList = new List <Entities.EmployeeLeaveTransaction>();
EmployeeBAL balObject = new EmployeeBAL();
IQueryable <Entities.EmployeeLeaveTransaction> entites = balObject.GetAllEmployeeLeaveAssign(SessionHelper.SchoolId);
foreach (Entities.EmployeeLeaveTransaction entity in entites)
{
EmployeeLeaveAssignVM viewModel = new EmployeeLeaveAssignVM();
viewModel.EmployeeId = entity.EmployeeId;
viewModel.EmployeeFullName = entity.EmployeeFullName;
viewModel.BalanceLeaves = entity.BalanceLeaves;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(PartialView("_EmployeeLeaveAssign", viewModels));
}
