public DataTable GetEmpInfo()
{
// string query = " select AmtTotalSales as TOTAL_SUBWAY_SALES, QtyFootlongs as FOOT_LONG, Qty6Inches as INCH_6, Qty3Inches INCH_3, QtyMuffinMelt as MUFF_IN_MELT , QtySalads as SALAD ,QtyPizzas as PIZZA , AmtCateringSales as CATERING , AmtTotalRefund as REFUNDS , AmtSubwayVoid as VOIDS, AmtUnitSales as TOTAL_UNIT_SALES , AmtDrinkSales as TOTAL_DRINK_SALES from Report.DrawersSummary where OpeningInformationId in (select OpeningInformationId from dbo.OpeningInformation where BusinessDate between '" + weekDate.ToString("yyyy/MM/dd") + "' and '" + nextDate.ToString("yyyy/MM/dd") + "' )";
DataTable drawersSummaryTable = null;
try
{
string query = "select emp.FirstName , emp.MiddleName, emp.LastName"
+ ", uc.ClockingTime,uc.MinutesWorked, uc.InsertedDate from dbo.UserClocking uc, dbo.Employees emp where emp.EmployeeId = uc.EmployeeId";
DataBaseUtility db = new DataBaseUtility();
drawersSummaryTable = db.FetchData(query);
}
catch (Exception ex)
{
log.Error(" Exception in GetEmpInfo Method ", ex);
}
return drawersSummaryTable;
}
public DataTable GetUserList()
{
DataBaseUtility db = new DataBaseUtility();
string query = " select Id,UserId,Password from dbo.Users ";
DataTable ds = db.FetchData(query);
return ds;
}