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", 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_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", 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> 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> Swipe_Student_BlankMSID_Summary(string MasterScheduleID1, string MasterScheduleID2,
string TableNumber, string Day, string Time)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[5];
PM[0] = new SqlParameter("@MasterScheduleID1", SqlDbType.VarChar);
PM[0].Value = MasterScheduleID1;
PM[1] = new SqlParameter("@MasterScheduleID2", SqlDbType.VarChar);
PM[1].Value = MasterScheduleID2;
PM[2] = new SqlParameter("@TableNumber", SqlDbType.VarChar);
PM[2].Value = TableNumber;
PM[3] = new SqlParameter("@Day", SqlDbType.VarChar);
PM[3].Value = Day;
PM[4] = new SqlParameter("@Time", SqlDbType.VarChar);
PM[4].Value = Time;
dsResult = gf.Filldatasetvalue(PM, "Swipe_Student_BlankMSID_Summary", 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> 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["FranchiseID"].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_MasterScheduling", dsResult, null);
string tblTables = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
string tblTutor = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[1]);
string tblStudent = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[2]);
string tblStudent_SH = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[3]);
List <string> obj_list = new List <string>();
obj_list.Add(tblTables);
obj_list.Add(tblTutor);
obj_list.Add(tblStudent);
obj_list.Add(tblStudent_SH);
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["FranchiseID"].ToString();
dsResult = gf.Filldatasetvalue(PM, "USP_GetSubject", dsResult, null);
string tblSubjects = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblSubjects);
return(obj_list);
}
public static List <string> DeleteTble(string ID)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[1];
PM[0] = new SqlParameter("@Ids", SqlDbType.VarChar);
PM[0].Value = ID;
dsResult = gf.Filldatasetvalue(PM, "USP_DeleteTble", 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> UpdateTable(String Tables)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@Id", SqlDbType.VarChar);
PM[0].Value = HttpContext.Current.Session["FranchiseID"].ToString();
PM[1] = new SqlParameter("@Tables", SqlDbType.BigInt);
PM[1].Value = Tables;
dsResult = gf.Filldatasetvalue(PM, "USP_UpdateTable", 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> UpdateSubject(string Subject, String MasterScheduleId)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@Subject", SqlDbType.VarChar);
PM[0].Value = Subject;
PM[1] = new SqlParameter("@MasterScheduleId", SqlDbType.BigInt);
PM[1].Value = MasterScheduleId;
dsResult = gf.Filldatasetvalue(PM, "USP_UpdateSubject", 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> Swipe_Student(string ID1, string ID2)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[2];
PM[0] = new SqlParameter("@MasterScheduleID1", SqlDbType.VarChar);
PM[0].Value = ID1;
PM[1] = new SqlParameter("@MasterScheduleID2", SqlDbType.VarChar);
PM[1].Value = ID2;
dsResult = gf.Filldatasetvalue(PM, "Swipe_Student", 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> CreateAttendance(string MSIDs, string Reasons, string Date)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[3];
PM[0] = new SqlParameter("@MSIDs", SqlDbType.VarChar);
PM[0].Value = MSIDs;
PM[1] = new SqlParameter("@Reasons", SqlDbType.VarChar);
PM[1].Value = Reasons;
PM[2] = new SqlParameter("@Date", SqlDbType.VarChar);
PM[2].Value = Date;
dsResult = gf.Filldatasetvalue(PM, "USP_CreateAttendance", 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> DeleteTutor(string ID1, string ID2, string ID3)
{
DataSet dsResult = new DataSet();
DataFunctions df = new DataFunctions();
GenralFunction gf = new GenralFunction();
SqlParameter[] PM = new SqlParameter[3];
PM[0] = new SqlParameter("@MSID1", SqlDbType.BigInt);
PM[0].Value = ID1;
PM[1] = new SqlParameter("@MSID2", SqlDbType.BigInt);
PM[1].Value = ID2;
PM[2] = new SqlParameter("@MSID3", SqlDbType.BigInt);
PM[2].Value = ID3;
dsResult = gf.Filldatasetvalue(PM, "USP_DeleteTutor", dsResult, null);
string tblMessage = Scheduling_MasterSchedule.DataTableToJSONWithJavaScriptSerializer(dsResult.Tables[0]);
List <string> obj_list = new List <string>();
obj_list.Add(tblMessage);
return(obj_list);
}