public List <EmployeeDTO> SelectEmployee()
{
List <EmployeeDTO> emp = new List <EmployeeDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectEmployee");
cmd.CommandType = CommandType.StoredProcedure;
emp = dblayer.GetEntityList <EmployeeDTO>(cmd);
}
return(emp);
}
public List <ClassName> ClassName()
{
List <ClassName> ClassName = new List <ClassName>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_ClassName");
cmd.CommandType = CommandType.StoredProcedure;
ClassName = dblayer.GetEntityList <ClassName>(cmd);
}
return(ClassName);
}
public List <SectionDTO> SelectSection()
{
List <SectionDTO> sectiondto = new List <SectionDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectSection");
cmd.CommandType = CommandType.StoredProcedure;
sectiondto = dblayer.GetEntityList <SectionDTO>(cmd);
}
return(sectiondto);
}
public List <StaffAllocationDTO> SelectStaffAllocationt()
{
List <StaffAllocationDTO> sad = new List <StaffAllocationDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectStaff");
cmd.CommandType = CommandType.StoredProcedure;
sad = dblayer.GetEntityList <StaffAllocationDTO>(cmd);
}
return(sad);
}
public List <RoleName> RoleName()
{
List <RoleName> r = new List <RoleName>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_RoleName");
cmd.CommandType = CommandType.StoredProcedure;
r = dblayer.GetEntityList <RoleName>(cmd);
}
return(r);
}
public List <DepartmentName> SelectDepartmentName()
{
List <DepartmentName> deptName = new List <DepartmentName>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_DepartmentName");
cmd.CommandType = CommandType.StoredProcedure;
deptName = dblayer.GetEntityList <DepartmentName>(cmd);
}
return(deptName);
}
public List <Hod_AllocationDTO> SelectHod_Allocation()
{
List <Hod_AllocationDTO> hoda = new List <Hod_AllocationDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectHod_Allocation");
cmd.CommandType = CommandType.StoredProcedure;
hoda = dblayer.GetEntityList <Hod_AllocationDTO>(cmd);
}
return(hoda);
}
public List <College1DTO> SelectCollegeName()
{
List <College1DTO> clg1 = new List <College1DTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectCollegeName");
cmd.CommandType = CommandType.StoredProcedure;
clg1 = dblayer.GetEntityList <College1DTO>(cmd);
}
return(clg1);
}
public List <UploadFileDTO> SelectUploadFile()
{
List <UploadFileDTO> up = new List <UploadFileDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectUploadFile");
cmd.CommandType = CommandType.StoredProcedure;
up = dblayer.GetEntityList <UploadFileDTO>(cmd);
}
return(up);
}
public List <SectionName> SectionName()
{
List <SectionName> dept = new List <SectionName>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SectionName");
cmd.CommandType = CommandType.StoredProcedure;
dept = dblayer.GetEntityList <SectionName>(cmd);
}
return(dept);
}
public List <DepartmentDTO> SelectDepartment()
{
List <DepartmentDTO> dept = new List <DepartmentDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectDepartment");
cmd.CommandType = CommandType.StoredProcedure;
dept = dblayer.GetEntityList <DepartmentDTO>(cmd);
}
return(dept);
}
public List <UniverSityMaster> SelectUniverSity()
{
List <UniverSityMaster> uni = new List <UniverSityMaster>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectUniverSity");
cmd.CommandType = CommandType.StoredProcedure;
uni = dblayer.GetEntityList <UniverSityMaster>(cmd);
}
return(uni);
}
public List <EventDetailsDTO> SelectEvent()
{
List <EventDetailsDTO> even = new List <EventDetailsDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectEvent");
cmd.CommandType = CommandType.StoredProcedure;
even = dblayer.GetEntityList <EventDetailsDTO>(cmd);
}
return(even);
}
public List <CountryMaster> SelectCountry()
{
List <CountryMaster> Country = new List <CountryMaster>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectCountry");
cmd.CommandType = CommandType.StoredProcedure;
Country = dblayer.GetEntityList <CountryMaster>(cmd);
}
return(Country);
}
public List <StateMaster> SelectState()
{
List <StateMaster> state = new List <StateMaster>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectState");
cmd.CommandType = CommandType.StoredProcedure;
state = dblayer.GetEntityList <StateMaster>(cmd);
}
return(state);
}
public List <Employee> Employee()
{
List <Employee> Employee = new List <Employee>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_Employee");
cmd.CommandType = CommandType.StoredProcedure;
Employee = dblayer.GetEntityList <Employee>(cmd);
}
return(Employee);
}
public List <ClassDTO> SelectClass()
{
List <ClassDTO> cls = new List <ClassDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectClass");
cmd.CommandType = CommandType.StoredProcedure;
cls = dblayer.GetEntityList <ClassDTO>(cmd);
}
return(cls);
}
public List <HODApprovalDTO> SelectHODApproval(SelectHODApprovalProcDTO obj)
{
List <HODApprovalDTO> hod = new List <HODApprovalDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectHODApproval");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p_EventId", obj.EventId);
cmd.Parameters.AddWithValue("@p_StudentId", obj.StudentId);
hod = dblayer.GetEntityList <HODApprovalDTO>(cmd);
}
return(hod);
}
public List <SelectCommonT_LoginDTO> SelectCommonT_Login(SelectCommonT_LoginProcDTO obj)
{
List <SelectCommonT_LoginDTO> commont_logindto = new List <SelectCommonT_LoginDTO>();
using (DBlayer dblayer = new DBlayer())
{
SqlCommand cmd = new SqlCommand("sp_SelectCommonT_Login");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p_UserName", obj.UserName);
cmd.Parameters.AddWithValue("@p_PassWord", obj.PassWord);
commont_logindto = dblayer.GetEntityList <SelectCommonT_LoginDTO>(cmd);
}
return(commont_logindto);
}