private void grdList_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { ////MessageBox.Show("grdList_CellDoubleClick()"); try { if (e.RowIndex < 0) { return; } string offName = grdList.Rows[e.RowIndex].Cells["OfficeID"].Value.ToString(); string offdesc = grdList.Rows[e.RowIndex].Cells["Office"].Value.ToString(); string stat = grdList.Columns[e.ColumnIndex].Name; AttendanceDB Adb = new AttendanceDB(); dgvAttendenceDetails.Rows.Clear(); List <attendance> emplst = Adb.getEmployeeoffceList(offName, stat); foreach (attendance emp in emplst) { dgvAttendenceDetails.Rows.Add(); dgvAttendenceDetails.Rows[dgvAttendenceDetails.RowCount - 1].Cells["EmployeeID"].Value = Convert.ToInt32(emp.EmployeeID); dgvAttendenceDetails.Rows[dgvAttendenceDetails.RowCount - 1].Cells["EmployeeName"].Value = emp.EmployeeName; dgvAttendenceDetails.Rows[dgvAttendenceDetails.RowCount - 1].Cells["Status"].Value = emp.AttendenceStatus; dgvAttendenceDetails.Rows[dgvAttendenceDetails.RowCount - 1].Cells["Office"].Value = emp.officeName; } closeAllPanels(); pnlLeaveDetailOuter.Visible = true; pnlLeaveDetailInner.Visible = true; } catch (Exception ex) { } }
public int getLastID() { attendance = new Attendance(); attendanceDB = new AttendanceDB(); attendanceDB.selectLastID(attendance); return(attendance.getID()); }
// Get Random Module private int GetRandomModuleId(AttendanceDB Context) { return(Context.Modules.Select(s => new { s.id, order = Guid.NewGuid() }) .OrderBy(o => o.order) .Select(s => s.id) .First()); }
private void btnSave_Click_1(object sender, EventArgs e) { try { foreach (DataGridViewRow cb in grdList.Rows) { if (cb.Cells[3].Value == null) { MessageBox.Show("Please enter attendence for all Employees!!!"); return; } } attendance att = new attendance(); List <attendance> attlstnew = new List <attendance>(); List <attendance> attlstupdt = new List <attendance>(); AttendanceDB docDB = new AttendanceDB(); foreach (DataGridViewRow dgvrw in grdList.Rows) { if (changedval.ContainsKey(dgvrw.Cells[1].Value.ToString())) { if (Initval.ContainsKey(dgvrw.Cells[1].Value.ToString())) { att = new attendance(); att.EmployeeID = dgvrw.Cells[1].Value.ToString(); att.AttendenceStatus = dgvrw.Cells[3].Value.ToString(); attlstupdt.Add(att); } else { att = new attendance(); att.EmployeeID = dgvrw.Cells[1].Value.ToString(); att.AttendenceStatus = dgvrw.Cells[3].Value.ToString(); attlstnew.Add(att); } } } DateTime dt = UpdateTable.getSQLDateTime(); if (Main.itemPriv[2]) { dt = dtpdate.Value; } if (docDB.UpdateAttendance(attlstupdt, attlstnew, empstatuslist, dt)) { MessageBox.Show("Attendance Status Updated"); changedval.Clear(); Initval.Clear(); ListEmployee(); } else { MessageBox.Show("Error Updating Attendance Status"); } } catch (Exception) { MessageBox.Show("Failed Adding / Editing User Data"); } }
public void insert(int month, int year, string locationName) { locationControl = new LocationControl(); attendance = new Attendance(); attendanceDB = new AttendanceDB(); int locationID = locationControl.getID(locationName); attendance.setMonth(month); attendance.setYear(year); attendance.setLocationID(locationID); attendanceDB.insert(attendance); }
public Task_13ViewModel() { InitViewProperties(); InitCommands(); InformationData = new AttendanceDB(); InformationData.Init(); InformationData.SetDefaultStructure(); InformationData.ReloadTables(); OnPropertyChanged(nameof(InformationData)); }
public int getID(int month, int year, string locationName) { locationControl = new LocationControl(); attendance = new Attendance(); attendanceDB = new AttendanceDB(); int locationID = locationControl.getID(locationName); attendance.setMonth(month); attendance.setYear(year); attendance.setLocationID(locationID); attendanceDB.selectID(attendance); return(attendance.getID()); }
public ActionResult FileUpload(HttpPostedFileBase file) { if (ModelState.IsValid) { if (file == null) { ModelState.AddModelError("File", "Please Upload Your file"); } else if (file.ContentLength > 0) { int MaxContentLength = 1024 * 1024 * 3; //3 MB string[] AllowedFileExtensions = new string[] { ".jpg", ".gif", ".png", ".pdf" }; if (!AllowedFileExtensions.Contains(file.FileName.Substring(file.FileName.LastIndexOf('.')))) { ModelState.AddModelError("File", "Please file of type: " + string.Join(", ", AllowedFileExtensions)); } else if (file.ContentLength > MaxContentLength) { ModelState.AddModelError("File", "Your file is too large, maximum allowed size is: " + MaxContentLength + " MB"); } else { using (AttendanceDB ucok = new AttendanceDB()) { var userId = User.Identity.GetUserId(); var fileName = Path.GetFileName(file.FileName); var pathdatabase = Path.Combine(("~/Content/Upload"), fileName); var path = Path.Combine(Server.MapPath("~/Content/Upload"), fileName); var fileSize = file.ContentLength; FileUpload jin = new FileUpload { FileName = fileName, FilePath = pathdatabase, UserId = userId }; ViewBag.Message = "File uploaded successfully"; ucok.FileUploads.Add(jin); ucok.SaveChanges(); file.SaveAs(path); ModelState.Clear(); } //TO:DO } } } return(View()); }
public bool checkIfLocationAttendanceSubmitted(int month, int year, string locationName) { locationControl = new LocationControl(); attendance = new Attendance(); attendanceDB = new AttendanceDB(); int locationID = locationControl.getID(locationName); attendance.setMonth(month); attendance.setYear(year); attendance.setLocationID(locationID); bool flag = attendanceDB.checkIfLocationAttendanceSubmitted(attendance); return(flag); }
public void fillDataGridViewLocationAttendance(DataGridView dataGridView, string locationName, int month, int year) { locationControl = new LocationControl(); attendance = new Attendance(); attendanceDB = new AttendanceDB(); int locationID = locationControl.getID(locationName); attendance.setLocationID(locationID); attendance.setMonth(month); attendance.setYear(year); SqlDataAdapter adapter = attendanceDB.fillDataGridViewLocationAttendance(attendance); DataTable dataTable = new DataTable(); adapter.Fill(dataTable); dataGridView.DataSource = dataTable; }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); #if DEBUG Database.SetInitializer(new AppplicationDBInitializer()); ApplicationDbContext db = new ApplicationDbContext(); db.Database.Initialize(true); Database.SetInitializer(new AttendDbInitializer()); AttendanceDB att_db = new AttendanceDB(); att_db.Database.Initialize(true); #endif GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); }
public AttendanceTrackerRepo(AttendanceDB context) { this.context = context; }
private void ListEmployee() { try { grdList.Visible = true; grdList.Rows.Clear(); AttendanceDB dbrecord = new AttendanceDB(); List <attendance> emplist = new List <attendance>(); List <attendance> empleavelist = new List <attendance>(); List <attendance> empbiolist = new List <attendance>(); List <attendance> empMRlist = new List <attendance>(); int opt = 0; empstatuslist = new List <attendance>(); if (Main.itemPriv[2]) { if (cmbfilterOffice.SelectedIndex != -1) { string officeid = ((Structures.ComboBoxItem)cmbfilterOffice.SelectedItem).HiddenValue; emplist = dbrecord.getEmployeeListforoffice(officeid).OrderBy(x => x.EmployeeName).ToList(); if (dtpdate.Value.Date <= UpdateTable.getSQLDateTime().Date) { empstatuslist = dbrecord.getEmployeestatusListforoffice(officeid, dtpdate.Value); if (empstatuslist.Count == 0) { empleavelist = dbrecord.getEmployeeLeaveList(dtpdate.Value); empbiolist = dbrecord.getEmployeeBiometricList(dtpdate.Value); empMRlist = dbrecord.getMrEmployeeList(dtpdate.Value); } } else if (dtpdate.Value.Date > UpdateTable.getSQLDateTime().Date) { pnlEditButtons.Visible = false; MessageBox.Show("Please select the date equal to or less than today!!!"); return; } } } else { emplist = dbrecord.getEmployeeList().OrderBy(x => x.EmployeeName).ToList(); empstatuslist = dbrecord.getEmployeestatusListforoffice(emplOfficeID, UpdateTable.getSQLDateTime()); if (empstatuslist.Count == 0) { empleavelist = dbrecord.getEmployeeLeaveList(UpdateTable.getSQLDateTime()); empbiolist = dbrecord.getEmployeeBiometricList(UpdateTable.getSQLDateTime()); empMRlist = dbrecord.getMrEmployeeList(UpdateTable.getSQLDateTime()); } } foreach (attendance elst in emplist) { grdList.Rows.Add(); int kount = grdList.RowCount; grdList.Rows[kount - 1].Cells["RowID"].Value = kount; grdList.Rows[kount - 1].Cells["EmployeeID"].Value = Convert.ToInt32(elst.EmployeeID); grdList.Rows[kount - 1].Cells["EmployeeName"].Value = elst.EmployeeName; DataGridViewComboBoxCell cmbAttendanceStatus = (DataGridViewComboBoxCell)(grdList.Rows[kount - 1].Cells["AttendanceStatus"]); CatalogueValueDB.fillCatalogValueGridViewComboNew(cmbAttendanceStatus, "AttendanceStatus"); attendance empstatlst = empstatuslist.FirstOrDefault(x => x.EmployeeID == elst.EmployeeID); if (empstatlst == null) { attendance emplvlst = empleavelist.FirstOrDefault(x => x.EmployeeID == elst.EmployeeID); attendance empbiolst = empbiolist.FirstOrDefault(x => x.EmployeeID == elst.EmployeeID); attendance empMRlst = empMRlist.FirstOrDefault(x => x.EmployeeID == elst.EmployeeID); if (emplvlst != null) { grdList.Rows[kount - 1].Cells["AttendanceStatus"].Value = "Leave"; Initval.Add(emplvlst.EmployeeID, "Leave"); changedval.Add(emplvlst.EmployeeID, "Leave"); } else { if (empbiolst != null) { grdList.Rows[kount - 1].Cells["AttendanceStatus"].Value = "Present"; Initval.Add(empbiolst.EmployeeID, "Present"); changedval.Add(empbiolst.EmployeeID, "Present"); } else if (empMRlst != null) { grdList.Rows[kount - 1].Cells["AttendanceStatus"].Value = "LocalTravel"; Initval.Add(empMRlst.EmployeeID, "LocalTravel"); changedval.Add(empMRlst.EmployeeID, "LocalTravel"); } } } else { grdList.Rows[kount - 1].Cells["AttendanceStatus"].Value = empstatlst.AttendenceStatus; Initval.Add(empstatlst.EmployeeID, empstatlst.AttendenceStatus); } } pnlEditButtons.Visible = false; if (!Main.itemPriv[2]) { if (grdList.RowCount > 0 && UpdateTable.getSQLDateTime().Hour < 13) { pnlEditButtons.Visible = true; } } else if (grdList.RowCount > 0) { pnlEditButtons.Visible = true; } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } enableBottomButtons(); pnlMenuList.Visible = true; }
public ModulesController() { _attendanceDb = new AttendanceDB(); }
private void ListFilteredLeave(int opt, string officeID) { try { DateTime dttemp = DateTime.Now; grdList.Rows.Clear(); grdList.Columns.Clear(); AttendanceDB Adb = new AttendanceDB(); OfficeDB dbrecord = new OfficeDB(); grdList.Columns.Add("OfficeID", "OfficeID"); grdList.Columns.Add("Office", "Office"); grdList.Columns["OfficeID"].Frozen = true; grdList.Columns["OfficeID"].Visible = false; grdList.Columns["Office"].Frozen = true; List <catalogue> statuslist = Adb.getCatalogues(); List <office> Offices = dbrecord.getOffices().Where(w => w.status == 1).ToList(); foreach (catalogue stat in statuslist) { grdList.Columns.Add(stat.catalogueID, stat.description); grdList.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //////grdList.Columns.cell = "Double click for details"; } grdList.Columns.Add("Total", "Total"); grdList.Columns["Total"].Width = 70; List <attendance> emptotlst = Adb.getEmployeeoffceList("Total", "Total"); foreach (office off in Offices) { if (off.RegionID.Equals("Overseas")) { continue; } grdList.Rows.Add(); grdList.Rows[grdList.Rows.Count - 1].Cells["OfficeID"].Value = off.OfficeID; grdList.Rows[grdList.Rows.Count - 1].Cells["Office"].Value = off.name; List <attendance> emplst = emptotlst.Where(x => x.officeID == off.OfficeID).ToList(); int colcount = 0; foreach (DataGridViewColumn cl in grdList.Columns) { if (cl.Name != "Office" && cl.Name != "OfficeID") { int emplstcount = emplst.Where(x => x.AttendenceStatus == cl.Name).Count(); grdList.Rows[grdList.Rows.Count - 1].Cells[cl.Name].Value = emplstcount; grdList.Rows[grdList.Rows.Count - 1].Cells[cl.Name].ToolTipText = "Double click for details"; colcount += Convert.ToInt32(grdList.Rows[grdList.Rows.Count - 1].Cells[cl.Name].Value); } } grdList.Rows[grdList.RowCount - 1].Cells["Total"].Value = colcount; grdList.Rows[grdList.RowCount - 1].Cells["Total"].ToolTipText = "Double click for details"; } grdList.Rows.Add(); grdList.Rows[grdList.Rows.Count - 1].Cells["OfficeID"].Value = "Total"; grdList.Rows[grdList.Rows.Count - 1].Cells["Office"].Value = "Total"; foreach (DataGridViewColumn dgc in grdList.Columns) { int rowcount = 0; foreach (DataGridViewRow dgr in grdList.Rows) { if (dgc.Name != "Office" && dgc.Name != "OfficeID") { rowcount += Convert.ToInt32(dgr.Cells[dgc.Name].Value); } } if (dgc.Name != "Office" && dgc.Name != "OfficeID") { grdList.Rows[grdList.RowCount - 1].Cells[dgc.Name].Value = rowcount; grdList.Rows[grdList.RowCount - 1].Cells[dgc.Name].ToolTipText = "Double click for details"; } } grdList.CurrentCell.Selected = false; grdList.Visible = true; pnlgrdList.Visible = true; } catch (Exception ex) { MessageBox.Show("Error 3 : ListFilteredLeave() - " + ex.ToString()); } }
public StudentsController() { _attendanceDb = new AttendanceDB(); }
private void ListFilteredAttendanceList(DateTime month, string officeID) { try { grdList.Rows.Clear(); grdList.Columns.Clear(); AttendanceDB Adb = new AttendanceDB(); List <DateTime> dates = GetDates(dtMonth.Value.Month, dtMonth.Value.Year); // get days for selected month and year List <attendance> AttStat = Adb.getEmployeeAttendanceList(month, officeID); if (AttStat.Count <= 0) { MessageBox.Show("No data to show"); return; } grdList.Columns.Add("Slno", "Slno"); grdList.Columns.Add("EmployeeID", "ID"); grdList.Columns.Add("EmployeeName", "Employee Name"); grdList.Columns.Add("Office", "Office"); grdList.Columns["Slno"].Frozen = true; grdList.Columns["EmployeeID"].Frozen = true; grdList.Columns["EmployeeName"].Frozen = true; grdList.Columns["Office"].Frozen = true; grdList.Columns["Slno"].Width = 30; grdList.Columns["EmployeeID"].Width = 50; foreach (DateTime dt in dates) { //if (dt.Date < DateTime.Now) //{ grdList.Columns.Add(dt.Date.ToString("yyyy-MM-dd"), dt.Date.ToString("dd")); grdList.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; grdList.Columns[dt.Date.ToString("yyyy-MM-dd")].Width = 25; //} } var emplst = AttStat.GroupBy(G => G.EmployeeID).Select(A => new { EmployeeID = A.Key, EmployeeName = A.First().EmployeeName, officeName = A.First().officeName }); foreach (var att in emplst) { grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["Slno"].Value = grdList.RowCount; grdList.Rows[grdList.RowCount - 1].Cells["EmployeeID"].Value = Convert.ToInt32(att.EmployeeID); grdList.Rows[grdList.RowCount - 1].Cells["EmployeeName"].Value = att.EmployeeName; grdList.Rows[grdList.RowCount - 1].Cells["Office"].Value = att.officeName; foreach (DataGridViewColumn dgvc in grdList.Columns) { List <attendance> lst = AttStat.Where(x => x.EmployeeID == att.EmployeeID).ToList(); foreach (attendance lt in lst) { if (dgvc.Name == lt.StatusDate.ToString("yyyy-MM-dd")) { grdList.Rows[grdList.RowCount - 1].Cells[dgvc.Name].Value = getAtstatus(lt.AttendenceStatus); } } } } if (grdList.Rows.Count != 0 && Main.itemPriv[1] == true && (Main.itemPriv[2] == true || Main.itemPriv[3] == true)) { btnExportToExcel.Visible = true; } else { btnExportToExcel.Visible = false; } grdList.Visible = true; pnlgrdList.Visible = true; } catch (Exception ex) { MessageBox.Show("Error 3 : ListFilteredAttendanceListLeave() - " + ex.ToString()); } }