protected void btnFileUpload_Click(object sender, EventArgs e)
{
try
{
string FileName = txtFilename.Text.ToString();
String FilePath = MapPath("") + "/file/" + DateTime.Now.Year.ToString() + "_" + DateTime.Now.Month.ToString() + "_" + DateTime.Now.Day.ToString() + "_" + UploadFile.PostedFile.FileName.Replace(" ", "");
UploadFile.PostedFile.SaveAs(FilePath);
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[5];
PM[0] = new SqlParameter("@Filename", SqlDbType.VarChar);
PM[0].Value = FileName;
PM[1] = new SqlParameter("@StudentId", SqlDbType.VarChar);
PM[1].Value = Request["StudentId"].ToString();
PM[2] = new SqlParameter("@filepath ", SqlDbType.VarChar);
PM[2].Value = FilePath;
PM[3] = new SqlParameter("@FileTitle", SqlDbType.VarChar);
PM[3].Value = FileName;
PM[4] = new SqlParameter("@Author", SqlDbType.VarChar);
PM[4].Value = Session["User"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_Uploadfiles", dsResult, null);
txtFilename.Text = "";
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
}
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> SaveMessage(string To, string From, string Message)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[6];
PM[0] = new SqlParameter("@To", SqlDbType.VarChar);
PM[0].Value = To;
PM[1] = new SqlParameter("@From", SqlDbType.VarChar);
PM[1].Value = ((HttpContext.Current.Session["Role"].ToString() == "3") ? HttpContext.Current.Session["Id"].ToString() : From);
PM[2] = new SqlParameter("@Message", SqlDbType.VarChar);
PM[2].Value = Message;
PM[3] = new SqlParameter("@Author", SqlDbType.VarChar);
PM[3].Value = HttpContext.Current.Session["User"].ToString();
PM[4] = new SqlParameter("@AuthorId", SqlDbType.VarChar);
PM[4].Value = HttpContext.Current.Session["Id"].ToString();
PM[5] = new SqlParameter("@RoleId", SqlDbType.VarChar);
PM[5].Value = HttpContext.Current.Session["Role"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_SaveMessage", dsResult, null);
string tblTransferReq = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblTransferReq);
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> UpdateTutorInfo(string Name, string Address, string Email, string Phone, string Avail, string TutorId, string Subjects)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[7];
PM[0] = new SqlParameter("@Name", SqlDbType.VarChar);
PM[0].Value = Name;
PM[1] = new SqlParameter("@Address", SqlDbType.VarChar);
PM[1].Value = Address;
PM[2] = new SqlParameter("@Email", SqlDbType.VarChar);
PM[2].Value = Email;
PM[3] = new SqlParameter("@Phone", SqlDbType.VarChar);
PM[3].Value = Phone;
PM[4] = new SqlParameter("@Avail", SqlDbType.VarChar);
PM[4].Value = Avail;
PM[5] = new SqlParameter("@TutorId", SqlDbType.BigInt);
PM[5].Value = TutorId;
PM[6] = new SqlParameter("@Subjects", SqlDbType.VarChar);
PM[6].Value = Subjects;
dsResult = gf.Filldatasetvalue(PM, "USP_UpdateTutorInfo", dsResult, null);
string tblUpdateMessage = Tutor_MailBox.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblUpdateMessage);
return(obj_list);
}
public static List <string> InsertIntoCallLogs(object Obj_CallLogs)
{
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
_CallLogs objCallLogs = jsonSerializer.Deserialize <_CallLogs>(Obj_CallLogs.ToString());
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[4];
PM[0] = new SqlParameter("@Inqueryid", SqlDbType.BigInt);
PM[0].Value = objCallLogs._InquiryID;
PM[1] = new SqlParameter("@Date", SqlDbType.DateTime);
PM[1].Value = objCallLogs._Date;
PM[2] = new SqlParameter("@Notes", SqlDbType.VarChar);
PM[2].Value = objCallLogs._Notes;
PM[3] = new SqlParameter("@UserId", SqlDbType.BigInt);
PM[3].Value = HttpContext.Current.Session["UserId"];
dsResult = gf.Filldatasetvalue(PM, "USP_InsertIntoCallLogs", dsResult, null);
string tblCallLogs = Enrollment_EnrolementAction.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblCallLogs);
return(obj_list);
}
protected void Page_Load(object sender, EventArgs e)
{
GenralFunction gf = new GenralFunction();
DataSet dsResult = new DataSet();
gf.Filldatasetvalue(null, "sp_testing", dsResult, null);
}
public static List <string> UpdateTableNumber(string MSID1, string MSID2, string MSID3, string Tablenumber)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[8];
PM[0] = new SqlParameter("@MSID1", SqlDbType.BigInt);
PM[0].Value = ((MSID1 == "null" || MSID1 == "") ? "0" : MSID1);
PM[1] = new SqlParameter("@MSID2", SqlDbType.BigInt);
PM[1].Value = ((MSID2 == "null" || MSID2 == "") ? "0" : MSID2);
PM[2] = new SqlParameter("@MSID3", SqlDbType.BigInt);
PM[2].Value = ((MSID3 == "null" || MSID3 == "") ? "0" : MSID3);
PM[3] = new SqlParameter("@Tablenumber", SqlDbType.BigInt);
PM[3].Value = Tablenumber;
dsResult = gf.Filldatasetvalue(PM, "USP_UpdateTableNumber_Session", dsResult, null);
string tblMessage = Tutor_Schedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
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> Swipe_Tutor(string SID1, string SID2, string SID3, string TID1, string TID2, string TID3)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[6];
PM[0] = new SqlParameter("@SourceStudent1", SqlDbType.VarChar);
PM[0].Value = SID1;
PM[1] = new SqlParameter("@SourceStudent2", SqlDbType.VarChar);
PM[1].Value = SID2;
PM[2] = new SqlParameter("@SourceStudent3", SqlDbType.VarChar);
PM[2].Value = SID2;
PM[3] = new SqlParameter("@TargetStudent1", SqlDbType.VarChar);
PM[3].Value = TID1;
PM[4] = new SqlParameter("@TargetStudent2", SqlDbType.VarChar);
PM[4].Value = TID2;
PM[5] = new SqlParameter("@TargetStudent3", SqlDbType.VarChar);
PM[5].Value = TID3;
dsResult = gf.Filldatasetvalue(PM, "USP_SwipeTutor_Session", dsResult, null);
string tblMessage = Tutor_Schedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> MasterScheduling(string Time, string Day, string Date)
{
HttpContext.Current.Session["Time"] = Time;
HttpContext.Current.Session["Day"] = Day;
HttpContext.Current.Session["Date"] = Date;
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["TutorFranchiseID"].ToString();
PM[1] = new SqlParameter("@Time", SqlDbType.VarChar);
PM[1].Value = Time;
PM[2] = new SqlParameter("@Day", SqlDbType.VarChar);
PM[2].Value = Day;
PM[3] = new SqlParameter("@Date", SqlDbType.VarChar);
PM[3].Value = Date;
dsResult = gf.Filldatasetvalue(PM, "USP_SessionScheduling", dsResult, null);
string tblTables = Tutor_Schedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string tblTutor = Tutor_Schedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
string tblStudent = Tutor_Schedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[2]);
List <string> obj_list = new List <string>();
obj_list.Add(tblTables);
obj_list.Add(tblTutor);
obj_list.Add(tblStudent);
return(obj_list);
}
public static List <string> MasterSchedule_ADD_Update_All(string TutorID, string StudentID, string SubjectID, string ID, string Tablenumber, string TimeID, string Day)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[8];
PM[0] = new SqlParameter("@FranchiseID", SqlDbType.BigInt);
PM[0].Value = HttpContext.Current.Session["FranchiseID"].ToString();;
PM[1] = new SqlParameter("@TutorID", SqlDbType.BigInt);
PM[1].Value = ((TutorID == "null" || TutorID == "") ? "0" : TutorID);
PM[2] = new SqlParameter("@StudentID", SqlDbType.BigInt);
PM[2].Value = StudentID;
PM[3] = new SqlParameter("@SubjectID", SqlDbType.BigInt);
PM[3].Value = SubjectID;
PM[4] = new SqlParameter("@ID", SqlDbType.BigInt);
PM[4].Value = ((ID == "null" || ID == "") ? "0" : ID);
PM[5] = new SqlParameter("@Day", SqlDbType.VarChar);
PM[5].Value = Day;
PM[6] = new SqlParameter("@TimeID", SqlDbType.VarChar);
PM[6].Value = TimeID;
PM[7] = new SqlParameter("@Tablenumber", SqlDbType.BigInt);
PM[7].Value = Tablenumber;
dsResult = gf.Filldatasetvalue(PM, "USP_MasterSchedule_ADD_Update", dsResult, null);
string tblMessage = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> USP_Schedular_Date_frm_to(string from, string to)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[3];
PM[0] = new SqlParameter("@FranchiseId", SqlDbType.BigInt);
PM[0].Value = HttpContext.Current.Session["FranchiseID"].ToString();
PM[1] = new SqlParameter("@from", SqlDbType.VarChar);
PM[1].Value = from;
PM[2] = new SqlParameter("@to", SqlDbType.VarChar);
PM[2].Value = from;
dsResult = gf.Filldatasetvalue(PM, "USP_Schedular_Date_frm_to", dsResult, null);
string SucessMsg = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(SucessMsg);
return(obj_list);
}
public static List <string> Swipe_Student_BlankMSID_Move(string ID1, string Tablenumber, string SchedulleDate_Day, string TimeId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[4];
PM[0] = new SqlParameter("@MasterScheduleID1", SqlDbType.VarChar);
PM[0].Value = ID1;
PM[1] = new SqlParameter("@TableNumber", SqlDbType.VarChar);
PM[1].Value = Tablenumber;
PM[2] = new SqlParameter("@SchedulleDate_Day", SqlDbType.VarChar);
PM[2].Value = SchedulleDate_Day;
PM[3] = new SqlParameter("@TimeId", SqlDbType.VarChar);
PM[3].Value = TimeId;
dsResult = gf.Filldatasetvalue(PM, "Swipe_Student_BlankMSID_Session_Move", dsResult, null);
string tblMessage = Scheduling_WeeklySchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
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> LogTransferRequest(string Date, string StartTime, string Endtime, string Message, string TutorId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[6];
PM[0] = new SqlParameter("@Date", SqlDbType.VarChar);
PM[0].Value = Date;
PM[1] = new SqlParameter("@StartTime", SqlDbType.VarChar);
PM[1].Value = StartTime;
PM[2] = new SqlParameter("@Endtime", SqlDbType.VarChar);
PM[2].Value = Endtime;
PM[3] = new SqlParameter("@Message", SqlDbType.VarChar);
PM[3].Value = Message;
PM[4] = new SqlParameter("@TutorId", SqlDbType.VarChar);
PM[4].Value = HttpContext.Current.Session["Id"].ToString();
PM[5] = new SqlParameter("@Author", SqlDbType.VarChar);
PM[5].Value = HttpContext.Current.Session["User"].ToString();
//Session["User"]
dsResult = gf.Filldatasetvalue(PM, "USP_LogTransferRequest", dsResult, null);
string tblUpdateMessage = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string tblRequestLogged = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
List <string> obj_list = new List <string>();
obj_list.Add(tblUpdateMessage);
obj_list.Add(tblRequestLogged);
return(obj_list);
}
public static List <string> GetTutor(string TutorId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@TutorId", SqlDbType.BigInt);
PM[0].Value = HttpContext.Current.Session["Id"].ToString();;
dsResult = gf.Filldatasetvalue(PM, "USP_Gettutor", dsResult, null);
string tblTutor = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string tblTutorList = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
string tblInbox = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[2]);
string tblSend = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[3]);
string tblSubjects = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[4]);
List <string> obj_list = new List <string>();
obj_list.Add(tblTutor);
obj_list.Add(tblTutorList);
obj_list.Add(tblInbox);
obj_list.Add(tblSend);
obj_list.Add(tblSubjects);
return(obj_list);
}
public static void CreatEevent(int Sleep, DateTime Start, DateTime End, String Emails, string Summary, string location, string APIPath, string Description, int InquiryID)
{
try
{
string tz = TimeZoneInfo.Local.DisplayName;
var credential = CreateCredential(APIPath);
var service = CreateService(credential);
List <EventAttendee> listAttendees = new List <EventAttendee>();
for (int i = 0; i < Emails.Split(',').Length; i++)
{
EventAttendee Attendance = new EventAttendee();
Attendance.Email = Emails.Split(',')[i];
listAttendees.Add(Attendance);
}
Event InquiryEvents = new Event()
{
Summary = Summary,
Start = new EventDateTime()
{
DateTime = Start, TimeZone = TimeZoneInfo.Local.DisplayName
},
End = new EventDateTime()
{
DateTime = End, TimeZone = TimeZoneInfo.Local.DisplayName
},
Location = location,
Description = Description,
Attendees = listAttendees
};
var list = service.CalendarList.List().Execute();
var calendar = list.Items[0];
var request = service.Events.Insert(InquiryEvents, calendar.Id);
var result = request.Execute();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@InquiryId", SqlDbType.VarChar);
PM[0].Value = InquiryID;
PM[1] = new SqlParameter("@CalendarID", SqlDbType.VarChar);
PM[1].Value = result.Id;
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
dsResult = gf.Filldatasetvalue(PM, "USP_UpdateCalendarID", dsResult, null);
}
catch (Exception ex)
{
}
}
public static string EnrollStudents(object obj_Enroll, Int64 InqiryId)
{
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
// _EnrollObjects obj_EnrollObjects = jsonSerializer.Deserialize<_EnrollObjects>(obj_Enroll.ToString());
List <_EnrollObject> obj_EnrollObjects = jsonSerializer.Deserialize <List <_EnrollObject> >(obj_Enroll.ToString());
SqlParameter[] PM = new SqlParameter[2];
#region "Inquiry Student Object for usp_CreateInquary"
DataTable dtIS = new DataTable();
dtIS.Columns.Add("TutorName");
dtIS.Columns.Add("Day");
dtIS.Columns.Add("Time");
dtIS.Columns.Add("Subject");
dtIS.Columns.Add("Gender");
dtIS.Columns.Add("Student");
dtIS.Columns.Add("SubjectHrs");
dtIS.Columns.Add("StudyHallHrs");
for (int x = 0; x < obj_EnrollObjects.Count; x++)
{
DataRow dr = dtIS.NewRow();
dr[0] = obj_EnrollObjects[x]._TutorName;
dr[1] = obj_EnrollObjects[x]._Day;
dr[2] = obj_EnrollObjects[x]._Time.Split('-')[0];
dr[3] = obj_EnrollObjects[x]._Subject;
dr[4] = obj_EnrollObjects[x]._Gender;
dr[5] = obj_EnrollObjects[x]._Student;
dr[6] = obj_EnrollObjects[x]._SubjectsHrs;
dr[7] = obj_EnrollObjects[x]._StudyHallHrs;
dtIS.Rows.Add(dr);
}
PM[0] = new SqlParameter("@Enroll", SqlDbType.Structured);
PM[0].Value = dtIS;
#endregion
PM[1] = new SqlParameter("@InquiryId", SqlDbType.VarChar);
PM[1].Value = InqiryId;
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
dsResult = gf.Filldatasetvalue(PM, "USP_EnrollStudents", dsResult, null);
return(dsResult.Tables[0].Rows[0][0].ToString());//dsResult;
}
public static List <string> GetInvoice(int InquiryId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@InquiryId", SqlDbType.BigInt);
PM[0].Value = InquiryId;
dsResult = gf.Filldatasetvalue(PM, "USP_GETStudentInvoice", dsResult, null);
string tblInvoiceStudent = Enrollment_MeetingAction.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblInvoiceStudent);
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> GETTimes(string ID)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@FranchiseID", SqlDbType.BigInt);
PM[0].Value = HttpContext.Current.Session["FranchiseID"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_GETTimes", dsResult, null);
string tblMessage = Admin_FranchiseSetting.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> DeleteStudent(string ID)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@MasterScheduleId", SqlDbType.BigInt);
PM[0].Value = ID;
dsResult = gf.Filldatasetvalue(PM, "USP_DeleteStudent_Session", dsResult, null);
string tblMessage = Tutor_Schedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}
public static List <string> GetSubject()
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@FranchiseID", SqlDbType.BigInt);
PM[0].Value = HttpContext.Current.Session["TutorFranchiseID"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_GetSubject", dsResult, null);
string tblSubjects = Tutor_Schedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblSubjects);
return(obj_list);
}
public static List <string> GetTransferRequest(string TutorId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@TutorId", SqlDbType.BigInt);
PM[0].Value = TutorId;
dsResult = gf.Filldatasetvalue(PM, "USP_GetTransferRequest", dsResult, null);
string tblTransferReq = Manage_TutorDetail.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblTransferReq);
return(obj_list);
}
public List <string> GetEnrolementView(string obj_Inquiry)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
dsResult = gf.Filldatasetvalue(null, "USP_GetEnrolementView", dsResult, null);
string tblInquiry = DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string tblInquiryStudents = DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
string tblAssessments = DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[2]);
string tblMeetings = DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[3]);
List <string> obj_list = new List <string>();
obj_list.Add(tblInquiry);
//obj_list.Add(tblInquiryStudents);
obj_list.Add(tblAssessments);
obj_list.Add(tblMeetings);
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_GetStudentInfo", dsResult, null);
string tblStudent = Public_StudentInformation.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblStudent);
return(obj_list);
}
public static List <string> GetATransferRequest(string TutorId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@TutorId", SqlDbType.BigInt);
PM[0].Value = HttpContext.Current.Session["Id"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_GetATransferRequest", dsResult, null);
string tblTransferReq = Tutor_Shifts.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblTransferReq);
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);
}
