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; }