示例#1
0
    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);
    }
示例#2
0
    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);
    }
示例#3
0
    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);
    }
示例#4
0
    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);
    }
示例#5
0
    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);
    }
示例#6
0
    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);
    }
示例#7
0
    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);
    }
示例#8
0
    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);
    }
示例#9
0
    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);
    }
示例#10
0
    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);
    }
示例#11
0
    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);
    }
示例#12
0
    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);
    }
示例#13
0
    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);
    }