Exemplo n.º 1
0
    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());
        }
    }
Exemplo n.º 2
0
    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);
    }
Exemplo n.º 3
0
    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);
    }
Exemplo n.º 4
0
    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);
    }
Exemplo n.º 5
0
    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);
    }
Exemplo n.º 6
0
    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);
    }
Exemplo n.º 7
0
    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);
    }
Exemplo n.º 8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        GenralFunction gf       = new GenralFunction();
        DataSet        dsResult = new DataSet();

        gf.Filldatasetvalue(null, "sp_testing", dsResult, null);
    }
Exemplo n.º 9
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_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);
    }
Exemplo n.º 10
0
    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);
    }
Exemplo n.º 11
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_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);
    }
Exemplo n.º 12
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["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);
    }
Exemplo n.º 13
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);
    }
Exemplo n.º 14
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);
    }
Exemplo n.º 15
0
    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);
    }
Exemplo n.º 16
0
    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);
    }
Exemplo n.º 17
0
    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);
    }
Exemplo n.º 18
0
    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);
    }
Exemplo n.º 19
0
    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)
        {
        }
    }
Exemplo n.º 20
0
    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;
    }
Exemplo n.º 21
0
    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);
    }
Exemplo n.º 22
0
    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);
    }
Exemplo n.º 23
0
    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);
    }
Exemplo n.º 24
0
    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);
    }
Exemplo n.º 25
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["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);
    }
Exemplo n.º 26
0
    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);
    }
Exemplo n.º 27
0
    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);
    }
Exemplo n.º 28
0
    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);
    }
Exemplo n.º 29
0
    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);
    }
Exemplo n.º 30
0
    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);
    }