public void LoadGatePassDataGrid(bool onFormLoad)
{
PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** : " + GlobalVariables.ProgCode);
try
{
gridView_AttendanceData.Columns.Clear();
string _params = "'" + txtEmpCode.EditValue + "', '" + ConvertTo.DateTimeVal(DtStartDate.EditValue).ToString("yyyy-MM-dd") + "'";
DataSet ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params);
if (ds.Tables[0].Rows.Count > 0)
{
gridControl_AttendanceData.DataSource = ds.Tables[0];
gridView_AttendanceData.BestFitColumns();
}
else
{
gridControl_AttendanceData.DataSource = null;
if (!onFormLoad)
{
ProjectFunctions.SpeakError("There is no data in this Query");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString().Trim());
}
}
private void Report_Print_Preview(string action)
{
XtraReport_EmployeeAttendance Xtra_Report_EmployeeAttendanceList = new XtraReport_EmployeeAttendance();
DynamicParameters paramSalary = new DynamicParameters();
paramSalary.Add("@Emp_Code_Processing", txtEmpCode.EditValue);
paramSalary.Add("@Salary_Month", DtStartDate.EditValue);
paramSalary.Add("@Deduct_Advance", 1);
paramSalary.Add("@Deduct_Loan", 1);
paramSalary.Add("@TeaRate", 0);
paramSalary.Add("@NoOfCups", 0);
DynamicParameters param = new DynamicParameters();
param.Add("@EmpCode", txtEmpCode.EditValue);
param.Add("@Attendance_Month", DtStartDate.EditValue);
DynamicParameters paramEmp = new DynamicParameters();
paramEmp.Add("@EmpCode", txtEmpCode.EditValue);
ProgramMasterModel programMaster = ProgramMasterData.GetProgramMasterModel(GlobalVariables.ProgCode);
EmployeeAttendanceDetails_Model employeeAttendanceDetails_Model = new EmployeeAttendanceDetails_Model
{
EmpCode = txtEmpCode.EditValue + string.Empty,
AttendanceMonth = ConvertTo.DateTimeVal(DtStartDate.EditValue),
EmployeeAttendance_Get_List = EmployeeData.EmployeeAttendance_Get(programMaster.ProgProcName + "_v2", param),
EmployeesSalaryList = EmployeeData.GetEmployeesSalaryList("sp_Salary_Process", paramSalary),
EmployeeMasterDataList = EmployeeData.GetEmployeeMasterDataList("sp_LoadEmpMstFEditing", paramEmp)
};
//EmployeeMasterModel
attendanceBindingSource.DataSource = employeeAttendanceDetails_Model;
Xtra_Report_EmployeeAttendanceList.DataSource = attendanceBindingSource;
//MessageBox.Show(employeeAttendanceDetails_Model.EmployeesSalaryList.Count + "");
ReportPrintTool tool = new ReportPrintTool(Xtra_Report_EmployeeAttendanceList);
if (action.Equals("preview"))
{
tool.ShowRibbonPreviewDialog();
}
if (action.Equals("print"))
{
tool.PrintDialog();
}
}
public void LoadGatePassDataGrid_Obsoulete()
{
PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** " + GlobalVariables.ProgCode);
gridView_AttendanceData.Columns.Clear();
string _params = "'" + txtEmpCode.EditValue + "', '" + ConvertTo.DateTimeVal(DtStartDate.EditValue).ToString("yyyy-MM-dd") + "'";
DataSet att_ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params);
if (ComparisonUtils.IsNotNull_DataSet(att_ds))
{
gridControl_AttendanceData.DataSource = att_ds;
}
}
public void LoadAttendanceDataGrid()
{
//ProgramMasterModel programMaster = ProgramMasterData.GetProgramMasterModel(GlobalVariables.ProgCode);
//DataSet ds = ProjectFunctions.GetDataSet("Select ProgProcName,ProgDesc from ProgramMaster Where ProgCode='" + GlobalVariables.ProgCode + "'");
//string ProcedureName = ds.Tables[0].Rows[0]["ProgProcName"].ToString();
PrintLogWin.PrintLog("LoadAttendanceDataGrid => GlobalVariables.ProgCode ******************** " + GlobalVariables.ProgCode);
//PrintLogWin.PrintLog("LoadAttendanceDataGrid => ProcedureName Dapper ******************** " + programMaster.ProgProcName);
//PrintLogWin.PrintLog("LoadAttendanceDataGrid => ProcedureName B ******************** " + ProcedureName);
//List<AttendanceModel> att = ProgramMasterData.GetData<AttendanceModel>(GlobalVariables.ProgCode);
//PrintLogWin.PrintLog("LoadAttendanceDataGrid => att ******************** " + att.Count);
gridView_AttendanceData.Columns.Clear();
string _params = "'" + txtEmpCode.EditValue + "', '" + ConvertTo.DateTimeVal(DtStartDate.EditValue).ToString("yyyy-MM-dd") + "'";
DataSet att_ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params, "_v2");
if (ComparisonUtils.IsNotNull_DataSet(att_ds))
{
BindingList <object> binding_list = new BindingList <object>();
foreach (DataRow dr in att_ds.Tables[0].Rows)
{
var employeeAttendance = new
{
SerialId = dr[Col.EmployeeAttendance.serial_id],
//EntryDate = dr[Col.EmployeeAttendance.entry_date],
AttendanceDate = ConvertTo.DateFormatApp(dr[Col.EmployeeAttendance.attendance_date]),
EmployeeCode = dr[Col.EmployeeAttendance.employee_code],
//Shift = dr[Col.DailyShifts.shift_name],
Status = dr[Col.AttendanceStatus.status],
TimeIn_First = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_in_first]),
TimeOut_First = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_out_first]),
TimeIn_Last = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_in_last]),
TimeOut_Last = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_out_last]),
WorkingHours = dr[Col.EmployeeAttendance.working_hours],
OverTime = dr[Col.EmployeeAttendance.ot_deducton_time],
OverTime_1 = ConvertTo.IntVal(dr[Col.EmployeeAttendance.ot_deducton_time_1]),
GatePassTime = dr[Col.EmployeeAttendance.gate_pass_time],
Source = dr[Col.AttendanceSource.source_name],
RowStyle = dr[Col.GridStyle.Row_Style]
};
//ConvertTo.DateTimeVal(dr[Col.EmployeeAttendance.attendance_in_first]).ToString("hh:mm tt")
binding_list.Add(employeeAttendance);
}
gridControl_AttendanceData.DataSource = binding_list;
if (gridView_AttendanceData.Columns["SerialId"] != null)
{
gridView_AttendanceData.Columns["SerialId"].Visible = false;
}
if (gridView_AttendanceData.Columns["EmployeeCode"] != null)
{
gridView_AttendanceData.Columns["EmployeeCode"].Visible = false;
}
if (gridView_AttendanceData.Columns["RowStyle"] != null)
{
gridView_AttendanceData.Columns["RowStyle"].Visible = false;
}
if (gridView_AttendanceData.Columns["OverTime_1"] != null)
{
gridView_AttendanceData.Columns["OverTime_1"].Visible = false;
}
if (binding_list.Count > 0)
{
//GridColumnSummaryItem item1 = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "GatePassTime", "MAX GatePassTime={0}");
//GridColumnSummaryItem item2 = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Min, "GatePassTime", "MIN GatePassTime={0}");
//gridView_AttendanceData.Columns["GatePassTime"].Summary.Add(item1);
//gridView_AttendanceData.Columns["GatePassTime"].Summary.Add(item2);
//gridView_AttendanceData.Columns["WorkingHours"].Summary.Add(DevExpress.Data.SummaryItemType.Average, "WorkingHours", "Avg={0:n2}");
//gridView_AttendanceData.Columns["WorkingHours"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "WorkingHours", "Sum={0}");
//GridColumnSummaryItem item = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "WorkingHours", "Max={0}");
//gridView_AttendanceData.Columns["WorkingHours"].Summary.Add(item);
//gridView_AttendanceData.Columns["OverTime"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "OverTime_1", "Total OverTime={0}",);
/*
* GridColumnSummaryItem item = new GridColumnSummaryItem();
* item.SummaryType = DevExpress.Data.SummaryItemType.Custom;
*
* item.Tag = "OverTime_Summary";
* gridView_AttendanceData.Columns["OverTime"].Summary.Add(item);
*/
//item = new GridColumnSummaryItem();
//item.SummaryType = DevExpress.Data.SummaryItemType.Custom;
//item.Tag = "2";
//gridView_AttendanceData.Columns["OverTime"].Summary.Add(item);
gridView_AttendanceData.Columns["OverTime_1"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "OverTime_1", string.Empty);
gridView_AttendanceData.Columns["OverTime"].Summary.Add(DevExpress.Data.SummaryItemType.Custom);
gridView_AttendanceData.UpdateTotalSummary();
}
}
}
