public static List <string> UpdateStudentInlineH(
string BalanceHours, string TokenBalance, string StudyHall_Hrs,
string StudentId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[4];
PM[0] = new SqlParameter("@BalanceHours", SqlDbType.VarChar);
PM[0].Value = BalanceHours;
PM[1] = new SqlParameter("@TokenBalance", SqlDbType.VarChar);
PM[1].Value = TokenBalance;
PM[2] = new SqlParameter("@StudentId", SqlDbType.VarChar);
PM[2].Value = StudentId;
PM[3] = new SqlParameter("@HallHrs", SqlDbType.VarChar);
PM[3].Value = StudyHall_Hrs;
dsResult = gf.Filldatasetvalue(PM, "USP_UpdateStudentInline", dsResult, null);
string tblMessage = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> SaveFeedback(string SessionId, string CoverdstudentMaterials, string CoverdstudentMaterials_Text,
string Studentattitude, string Studentattitude_Text, string OtherFeedback)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[7];
PM[0] = new SqlParameter("@SessionId", SqlDbType.VarChar);
PM[0].Value = SessionId;
PM[1] = new SqlParameter("@CoverdstudentMaterials", SqlDbType.VarChar);
PM[1].Value = CoverdstudentMaterials;
PM[2] = new SqlParameter("@CoverdstudentMaterials_Text", SqlDbType.VarChar);
PM[2].Value = CoverdstudentMaterials_Text;
PM[3] = new SqlParameter("@Studentattitude", SqlDbType.VarChar);
PM[3].Value = Studentattitude;
PM[4] = new SqlParameter("@Studentattitude_Text", SqlDbType.VarChar);
PM[4].Value = Studentattitude_Text;
PM[5] = new SqlParameter("@OtherFeedback", SqlDbType.VarChar);
PM[5].Value = OtherFeedback;
PM[6] = new SqlParameter("@TutorId", SqlDbType.VarChar);
PM[6].Value = HttpContext.Current.Session["Id"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_SaveFeedback", dsResult, null);
string tblMessage = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> LogNote(string Type, string Priority, string Date, string StudentId, string Notes)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[6];
PM[0] = new SqlParameter("@Type", SqlDbType.VarChar);
PM[0].Value = Type;
PM[1] = new SqlParameter("@Priority", SqlDbType.VarChar);
PM[1].Value = Priority;
PM[2] = new SqlParameter("@Date", SqlDbType.VarChar);
PM[2].Value = Date;
PM[3] = new SqlParameter("@StudentId", SqlDbType.VarChar);
PM[3].Value = StudentId;
PM[4] = new SqlParameter("@Notes", SqlDbType.VarChar);
PM[4].Value = Notes;
PM[5] = new SqlParameter("@Author", SqlDbType.VarChar);
PM[5].Value = HttpContext.Current.Session["User"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_LogNote", dsResult, null);
string tblMessage = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> StudentDetails(string StudentId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@StudentId", SqlDbType.BigInt);
PM[0].Value = StudentId;
dsResult = gf.Filldatasetvalue(PM, "USP_StudentDetails", dsResult, null);
string tblStudent = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string tblNotes = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
string tblFiles = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[2]);
string tblInvoice = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[3]);
string tblSubjects = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[4]);
string tblGrade = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[5]);
List <string> obj_list = new List <string>();
obj_list.Add(tblStudent);
obj_list.Add(tblNotes);
obj_list.Add(tblFiles);
obj_list.Add(tblInvoice);
obj_list.Add(tblSubjects);
obj_list.Add(tblGrade);
return(obj_list);
}
public static List <string> UpdateStudentDetails(string Name,
string Grade, string Subject, string School,
string BalanceHours, string TokenBalance,
string ContactEmail, string ContactPhone,
string ContactName, string StudentId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[10];
PM[0] = new SqlParameter("@Name", SqlDbType.VarChar);
PM[0].Value = Name;
PM[1] = new SqlParameter("@Grade", SqlDbType.VarChar);
PM[1].Value = Grade;
PM[2] = new SqlParameter("@Subject", SqlDbType.VarChar);
PM[2].Value = Subject;
PM[3] = new SqlParameter("@School", SqlDbType.VarChar);
PM[3].Value = School;
PM[4] = new SqlParameter("@BalanceHours", SqlDbType.VarChar);
PM[4].Value = BalanceHours;
PM[5] = new SqlParameter("@TokenBalance", SqlDbType.VarChar);
PM[5].Value = TokenBalance;
PM[6] = new SqlParameter("@ContactEmail", SqlDbType.VarChar);
PM[6].Value = ContactEmail;
PM[7] = new SqlParameter("@ContactPhone", SqlDbType.VarChar);
PM[7].Value = ContactPhone;
PM[8] = new SqlParameter("@ContactName", SqlDbType.VarChar);
PM[8].Value = ContactName;
PM[9] = new SqlParameter("@StudentId", SqlDbType.VarChar);
PM[9].Value = StudentId;
dsResult = gf.Filldatasetvalue(PM, "USP_UpdateStudentDetails", dsResult, null);
string tblMessage = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> ArchiveStudent(string ID)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[6];
PM[0] = new SqlParameter("@StudentId", SqlDbType.VarChar);
PM[0].Value = ID;
dsResult = gf.Filldatasetvalue(PM, "USP_ArchiveStudent", dsResult, null);
string tblMessage = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> GETFeedBack(string SessionId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@SessionId", SqlDbType.VarChar);
PM[0].Value = SessionId;
dsResult = gf.Filldatasetvalue(PM, "USP_GETFeedBack", dsResult, null);
string tblFeedback = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblFeedback);
return(obj_list);
}
public static List <string> StudentSessions(string StudentId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@StudentId", SqlDbType.BigInt);
PM[0].Value = StudentId;
dsResult = gf.Filldatasetvalue(PM, "USP_StudentSessions", dsResult, null);
string SessionList = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string PSessionList = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
List <string> obj_list = new List <string>();
obj_list.Add(SessionList);
obj_list.Add(PSessionList);
return(obj_list);
}
public static List <string> SessionScheduling_Chart(string Year, string StudentId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@Year", SqlDbType.BigInt);
PM[0].Value = Year;
PM[1] = new SqlParameter("@StudentId", SqlDbType.BigInt);
PM[1].Value = StudentId;
dsResult = gf.Filldatasetvalue(PM, "USP_SessionScheduling_Chart", dsResult, null);
string data = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string Years = Manage_StudentDetails.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
List <string> obj_list = new List <string>();
obj_list.Add(data);
obj_list.Add(Years);
return(obj_list);
}
