Ejemplo n.º 1
0
        public DataTable Files_Get_TPA_Requsted_Sent_Files(string Email)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Email", Email);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Files_Get_TPA_Requsted_Sent_Files"));
        }
Ejemplo n.º 2
0
        public DataTable Cloud_UserReg_get__User_Info_By_Email(string email)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@email", email);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Cloud_UserReg_get__User_Info_By_Email"));
        }
Ejemplo n.º 3
0
        public bool TPARequest_Update_TPA_Request(int Files_Id)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Files_Id", Files_Id);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "TPARequest_Update_TPA_Request"));
        }
Ejemplo n.º 4
0
        public DataTable CheckPassword(string OldPassword)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Password", OldPassword);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Max_CheckPassword"));
        }
Ejemplo n.º 5
0
        public DataTable ReuploadFiles_get_File_By_Id(int Id)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Id", Id);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "ReuploadFiles_get_File_By_Id"));
        }
Ejemplo n.º 6
0
        public bool Cloud_TPA_Approve(int Id)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Id", Id);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Cloud_TPA_Approve"));
        }
Ejemplo n.º 7
0
        public DataTable Get_TPA_By_Id(int F_Id)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@F_Id", F_Id);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Get_TPA_By_Id"));
        }
Ejemplo n.º 8
0
        public DataTable GetEnquiryID(int Id)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Id", Id);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Max_GetEnquiryID"));
        }
Ejemplo n.º 9
0
        //Approve Cloud User
        public bool Cloud_UserReg_Approve_Cloud_User(int CloudUserReg_Id)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@CloudUserReg_Id", CloudUserReg_Id);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Cloud_UserReg_Approve_Cloud_User"));
        }
Ejemplo n.º 10
0
        public DataTable GetFlashVideosTypeID(int TypeID)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Id", TypeID);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Max_GetFlashVideosTypeID"));
        }
Ejemplo n.º 11
0
        public bool DeleteFlashVideos(int ID)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Id", ID);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Max_DeleteFlashVideos"));
        }
Ejemplo n.º 12
0
        public DataTable UserRequest_Get_User_Request_Accepted_Files(string Email)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Email", Email);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "UserRequest_Get_User_Request_Accepted_Files"));
        }
Ejemplo n.º 13
0
        public DataTable Files_Get_Cloud_User_Approved_Files(string Email)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Email", Email);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Files_Get_Cloud_User_Approved_Files"));
        }
Ejemplo n.º 14
0
        public bool AddFlashNews(string Title, string Description)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Title", Title);
            ht.Add("@Description", Description);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Max_AddFlashNews"));
        }
Ejemplo n.º 15
0
 /// <summary>
 /// creates the single instance of DB2DataAccess object that can be used by other class
 /// </summary>
 /// <returns>DB2DataAccess, object the current instance of the DB2DataAccess</returns>
 public static SQlDataAccess GetInstance()
 {
     if (_SQlDataAccess == null)
     {
         _SQlDataAccess = new SQlDataAccess();
     }
     return(_SQlDataAccess);
 }
Ejemplo n.º 16
0
        //Authenticate Cloud User Authencate
        public DataTable CloudUserReg_Authencate(string CloudUserReg_Email, string CloudUserReg_Password)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@CloudUserReg_Email", CloudUserReg_Email);
            ht.Add("@CloudUserReg_Password", CloudUserReg_Password);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "CloudUserReg_Authencate"));
        }
Ejemplo n.º 17
0
        //TPA Authenticate
        public DataTable TPA_Authenticate(string TPA_Email, string TPA_Password)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@TPA_Email", TPA_Email);
            ht.Add("@TPA_Password", TPA_Password);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "TPA_Authenticate"));
        }
Ejemplo n.º 18
0
        public bool Files_update_File(int F_Id, string uploadFilepath)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@F_Id", F_Id);
            ht.Add("@uploadFilepath", uploadFilepath);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Files_update_File"));
        }
Ejemplo n.º 19
0
        public bool AddFlashVideo(string FlashVideo, int Videotype)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@FlashVideo", FlashVideo);
            ht.Add("@Videotype", Videotype);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Max_AddFlashVideo"));
        }
Ejemplo n.º 20
0
        public DataTable UserRequest_Check_User_File_Request_By_Id(int Files_Id, string Email)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Files_Id", Files_Id);
            ht.Add("@Email", Email);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "UserRequest_Check_User_File_Request_By_Id"));
        }
Ejemplo n.º 21
0
        public bool UserRequest_add_User_File_Request(int Files_Id, string Email)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Files_Id", Files_Id);
            ht.Add("@Email", Email);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "UserRequest_add_User_File_Request"));
        }
Ejemplo n.º 22
0
        public bool ReuploadFiles_add_File(int Files_Id, string UploadFile)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Files_Id", Files_Id);
            ht.Add("@UploadFile", UploadFile);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "ReuploadFiles_add_File"));
        }
Ejemplo n.º 23
0
        public bool ChangePassword(string Username, string NewPassword)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Username", Username);
            ht.Add("@Password", NewPassword);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Max_ChangePassword"));
        }
Ejemplo n.º 24
0
        public DataTable Authenticate(string Username, string Password)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Username", Username);
            ht.Add("@Password", Password);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Max_Authenticate"));
        }
Ejemplo n.º 25
0
        public bool UpdateFlashVideos(int ID, int VideoType, string VideoName)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Id", ID);
            ht.Add("@FlashVideos", VideoName);
            ht.Add("@VideoType", VideoType);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Max_UpdateFlashVideos"));
        }
Ejemplo n.º 26
0
        //Add Files
        public bool Files_add_File(string User, int TPA, string FileName, string UploadFile, string Key)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@User", User);
            ht.Add("@TPA", TPA);
            ht.Add("@FileName", FileName);
            ht.Add("@UploadFile", UploadFile);
            ht.Add("@Key", Key);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Files_add_File"));
        }
Ejemplo n.º 27
0
        public bool AddEnquiry(string Name, string EmailID, string phoneno, string subject, string Enquiry)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Name", Name);
            ht.Add("@EmailID", EmailID);
            ht.Add("@phoneno", phoneno);
            ht.Add("@subject", subject);
            ht.Add("@Enquiry", Enquiry);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Max_AddEnquiry"));
        }
Ejemplo n.º 28
0
        //Register TPA
        public DataTable TPA_addTPAInfo(string TPA_Name, string TPA_Email, string TPA_Password, string TPA_Phone, string TPA_City, string TPA_State, string TPA_Country, int type)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@TPA_Name", TPA_Name);
            ht.Add("@TPA_Email", TPA_Email);
            ht.Add("@TPA_Password", TPA_Password);
            ht.Add("@TPA_Phone", TPA_Phone);
            ht.Add("@TPA_City", TPA_City);
            ht.Add("@TPA_State", TPA_State);
            ht.Add("@TPA_Country", TPA_Country);
            ht.Add("@type", type);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "TPA_addTPAInfo"));
        }
Ejemplo n.º 29
0
        public bool TPA_UpdateTPAInfo(int Id, string TPA_Name, string TPA_Email, string TPA_Password, string TPA_Phone, string TPA_City, string TPA_State, string TPA_Country)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@Id", Id);
            ht.Add("@TPA_Name", TPA_Name);
            ht.Add("@TPA_Email", TPA_Email);
            ht.Add("@TPA_Password", TPA_Password);
            ht.Add("@TPA_Phone", TPA_Phone);
            ht.Add("@TPA_City", TPA_City);
            ht.Add("@TPA_State", TPA_State);
            ht.Add("@TPA_Country", TPA_Country);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "TPA_UpdateTPAInfo"));
        }
Ejemplo n.º 30
0
        //Add Cloud User Registration Details
        public DataTable Cloud_UserReg_addCloudUserInfo(string CloudUserReg_Name, string CloudUserReg_Email, string CloudUserReg_Password, string CloudUserReg_DOB, string CloudUserReg_Phone, string CloudUserReg_City, string CloudUserReg_State, string CloudUserReg_Country)
        {
            Hashtable ht = new Hashtable();

            ht.Add("@CloudUserReg_Name", CloudUserReg_Name);
            ht.Add("@CloudUserReg_Email", CloudUserReg_Email);
            ht.Add("@CloudUserReg_Password", CloudUserReg_Password);
            ht.Add("@CloudUserReg_DOB", CloudUserReg_DOB);
            ht.Add("@CloudUserReg_Phone", CloudUserReg_Phone);
            ht.Add("@CloudUserReg_City", CloudUserReg_City);
            ht.Add("@CloudUserReg_State", CloudUserReg_State);
            ht.Add("@CloudUserReg_Country", CloudUserReg_Country);
            return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Cloud_UserReg_addCloudUserInfo"));
        }