public object GetClassTimeTables(string id)
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [dbo].[Teacher_Schedule] N'{0}'", id);
var lst = dao.GetDataTable(sql);
return(lst);
}
public object GetClassStudentDetail(string id)
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [usp_ClassStudentDetail] N'{0}'", id);
var lst = dao.GetDataTable(sql);
return(lst);
}
public object ReportInvoice(string startDate, string endDate)
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [Report_Invoice] N'{0}', N'{1}'", startDate, endDate);
var lst = dao.GetDataTable(sql);
return(lst);
}
public object Search(string info)
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [Customer_Search] N'{0}'", info);
var lst = dao.GetDataTable(sql);
return(lst);
}
public object ReportInvoice()
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [Report_Invoice]");
var lst = dao.GetDataTable(sql);
return(lst);
}
public object GetStatusClass()
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [dbo].[StatusClass_Chart]");
var lst = dao.GetDataTable(sql);
return(lst);
}
public object GetSearchClassTimeTables(string id, string StartDate, string EndDate)
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [dbo].[Teacher_Schedule] N'{0}', N'{1}', N'{2}'", id, StartDate, EndDate);
var lst = dao.GetDataTable(sql);
return(lst);
}
//
// GET: /Teacher/
//public object GetList()
//{
// BaseDAO dao = new BaseDAO();
// var lst = dao.Model.Teachers.Where(f => f.IsDelete == false).ToList();
// return lst;
//}
public object SearchTeacher(string info, string BranchID)
{
BaseDAO dao = new BaseDAO();
string sql = string.Format("exec [dbo].[Teacher_Search] N'{0}', N'{1}'", info, BranchID);
var lst = dao.GetDataTable(sql);
return(lst);
}
