private async void AttendanceTransactionHandler(string EnrollNumber, int IsInValid, int AttState, int VerifyMethod, int Year, int Month, int Day, int Hour, int Minute, int Second, int WorkCode) { StringBuilder sb = new StringBuilder(); // GENERATE LOG TIME -------------------------------------------------------------------------------------------------------------------- DateTime dt = DateTime.Now; /* * sb.AppendLine("Enroll Number: " + EnrollNumber); * sb.AppendLine("Invalid?: " + IsInValid); * sb.AppendLine("Attendance State: " + AttState); * sb.AppendLine("Verify Method: " + VerifyMethod); * sb.AppendLine("Year: " + Year); * sb.AppendLine("Month: " + Month); * sb.AppendLine("Day: " + Day); * sb.AppendLine("Hour: " + Hour); * sb.AppendLine("Minute: " + Minute); * sb.AppendLine("Second: " + Second); * sb.AppendLine("Work Code: " + WorkCode); */ // USER IS VERIFIED if (IsInValid <= 0) { sb.AppendLine(" ------ [EMPLOYEE LOG] ------"); sb.AppendFormat("User ID: {0}", EnrollNumber); sb.AppendFormat("\nLog Time: {0}", dt.ToLongDateString()); } Logs.Items.Add(sb.ToString()); // SEND DATA TO SERVER ------------------------------------------------------------------------------------------------------------------ EmployeeLog el = new EmployeeLog(); el.enrollNumber = EnrollNumber; el.timestamp = dt; el.attendanceState = AttState; // SERIALIZE EMPLOYEE OBJECT TO JSON DATA FORMAT var json = JsonConvert.SerializeObject(el); var data = new StringContent(json, Encoding.UTF8, "application/json"); // SEND POST REQUEST TO SERVER var client = new HttpClient(); HttpResponseMessage response; try { response = await client.PostAsync(API_URL, data); string result = response.Content.ReadAsStringAsync().Result; Logs.Items.Add(result); } catch (Exception e) { Console.WriteLine(e); Logs.Items.Add("ERROR: Server failed to process employeeLog attendance log"); } }
public ActionResult Create(EmployeeLog employeeLog) { var logname = _iFEmployeeLog.Readlogtype(employeeLog.LogTypeId); employeeLog.SuccesLogin = true; employeeLog.LogName = logname.Name; employeeLog = _iFEmployeeLog.Create(UserId, employeeLog); return(RedirectToAction("Index")); }
public EmployeeLog Update(int userId, EmployeeLog employeeLog) { var eEmployeeLog = EEmployeeLog(employeeLog); eEmployeeLog.UpdatedDate = DateTime.Now; eEmployeeLog.UpdatedBy = userId; eEmployeeLog = _iDEmployeeLog.Update(EEmployeeLog(employeeLog)); return(EmployeeLog(eEmployeeLog)); }
public EmployeeLog Create(int userId, EmployeeLog employeelog) { EEmployeeLog eEmployeeLog = EEmployeeLog(employeelog); eEmployeeLog.CreatedDate = DateTime.Now; eEmployeeLog.CreatedBy = userId; eEmployeeLog = _iDEmployeeLog.Create(eEmployeeLog); return(EmployeeLog(eEmployeeLog)); }
public void UserLog() { string logtype = Request["logtype"]; string empid = Request["empid"]; string empname = Request["empname"]; if (logtype == "O") { EmployeeLog.InsertLogOutTime(empid, empname); } }
public ActionResult CreateLog(EmployeeLog employeeLog) { var employee = _iFEmployee.Read(employeeLog.EmployeeNumber, employeeLog.Pin); bool IsSuccess = employee.EmployeeId != 0 && employee.Pin == employeeLog.Pin; employeeLog.LogDate = DateTime.Now; employeeLog.EmployeeId = employee.EmployeeId; employeeLog.SuccesLogin = IsSuccess; employeeLog = _iFEmployeeLog.Create(UserId, employeeLog); employeeLog.EmployeeImageBase64 = employee.EmployeeImageBase64; return(RedirectToAction("CreateLog", new { id = employeeLog.EmployeeLogId })); }
public EmployeeLog InsertEmployeeLog(Employee employee, int locationId) { EmployeeLog log = new EmployeeLog(); log.Employee = employee; log.SignInDate = DateTime.Now; log.LocationId = locationId; Session.Save(log); return(log); }
public IActionResult EmployeeLog(EmployeeLog model) { if (ModelState.IsValid) { CreateEmployeeLog(model.AccessLocationID, model.StationID, model.AccessDate, model.IDCardNumber, model.DeclineReason); return(RedirectToAction("Index")); } return(View()); }
public static int CreateEmployeeLog(int accessLocationID, string stationID, DateTime accessDate, int iDCardNumber, string declineReason) { EmployeeLog data = new EmployeeLog { AccessLocationID = accessLocationID, StationID = stationID, AccessDate = accessDate, IDCardNumber = iDCardNumber, DeclineReason = declineReason }; string sql = @"insert into dbo.AccessLogs (AccessLocationID, StationID, AccessDate, IDCardNumber, DeclineReason) values(@AccessLocationID, @StationID, @AccessDate, @IDCardNumber, @DeclineReason);"; return(SqlDataAccess.SaveData(sql, data)); }
public ActionResult Create(EmployeeLog employeeLog) { var employee = _iFEmployee.Read(employeeLog.EmployeeNumber, employeeLog.Pin); if (employee.EmployeeId == 0) { //return View(employeeLog); //return error ModelState.AddModelError("EmployeeNumber", "Employee Number or Pin does not exist"); return(View(new EmployeeLog())); } else { employeeLog.EmployeeId = employee.EmployeeId; _iFEmployeeLog.Create(UserId, employeeLog); return(RedirectToAction("Index")); } }
public static bool IsSaveLogEmployee(EmployeeLog employee) { MySqlConnection conn = new MySqlConnection(GlobalVariable.ConnectionString); conn.Open(); MySqlTransaction tran = conn.BeginTransaction(); try { MySqlCommand cmd = conn.CreateCommand(); cmd.Transaction = tran; cmd.CommandText = QuerySaveLogEmployee(employee); cmd.ExecuteNonQuery(); cmd.CommandText = "SELECT MAX(EmployeeLogID) from provident.employeelog ;"; string lastHDID = cmd.ExecuteScalar().ToString(); foreach (EmployeeLogDetail employeeLogDetail in employee.employeeLogDetails) { employeeLogDetail.EmployeeLogID = Convert.ToInt32(lastHDID); cmd.Transaction = tran; cmd.CommandText = QuerySaveLogEmployeeDetail(employeeLogDetail); cmd.ExecuteNonQuery(); } tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } tran.Dispose(); } return(false); }
private EmployeeLog EmployeeLog(EEmployeeLog eEmployeeLog) { EmployeeLog returnEmployeeLog = new EmployeeLog { SuccesLogin = eEmployeeLog.SuccesLogin, CreatedDate = eEmployeeLog.CreatedDate, LogDate = eEmployeeLog.LogDate, UpdatedDate = eEmployeeLog.UpdatedDate, LogName = eEmployeeLog.LogName, CreatedBy = eEmployeeLog.CreatedBy, EmployeeId = eEmployeeLog.EmployeeId, EmployeeLogId = eEmployeeLog.EmployeeLogId, LogTypeId = eEmployeeLog.LogTypeId, UpdatedBy = eEmployeeLog.UpdatedBy, EmployeeNumber = eEmployeeLog.EmployeeNumber }; return(returnEmployeeLog); }
public ActionResult Create(EmployeeLog employeeLog) { var employee = _iFEmployee.Read(employeeLog.EmployeeNumber, employeeLog.Pin); var logname = _iFEmployeeLog.Readlogtype(employeeLog.LogTypeId); bool IsSuccess = employee.EmployeeId != 0 && employee.Pin == employeeLog.Pin; employeeLog.LogName = logname.Name; employeeLog.EmployeeId = employee.EmployeeId; employeeLog.SuccesLogin = IsSuccess; employeeLog = _iFEmployeeLog.Create(UserId, employeeLog); employeeLog.EmployeeImage = employee.EmployeeImage; if (!IsSuccess) { return(View(employeeLog)); } else { return(View(employeeLog)); } }
private EEmployeeLog EEmployeeLog(EmployeeLog employeelog) { EEmployeeLog returnEEmployeeLog = new EEmployeeLog { CreatedDate = employeelog.CreatedDate, LogDate = employeelog.LogDate, UpdatedDate = employeelog.UpdatedDate, CreatedBy = employeelog.CreatedBy, EmployeeId = employeelog.EmployeeId, EmployeeLogId = employeelog.EmployeeLogId, LogTypeId = employeelog.LogTypeId, UpdatedBy = employeelog.UpdatedBy, // LogName = employeelog.LogName, EmployeeNumber = employeelog.EmployeeNumber }; return(returnEEmployeeLog); }
public static List <EmployeeLog> LoadDataEmployeeLog() { List <EmployeeLog> employees = new List <EmployeeLog>(); MySqlConnection conn = new MySqlConnection(GlobalVariable.ConnectionString); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = QueryGetDataEmployeeLog(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { EmployeeLog emp = new EmployeeLog(); emp.EmployeeLogID = ReaderHepler.GetValueFromReader <int>(reader, nameof(EmployeeLog.EmployeeLogID)); emp.Firstname = ReaderHepler.GetValueFromReader <string>(reader, nameof(EmployeeLog.Firstname)); emp.Lastname = ReaderHepler.GetValueFromReader <string>(reader, nameof(EmployeeLog.Lastname)); emp.DateOfBirth = ReaderHepler.GetValueFromReader <DateTime>(reader, nameof(EmployeeLog.DateOfBirth)); emp.StartWorkDate = ReaderHepler.GetValueFromReader <DateTime>(reader, nameof(EmployeeLog.StartWorkDate)); emp.Salary = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLog.Salary)); emp.ProvidentFundRate = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLog.ProvidentFundRate)); emp.ProvidentFundCollectAmount = ReaderHepler.GetValueFromReader <decimal>(reader, nameof(EmployeeLog.ProvidentFundCollectAmount)); emp.employeeLogDetails = GetEmployeeLogDetail(emp.EmployeeLogID); employees.Add(emp); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(employees); }
private void BtnSave_Click(object sender, EventArgs e) { CalulateOnGird(); if (!IsValidate()) { return; } EmployeeLog employee = PrepareData(); if (!EmployeeManager.IsSaveLogEmployee(employee)) { MessageBox.Show("Fail !", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MessageBox.Show("Success !", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearData(); }
private void GetUserLog() { string empid = Request["empid"]; var collection = EmployeeLog.GetAllLogtimeByUser(empid); JsonBridge <EmployeeLog> datafeed = new JsonBridge <EmployeeLog>(); if (collection.Count != 0) { datafeed.collection = collection; datafeed.Valid = 1; } else { datafeed.collection = collection; datafeed.Valid = 0; } string output = JsonConvert.SerializeObject(datafeed); Response.Write(output); }
private static string QuerySaveLogEmployee(EmployeeLog employee) { List <QuerySource> querySources = new List <QuerySource>(); querySources.Add(new QuerySource { FieldName = nameof(EmployeeLog.Firstname), Value = StringFormatHelper.GetSingleQuote(employee.Firstname) }); querySources.Add(new QuerySource { FieldName = nameof(EmployeeLog.Lastname), Value = StringFormatHelper.GetSingleQuote(employee.Lastname) }); querySources.Add(new QuerySource { FieldName = nameof(EmployeeLog.DateOfBirth), Value = StringFormatHelper.GetSingleQuote(StringFormatHelper.GetShortEnDateFormat(employee.DateOfBirth)) }); querySources.Add(new QuerySource { FieldName = nameof(EmployeeLog.StartWorkDate), Value = StringFormatHelper.GetSingleQuote(StringFormatHelper.GetShortEnDateFormat(employee.StartWorkDate)) }); querySources.Add(new QuerySource { FieldName = nameof(EmployeeLog.Salary), Value = (employee.Salary) }); querySources.Add(new QuerySource { FieldName = nameof(EmployeeLog.ProvidentFundRate), Value = (employee.ProvidentFundRate) }); querySources.Add(new QuerySource { FieldName = nameof(EmployeeLog.ProvidentFundCollectAmount), Value = (employee.ProvidentFundCollectAmount) }); var fieldNames = querySources.Select(a => a.FieldName).ToArray(); var values = querySources.Select(a => a.Value).ToArray(); string query = "INSERT INTO provident.employeelog ( " + string.Join(",", fieldNames) + ") VALUES ( " + string.Join(",", values) + " " + ");" ; return(query); }
public ActionResult Update(EmployeeLog employeeLog) { employeeLog = _iFEmployeeLog.Update(UserId, employeeLog); return(RedirectToAction("Index")); }
public ActionResult Create(EmployeeLog employeeLog) { employeeLog.SuccesLogin = true; employeeLog = _iFEmployeeLog.Create(UserId, employeeLog); return(RedirectToAction("Index")); }
public EmployeeLog InsertEmployeeLog(Employee employee, int locationId) { EmployeeLog log = new EmployeeLog(); log.Employee = employee; log.SignInDate = DateTime.Now; log.LocationId = locationId; Session.Save(log); return log; }
protected void btnLogout_Click(object sender, EventArgs e) { EmployeeLog.InsertLogOutTime(GlobalAccess.EmpID, GlobalAccess.Fullname); ClearServerApplication(); }
private void DeleteOrder(DataGridViewCellEventArgs e) { DialogResult result = MessageBox.Show("Bạn muốn xóa đơn hàng này?", "Xoá đơn hàng", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { DataGridViewRow currentRow = dgwOrderList.Rows[e.RowIndex]; OrderService orderService = new OrderService(); int id = ObjectHelper.GetValueFromAnonymousType <int>(currentRow.DataBoundItem, "Id"); Order order = orderService.GetOrder(id); DateTime systime = BaoHienRepository.GetBaoHienDBDataContext().GetSystemDate(); #region CustomerLog CustomerLogService cls = new CustomerLogService(); CustomerLog cl = cls.GetCustomerLog(order.OrderCode); bool kq = true; if (cl != null) { kq = cls.DeleteCustomerLog(cl.Id); } #endregion #region ProductLog ProductLogService productLogService = new ProductLogService(); OrderDetailService orderDetailService = new OrderDetailService(); List <OrderDetail> details = orderDetailService.SelectOrderDetailByWhere(x => x.OrderId == order.Id).ToList(); ProductLog pl, newpl; foreach (OrderDetail item in details) { pl = productLogService.GetProductLog(item.ProductId, item.AttributeId, item.UnitId); newpl = new ProductLog() { ProductId = item.ProductId, AttributeId = item.AttributeId, UnitId = item.UnitId, BeforeNumber = pl.AfterNumber, Amount = item.NumberUnit, AfterNumber = pl.AfterNumber + item.NumberUnit, RecordCode = order.OrderCode, Status = BHConstant.DEACTIVE_STATUS, Direction = BHConstant.DIRECTION_IN, UpdatedDate = systime }; productLogService.AddProductLog(newpl); } productLogService.DeactiveProductLog(order.OrderCode); #endregion #region EmployeeLog int salerId = (int)order.Customer.SalerId; if (salerId > 0) { EmployeeLogService els = new EmployeeLogService(); EmployeeLog order_el = els.SelectEmployeeLogByWhere(x => x.RecordCode == order.OrderCode).FirstOrDefault(); if (order_el != null) { els.DeleteEmployeeLog(order_el.Id); } } #endregion if (!orderService.DeleteOrder(id) && kq) { MessageBox.Show("Hiện tại hệ thống đang có lỗi. Vui lòng thử lại sau!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } loadOrderList(); } }