private void button_Click(object sender, RoutedEventArgs e)
{
//if (textusername.Text == "user" && textpassword.Text == "pass123")
//{
// Window1 w1 = new Window1();
// this.Hide();
// w1.Show();
//}
EmployeeDB db = new EmployeeDB();
IEnumerable <string> productNames = from p in db.User select p.UserName;
MessageBox.Show(productNames.ToString());
//if (textusername.Text != string.Empty || textpassword.Text != string.Empty)
//{
// var user = db.User.FirstOrDefault(a => a.UserName.Equals(textusername.Text));
// if (user != null)
// {
// if (user.Password.Equals(textpassword.Text))
// {
// Window1 w1 = new Window1();
// this.Hide();
// w1.Show();
// }
// }
// MessageBox.Show(user.UserName);
//}
}
public void Initialize()
{
var builder = new DbContextOptionsBuilder();
_ = builder.UseInMemoryDatabase("AddMultipleEmployees");
employeeDB = new EmployeeDB(new EmployeeContext());
}
public ActionResult Create(Employee employee)
{
employee.Type = EmployeeTypeDB.GetInstance().FindEmployeeType(employee.Type.Id);
employee.Status = EmployeeStatusDB.GetInstance().FindEmployeeStatus(employee.Status.Id);
EmployeeDB.GetInstance().AddEmployee(employee);
return(Redirect("Index"));
}
public AdminViewModel(Page page)
: base(page)
{
Title = "Employee Roll Check Admin";
AdminData = new ObservableCollection<AdminModel>();
EmpDb = new EmployeeDB();
}
public ActionResult Employee(string firstName, string lastName, string emailAddress,
DateTime dateOfBirth, string title, double salary, string worksRemotely)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress) ||
string.IsNullOrEmpty(title) || string.IsNullOrEmpty(worksRemotely))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (var db = new EmployeeDB())
{
var employee = new MyEntity();
employee.FirstName = firstName;
employee.LastName = lastName;
employee.EmailAddress = emailAddress;
employee.DateOfBirth = dateOfBirth;
employee.Title = title;
employee.Salary = Convert.ToDouble(salary);
employee.WorksRemotely = CheckBool(worksRemotely);
db.MyEntities.Add(employee);
db.SaveChanges();
}
return(View("Success"));
}
}
public int lastIDPlusOne()
{
employee = new Employee();
employeeDB = new EmployeeDB();
employeeDB.selectLastID(employee);
return(employee.getID() + 1);
}
public void fillListViewForEvaluation(ListView listView, string sourceName, string dateFrom, string dateTo)
{
listView.Items.Clear();
locationControl = new LocationControl();
sourceControl = new SourceControl();
employee = new Employee();
employeeDB = new EmployeeDB();
connection = new DBConnection();
int sourceID = sourceControl.selectID(sourceName);
employee.setSourceID(sourceID);
employee.setDateFrom(dateFrom);
employee.setDateTo(dateTo);
SqlDataReader reader = employeeDB.fillListViewRelatedToSource(employee);
while (reader.Read())
{
ListViewItem lvi = new ListViewItem(reader["ID"].ToString());
lvi.SubItems.Add(reader["name"].ToString());
lvi.SubItems.Add(reader["position"].ToString());
int locationID = int.Parse(reader["locationID"].ToString());
string locationName = locationControl.getLocationName(locationID);
lvi.SubItems.Add(locationName);
listView.Items.Add(lvi);
}
connection.close();
}
public IEnumerable <AngEmployee> Get()
{
using (EmployeeDB entites = new EmployeeDB())
{
return(entites.AngEmployees.ToList());
}
}
protected void Page_Load(object sender, EventArgs e)
{
Label2.Visible = false;
lblDiasAcumulados.Visible = false;
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
EmployeeDB bd = new EmployeeDB();
Employee employee = bd.Select(id);
if (!IsAdmin(employee.Type))
{
Response.Redirect("../ErrorPages/AccessDanied.aspx");
}
else
{
lblMensage.Text = "Bem-vindo, " + employee.Name;
LoadCharts();
if (!Page.IsPostBack)
{
LoadFinishedBudgets();
//string orcamento_id = ddlFinishedBudgets.SelectedItem.Value;
//LoadLeadTimeKpi(orcamento_id);
}
//possivel solucao eh chamar o metodo aqui e esquecer o botao, ai faz o post
}
}
else
{
Response.Redirect("../ErrorPages/AccessDanied.aspx");
}
}
private void button1_Click(object sender, EventArgs e)
{
lbError.Text = "";
string EmpID = txtEmpID.Text;
string pass = txtPassword.Text;
EmployeeDB db = new EmployeeDB();
string role = db.CheckLogin(EmpID, pass);
if (role == "")
{
lbError.Text = "Sorry, this account is not exist!";
}
else if (role == "admin")
{
this.Hide();
frmMaintainBooks frm = new frmMaintainBooks();
frm.ShowDialog();
}
else if (role == "employee")
{
this.Hide();
Employee ee = new Employee()
{
EmpID = EmpID, EmpPassword = pass
};
frmChangeAccount frm = new frmChangeAccount(ee);
frm.ShowDialog();
}
}
public AdminViewModel(Page page)
: base(page)
{
Title = "Employee Roll Check Admin";
AdminData = new ObservableCollection <AdminModel>();
EmpDb = new EmployeeDB();
}
public bool Update(EmployeeDB employee)
{
try
{
using (Employee_RecoredEntities db = new Employee_RecoredEntities())
{
Employee item = (from x in db.Employees
where x.Id == employee.Id
select x).FirstOrDefault();
if (item == null)
{
return(false);
}
item.EmpName = employee.EmpName;
item.Email = employee.Email;
item.DateofBirth = employee.DateofBirth;
item.Phone = employee.Phone;
item.Gender = employee.Gender;
item.Address = employee.Address;
item.City = employee.City;
item.Department = employee.Department;
item.Salary = employee.Salary;
item.JoiningDate = employee.JoiningDate;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(Employee employee)
{
///Update employee
employee.Type = EmployeeTypeDB.GetInstance().FindEmployeeType(employee.Type.Id);
EmployeeDB.GetInstance().UpdateEmployee(employee);
return(Redirect("Index"));
}
private void btnLogin_Click(object sender, EventArgs e)
{
string id = txtEmID.Text;
string pass = txtEmPass.Text;
EmployeeDB edb = new EmployeeDB();
Employee em = edb.Login(id, pass);
if (em == null)
{
MessageBox.Show("Wrong ID or Password");
}
else
{
if (em.EmpRole == false)
{
frmChangeAccount change = new frmChangeAccount(em);
this.Hide();
change.ShowDialog();
this.Show();
}
else
{
frmMaintainBook main = new frmMaintainBook();
this.Hide();
main.ShowDialog();
this.Show();
}
}
}
public HttpResponseMessage Put([FromBody] Employee emp)
{
try
{
using (EmployeeDB db = new EmployeeDB())
{
var employee = db.Employees.FirstOrDefault(x => x.ID == emp.ID);
if (employee == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The Employee is not found"));
}
else
{
employee.FirstName = emp.FirstName;
employee.LastName = emp.LastName;
employee.Gender = emp.Gender;
employee.Salary = emp.Salary;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "The Employee with ID " + emp.ID.ToString() + " is modified successfully"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));;
}
}
private void button1_Click(object sender, EventArgs e)
{
//<connectionStrings>
// <add name="TestDBContext" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=E:\Backup_100916\VS2013\EFTest\EFTest\DB\Sample.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />
//</connectionStrings>
//AppDomain.CurrentDomain.SetData("DataDirectory", @"c:\users\tridip.bbakolkata\documents\visual studio 2013\Projects\EFTest\EFTest");
//Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AG.mdf;Database=AG;Integrated Security=True;User Instance=True;Trusted_Connection=Yes
AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory + "App_Data");
EmployeeDB db = new EmployeeDB();
var data = db.Employees.ToList();
/* good way to find parent directory*/
//string dataDir = AppDomain.CurrentDomain.BaseDirectory;
//if (dataDir.EndsWith(@"\bin\Debug\")
// || dataDir.EndsWith(@"\bin\Release\"))
//{
// dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
// AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
//}
}
// PUT api/employee/5
//public void Put(int id, [FromBody]EmployeeModel employee)
//{
// try
// {
// using (var empDbContext = new EmployeeDB())
// {
// var employeeList = empDbContext.emps.ToList();
// var employeeToBeUpdated = employeeList.Find(x => x.empno == id);
// emp emp = AdaptToDBEntity(employee);
// employeeToBeUpdated.ename = emp.ename;
// employeeToBeUpdated.hiredate = emp.hiredate;
// employeeToBeUpdated.job = emp.job;
// employeeToBeUpdated.sal = emp.sal;
// empDbContext.emps.AddOrUpdate(employeeToBeUpdated);
// empDbContext.SaveChanges();
// }
// }
// catch (Exception e)
// {
// Console.WriteLine(e);
// throw;
// }
//}
//public HttpResponseMessage Put(int id, [FromBody]EmployeeModel employee)
//{
// try
// {
// using (var empDbContext = new EmployeeDB())
// {
// var employeeList = empDbContext.emps.ToList();
// var employeeToBeUpdated = employeeList.Find(x => x.empno == id);
// emp emp = AdaptToDBEntity(employee);
// employeeToBeUpdated.ename = emp.ename;
// employeeToBeUpdated.hiredate = emp.hiredate;
// employeeToBeUpdated.job = emp.job;
// employeeToBeUpdated.sal = emp.sal;
// empDbContext.emps.AddOrUpdate(employeeToBeUpdated);
// empDbContext.SaveChanges();
// return Request.CreateResponse(HttpStatusCode.Accepted);
// }
// }
// catch (Exception e)
// {
// Console.WriteLine(e);
// return Request.CreateErrorResponse(HttpStatusCode.BadRequest, e);
// }
//}
public IHttpActionResult Put(int id, [FromBody] EmployeeModel employee)
{
try
{
using (var empDbContext = new EmployeeDB())
{
var employeeList = empDbContext.emps.ToList();
var employeeToBeUpdated = employeeList.Find(x => x.empno == id);
emp emp = AdaptToDBEntity(employee);
employeeToBeUpdated.ename = emp.ename;
employeeToBeUpdated.hiredate = emp.hiredate;
employeeToBeUpdated.job = emp.job;
employeeToBeUpdated.sal = emp.sal;
empDbContext.emps.AddOrUpdate(employeeToBeUpdated);
empDbContext.SaveChanges();
return(Ok());
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(Content(HttpStatusCode.BadRequest, e));
}
}
private void ListEmployeeReport()
{
try
{
grdList.Rows.Clear();
EmployeeDB empdb = new EmployeeDB();
List <employee> emplist = empdb.getEmployees();
foreach (employee mh in emplist)
{
grdList.Rows.Add();
grdList.Rows[grdList.RowCount - 1].Cells["mSerialNo"].Value = grdList.Rows.Count;
grdList.Rows[grdList.RowCount - 1].Cells["mEmployeeID"].Value = mh.empID;
grdList.Rows[grdList.RowCount - 1].Cells["mEmpoyeeName"].Value = mh.empName;
grdList.Rows[grdList.RowCount - 1].Cells["mOffice"].Value = mh.office;
grdList.Rows[grdList.RowCount - 1].Cells["mReportingOfficer"].Value = mh.reportingofficer;
grdList.Rows[grdList.RowCount - 1].Cells["mDesignation"].Value = mh.designation;
grdList.Rows[grdList.RowCount - 1].Cells["mDepartment"].Value = mh.department;
}
if (grdList.Rows.Count != 0)
{
btnExportToExcell.Visible = true;
}
else
{
btnExportToExcell.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Error in PR Listing");
}
setButtonVisibility("init");
pnlList.Visible = true;
}
private static void Main()
{
// Db setup
var db = new EmployeeDB();
// Add some employees
db.AddEmployee(new Employee("Anne", 3000, 51));
db.AddEmployee(new Employee("Berit", 4000, 25));
db.AddEmployee(new Employee("Christel", 1000, 37));
// Setup compile
var compiledDb = new CompileDB(db);
var reportGenerator = new ReportGenerator(compiledDb);
//Default (name-first) report
reportGenerator.GenerateReport();
Console.WriteLine("");
Console.WriteLine("");
// Create a salary-first report
reportGenerator.SetOutputFormat(ReportOutputFormatType.SalaryFirst);
reportGenerator.GenerateReport();
Console.WriteLine("");
Console.WriteLine("");
// Create an age-first report
reportGenerator.SetOutputFormat(ReportOutputFormatType.AgeFirst);
reportGenerator.GenerateReport();
Console.ReadLine();
}
// GET api/employee/5
//public EmployeeModel GetEmployee(int id)
//{
// try
// {
// using (var empDbContext = new EmployeeDB())
// {
// var employeeList = empDbContext.emps.ToList();
// List<EmployeeModel> employees = AdaptToEmployeeModel(employeeList);
// if (employees != null)
// {
// return employees.Find(x => x.EmpId == id);
// }
// return null;
// }
// }
// catch (Exception e)
// {
// Console.WriteLine(e);
// throw;
// }
//}
//public HttpResponseMessage GetEmployee(int id)
//{
// try
// {
// using (var empDbContext = new EmployeeDB())
// {
// var employeeList = empDbContext.emps.ToList();
// List<EmployeeModel> employees = AdaptToEmployeeModel(employeeList);
// var employee = employees?.Find(x => x.EmpId == id);
// if (employee != null)
// {
// return Request.CreateResponse(HttpStatusCode.OK, employee);
// }
// return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id = " + id + " not found"); ;
// }
// }
// catch (Exception e)
// {
// Console.WriteLine(e);
// return Request.CreateErrorResponse(HttpStatusCode.BadRequest, e);
// }
//}
public IHttpActionResult GetEmployee(int id)
{
try
{
using (var empDbContext = new EmployeeDB())
{
var employeeList = empDbContext.emps.ToList();
List <EmployeeModel> employees = AdaptToEmployeeModel(employeeList);
var employee = employees?.Find(x => x.EmpId == id);
if (employee != null)
{
return(Ok(employee));
}
// return NotFound();
// For giving custom message use the below return
return(Content(HttpStatusCode.NotFound, "Employee with id = " + id + " not found"));
}
}
catch (Exception e)
{
Console.WriteLine(e);
// return BadRequest();
return(Content(HttpStatusCode.BadRequest, e));
}
}
public EmployeeDB Insert(EmployeeDB employee)
{
try
{
Employee emp = new Employee();
emp.EmpName = employee.EmpName;
emp.Email = employee.Email;
emp.DateofBirth = employee.DateofBirth;
emp.Phone = employee.Phone;
emp.Gender = employee.Gender;
emp.Address = employee.Address;
emp.City = employee.City;
emp.Department = employee.Department;
emp.Salary = employee.Salary;
emp.JoiningDate = employee.JoiningDate;
using (Employee_RecoredEntities db = new Employee_RecoredEntities())
{
db.Employees.Add(emp);
db.SaveChanges();
}
employee.Id = emp.Id;
return(employee);
}
catch (Exception ex)
{
Console.Write(ex.Message);
throw;
}
}
public IEnumerable <EmployeeLog> GetEmployeeLog(string phone)
{
EmpDb = new EmployeeDB();
var dCurrent = DateTime.Now;
var empsorted = new List <EmployeeLog>();
try
{
var IempLogs = EmpDb.GetEmployeeLogList();
var empDetails = EmpDb.GetEmployeeDetails();
var firstEmp = empDetails.FirstOrDefault(c => c.Phone == phone);
var empId = firstEmp.Id;
var empLogs = IempLogs.Where(c => c.EmpId == empId).ToList();
var emplogDetails = empLogs.Select(c => new EmployeeLog()
{
EmpID = c.EmpId,
LogTime = Convert.ToDateTime(c.LogTime),
LogType = c.LogType
}).ToList();
empsorted = emplogDetails.OrderByDescending(c => c.LogTime.Value).ToList();
}
catch (Exception ex)
{
string msg = ex.Message;
}
return(empsorted);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Employee emp = new Employee();
if (!(EmployeeDB.IsDuplicateId(Convert.ToInt32(tbEmployeeId.Text))))
{
if (Validation.IsValidName(tbFirstName.Text) && Validation.IsValidName(tbLastName.Text))
{
emp.EmployeeId = Convert.ToInt32(tbEmployeeId.Text);
emp.FirstName = tbFirstName.Text;
emp.LastName = tbLastName.Text;
emp.JobTitle = tbJobType.Text;
emp.DeleteEmployee(emp);
MessageBox.Show("Data Deleted,Thanks", "Confirmation");
tbEmployeeId.Text = tbFirstName.Text = tbLastName.Text = tbJobType.Text = null;
}
else
{
MessageBox.Show("Enter Valid Name", "Error");
}
}
else
{
MessageBox.Show("ID does not exist", "Error");
}
}
public IHttpActionResult Post(List <EmployeeData> data)
{
string token = string.Empty;
IEnumerable <string> headerValues;
if (Request.Headers.TryGetValues("X-Fourth-Token", out headerValues))
{
token = headerValues.FirstOrDefault();
}
//Validate token
string expirationDate = GetExpirationTime(token);
DateTime expirationDateTime = DateTime.ParseExact(expirationDate, "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
if (expirationDate != null && expirationDateTime < DateTime.Now)
{
return(Unauthorized());
}
//Save EmployeeId and Time into DB
foreach (EmployeeData item in data)
{
var db = new EmployeeDB();
db.Arrivals.Add(new Arrival {
EmployeeID = item.EmployeeId, Time = item.When
});
db.SaveChanges();
}
return(Ok());
}
static void Main(string[] args)
{
string connectionString =
ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString;
var employeeDb = new EmployeeDB(connectionString);
IList <EmployeeDetails> employeeList = employeeDb.GetEmployees();
foreach (var employeeDetailse in employeeList)
{
Console.WriteLine("\n\t{0} {1} {2}", employeeDetailse.TitleOfCourtesy,
employeeDetailse.FirstName, employeeDetailse.LastName);
}
Console.ReadKey();
Console.Clear();
var employee = new EmployeeDetails()
{
FirstName = "Elizavete",
LastName = "Ivanova",
TitleOfCourtesy = "Ms"
};
employeeDb.InsertEmployee(employee);
foreach (var employeeDetailse in employeeDb.GetEmployees())
{
Console.WriteLine("\n\t{0} {1} {2}", employeeDetailse.TitleOfCourtesy,
employeeDetailse.FirstName, employeeDetailse.LastName);
}
}
public string getNationalID(int ID)
{
employee = new Employee();
employeeDB = new EmployeeDB();
employee.setID(ID);
employeeDB.selectNationalID(employee);
return(employee.getNationalID());
}
private void PopulateGridviewSearchResult()
{
DataTable searchResultsDataTable = EmployeeDB.GetEmployeeWithAddressBySearchCriteria(searchBy, searchString);
gViewSearchResults.DataSource = searchResultsDataTable;
gViewSearchResults.DataBind();
lblSearchResultCount.Text = "Search Results . . . . . Found " + searchResultsDataTable.Rows.Count + " row(s).";
}
public ActionResult DeleteConfirmed(int id)
{
EmployeeDB employeeDB = db.EmployeeDBs.Find(id);
db.EmployeeDBs.Remove(employeeDB);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Load()
{
XmlSerializer serializer = new XmlSerializer(typeof(EmployeeDB));
FileStream stream = new FileStream(Application.dataPath + "/Saves/save.xml", FileMode.Open);
employeeDB = serializer.Deserialize(stream) as EmployeeDB;
stream.Close();
}
public string getPosition(int ID)
{
employee = new Employee();
employeeDB = new EmployeeDB();
employee.setID(ID);
employeeDB.selectPosition(employee);
return(employee.getPosition());
}
public EmployeeMainViewModel(IDevice device)
: base(device)
{
Message = String.Format("Hello Xamarin Forms Labs MVVM Basics!! How is your {0} device", device.Manufacturer);
Title = "Employee Roll Checker";
Message = "Employee Roll Check";
EmpDb = new EmployeeDB();
}
public EmployeeMainViewModel(IDevice device)
: base(device)
{
Message = String.Format("Hello Xamarin Forms Labs MVVM Basics!! How is your {0} device", device.Manufacturer);
Title = "Employee Roll Checker";
Message = "Employee Roll Check";
EmpDb = new EmployeeDB();
}
public EmployeeMainViewModel(Page page, string phone)
: base(page)
{
Title = "Employee Roll Checker";
phoneNumber = phone;
if(!string.IsNullOrEmpty(phoneNumber))
GetEmployeeDetails(phone);
BtnName = login;
EmpDb = new EmployeeDB();
}
public static void Clock(string phone, LogType logtype)
{
var EmpDb = new EmployeeDB();
var d = DateTime.Now;
var clockTime = DateTimeSQLite.Value(d);
var emp = EmpDb.GetEmployeeDetails().FirstOrDefault(c => c.Phone == phone);
var log = new LogDetails()
{
EmpId = emp.Id,
LogType = logtype.ToString(),
LogTime = clockTime,
};
EmpDb.AddEmployeeLog(log);
}
static void Main(string[] args)
{
var db = new EmployeeDB();
// Add some employees
db.AddEmployee(new Employee("Anne", 3000, 10));
db.AddEmployee(new Employee("Berit", 2000, 12));
db.AddEmployee(new Employee("Christel", 1000, 4));
var reportGenerator = new ReportGenerator(db);
// Create a default (name-first) report
reportGenerator.CompileReport();
Console.WriteLine("");
Console.WriteLine("");
// Create a salary-first report
reportGenerator.CompileReport();
}
public EmployeeMainViewModel()
{
Title = "Employee Roll Checker";
Message = "Employee Roll Check";
EmpDb = new EmployeeDB();
}
public IEnumerable<EmployeeLog> GetEmployeeLog(string phone)
{
EmpDb = new EmployeeDB();
var dCurrent = DateTime.Now;
var empsorted = new List<EmployeeLog>();
try
{
var IempLogs = EmpDb.GetEmployeeLogList();
var empDetails = EmpDb.GetEmployeeDetails();
var firstEmp = empDetails.FirstOrDefault(c => c.Phone == phone);
var empId = firstEmp.Id;
var empLogs = IempLogs.Where(c => c.EmpId == empId).ToList();
var emplogDetails = empLogs.Select(c => new EmployeeLog()
{
EmpID = c.EmpId,
LogTime = Convert.ToDateTime(c.LogTime),
LogType = c.LogType
}).ToList();
empsorted = emplogDetails.OrderByDescending(c => c.LogTime.Value).ToList();
}
catch (Exception ex)
{
string msg = ex.Message;
}
return empsorted;
}
