public static List <string> getMasterSchedule(string TimeSelected, string Subjects, string Gender)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[4];
PM[0] = new SqlParameter("@FranchiseId", SqlDbType.BigInt);
PM[0].Value = HttpContext.Current.Session["FranchiseID"].ToString();
PM[1] = new SqlParameter("@TimeSelected", SqlDbType.VarChar);
PM[1].Value = TimeSelected;
PM[2] = new SqlParameter("@Subjects", SqlDbType.VarChar);
PM[2].Value = Subjects;
PM[3] = new SqlParameter("@Gender", SqlDbType.VarChar);
PM[3].Value = Gender;
dsResult = gf.Filldatasetvalue(PM, "USP_getMasterSchedule", dsResult, null);
string tblResults = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblResults);
return(obj_list);
}
public static List <string> GetEnrolementView_ById(Int64 Id)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@Inqueryid", SqlDbType.BigInt);
PM[0].Value = Id;
PM[1] = new SqlParameter("@FranchiseID", SqlDbType.VarChar);
PM[1].Value = HttpContext.Current.Session["FranchiseID"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_GetEnrolementView", dsResult, null);
string tblInquiry = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string tblInquiryStudents = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
string tblAssessments = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[2]);
string tblMeetings = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[3]);
string tblTutorTimeSlots = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[4]);
string tblTutor = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[5]);
string tblSubjects = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[6]);
string tblSource = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[7]);
string tblGrade = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[8]);
string tblCalllogs = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[9]);
string tblTime = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[10]);
string tblPaymentMethods = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[11]);
string tblPlanType = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[12]);
List <string> obj_list = new List <string>();
obj_list.Add(tblInquiry);
obj_list.Add(tblInquiryStudents);
obj_list.Add(tblAssessments);
obj_list.Add(tblMeetings);
obj_list.Add(tblTutorTimeSlots);
obj_list.Add(tblTutor);
obj_list.Add(tblSubjects);
obj_list.Add(tblSource);
obj_list.Add(tblGrade);
obj_list.Add(tblCalllogs);
obj_list.Add(tblTime);
obj_list.Add(tblPaymentMethods);
obj_list.Add(tblPlanType);
return(obj_list);
}
public static List <string> GetTutorTimeSlots(string Day_time)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@Day_time", SqlDbType.VarChar);
PM[0].Value = Day_time;
dsResult = gf.Filldatasetvalue(PM, "USP_GetTutorTimeSlots", dsResult, null);
string tblTutorTimeSlots = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblTutorTimeSlots);
return(obj_list);
}
public static List <string> SaveSignature(String InqiryId, String Sinature)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@InqiryId", SqlDbType.VarChar);
PM[0].Value = InqiryId;
PM[1] = new SqlParameter("@Sinature", SqlDbType.VarChar);
PM[1].Value = Sinature;
dsResult = gf.Filldatasetvalue(PM, "UPS_SaveSignature", dsResult, null);
string tblMessage = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> Complete_Inquiry_Assessment_Meeting(Int64 DeleteId, Int64 InquiryId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@DeleteId", SqlDbType.BigInt);
PM[0].Value = DeleteId;
PM[1] = new SqlParameter("@InquiryId", SqlDbType.BigInt);
PM[1].Value = InquiryId;
dsResult = gf.Filldatasetvalue(PM, "USP_Complete_Inquiry_Assessment_Meeting", dsResult, null);
string tblResults = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblResults);
return(obj_list);
}
public static List <string> updateAssessment(int Id, int Value)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@Id", SqlDbType.BigInt);
PM[0].Value = Id;
PM[1] = new SqlParameter("@Value", SqlDbType.BigInt);
PM[1].Value = Value;
dsResult = gf.Filldatasetvalue(PM, "usp_updateAssessment", dsResult, null);
string tblMessage = Enrollment_Inquiry.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}