public static SqlDataReader GetEmployeeById(int employeeId)
{
StoredProcedureParameterList.Clear();
StoredProcedureName = ConfigurationManager.AppSettings.Get("GetEmployeeByIDSP");
StoredProcedureParameterList.Add(new SqlParameter("@EmployeeID", employeeId));
return(DBInteraction.ExecuteSelect(StoredProcedureName, StoredProcedureParameterList));
}
public static SqlDataReader GetCustomerBillHistory(int customerMobileNumber)
{
StoredProcedureParameterList.Clear();
StoredProcedureName = ConfigurationManager.AppSettings.Get("GetCustomerBillHistorySP");
StoredProcedureParameterList.Add(new SqlParameter("@customerMobileNumer", customerMobileNumber));
return(DBInteraction.ExecuteSelect(StoredProcedureName, StoredProcedureParameterList));
}
public static SqlDataReader GetAllEmployees()
{
StoredProcedureParameterList.Clear();
StoredProcedureName = ConfigurationManager.AppSettings.Get("GetAllEmployeesSP");
return(DBInteraction.ExecuteSelect(StoredProcedureName, StoredProcedureParameterList));
}