//Movement Detail Showing on Dashboard private void ShowMovementRegisterList() { try { grdMovementReg.Rows.Clear(); MovementRegisterDB mrdb = new MovementRegisterDB(); List <movementregister> MRList = mrdb.getMovementRegForDashboard(); foreach (movementregister mr in MRList) { grdMovementReg.Rows.Add(); grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["Sno"].Value = grdMovementReg.RowCount; grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["moveDate"].Value = mr.CreateTime; grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["From"].Value = mr.EmployeeName; grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["Purpose"].Value = mr.Purpose; grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["PlannedExitTime"].Value = mr.ExitTimePlanned; grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["PlannedReturnTime"].Value = mr.ReturnTimePlanned; grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["Status"].Value = getMovementStatus(mr.Status, mr.DocumentStatus); grdMovementReg.Rows[grdMovementReg.RowCount - 1].Cells["DocumentStatus"].Value = mr.DocumentStatus; } if (grdMovementReg.Rows.Count > 0) { pnlMovementReg.Visible = true; } else { pnlMovementReg.Visible = false; } } catch (Exception ex) { MessageBox.Show("Error in showing MOvementRegList"); } }
private void ListFilteredmovementhistory() { try { grdList.Rows.Clear(); MovementHistoryDB mhdb = new MovementHistoryDB(); List <movementhistory> MHList = new List <movementhistory>(); Dictionary <String, String> dict = new Dictionary <string, string>(); string selEmp = ""; if (txtEmpID.Text.Trim().Length != 0) { selEmp = txtEmpID.Text.Substring(0, txtEmpID.Text.IndexOf('-')); } string selPurpose = ""; if (cmbPurpose.SelectedIndex != -1) { selPurpose = ((Structures.ComboBoxItem)cmbPurpose.SelectedItem).HiddenValue; } if (txtEmpID.Text.Trim().Length != 0) { dict.Add("EmpId", selEmp); } else { dict.Add("EmpId", ""); } if (cmbPurpose.SelectedIndex != -1) { dict.Add("Purpose", selPurpose); } else { dict.Add("Purpose", ""); } if (cmbDocStatus.SelectedIndex != -1) { if (cmbDocStatus.SelectedItem.ToString() == "Canceled") { dict.Add("DocStat", "6,1,98"); } else { dict.Add("DocStat", getStatus(cmbDocStatus.SelectedItem.ToString()).ToString()); } } else { dict.Add("DocStat", ""); } if (cmbDocStatus.SelectedIndex != -1) { if (cmbDocStatus.SelectedItem.ToString().Equals("All")) { if (txtEmpID.Text.Length != 0 && cmbPurpose.SelectedIndex != -1) { MHList = mhdb.getMovementHistoryForAll(dtFromDate.Value, dtToDate.Value, selEmp, selPurpose); } else if (txtEmpID.Text.Length != 0) { MHList = mhdb.getMovementHistoryForAll(dtFromDate.Value, dtToDate.Value, selEmp, ""); } else if (cmbPurpose.SelectedIndex != -1) { MHList = mhdb.getMovementHistoryForAll(dtFromDate.Value, dtToDate.Value, "", selPurpose); } else { MHList = mhdb.getMovementHistoryForAll(dtFromDate.Value, dtToDate.Value, "", ""); } } else { MHList = mhdb.getFilteredMovementHistory(dtFromDate.Value, dtToDate.Value, getOPtion(), dict); } } else { MHList = mhdb.getFilteredMovementHistory(dtFromDate.Value, dtToDate.Value, getOPtion(), dict); } //grdList.Columns["dt"].Visible = true; foreach (movementhistory mh in MHList) { if (cmbDocStatus.SelectedIndex != 2 && cmbDocStatus.SelectedIndex != 0 && mh.documentstatus == 1 && mh.status == 1) { continue; } grdList.Rows.Add(); //grdList.Rows[grdList.RowCount - 1].Cells["mRowID"].Value = mh.rowid; grdList.Rows[grdList.RowCount - 1].Cells["mDate"].Value = mh.date; grdList.Rows[grdList.RowCount - 1].Cells["mEmployee"].Value = mh.empname; grdList.Rows[grdList.RowCount - 1].Cells["mPurpose"].Value = mh.purpose; grdList.Rows[grdList.RowCount - 1].Cells["mExitTime"].Value = mh.exittime; grdList.Rows[grdList.RowCount - 1].Cells["mReturnTime"].Value = mh.returntime; grdList.Rows[grdList.RowCount - 1].Cells["aExitTime"].Value = mh.actexittime; grdList.Rows[grdList.RowCount - 1].Cells["aReturnTime"].Value = mh.actreturntime; grdList.Rows[grdList.RowCount - 1].Cells["MovementStatus"].Value = MovementRegisterDB.valuetostring(mh.documentstatus, mh.status); } if (grdList.Rows.Count != 0) { btnExportToExcell.Visible = true; } else { btnExportToExcell.Visible = false; } } catch (Exception ex) { MessageBox.Show("Error in Movement History Listing"); } setButtonVisibility("init"); pnlList.Visible = true; }