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"));
}
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"));
}
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"));
}
public DataTable CheckPassword(string OldPassword)
{
Hashtable ht = new Hashtable();
ht.Add("@Password", OldPassword);
return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Max_CheckPassword"));
}
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"));
}
public bool Cloud_TPA_Approve(int Id)
{
Hashtable ht = new Hashtable();
ht.Add("@Id", Id);
return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Cloud_TPA_Approve"));
}
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"));
}
public DataTable GetEnquiryID(int Id)
{
Hashtable ht = new Hashtable();
ht.Add("@Id", Id);
return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Max_GetEnquiryID"));
}
//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"));
}
public DataTable GetFlashVideosTypeID(int TypeID)
{
Hashtable ht = new Hashtable();
ht.Add("@Id", TypeID);
return(SQlDataAccess.GetInstance().ExecuteStoredProcedureSelect(ht, "Max_GetFlashVideosTypeID"));
}
public bool DeleteFlashVideos(int ID)
{
Hashtable ht = new Hashtable();
ht.Add("@Id", ID);
return(SQlDataAccess.GetInstance().ExecuteStoredProcedure(ht, "Max_DeleteFlashVideos"));
}
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"));
}
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"));
}
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"));
}
/// <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);
}
//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"));
}
//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"));
}
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"));
}
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"));
}
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"));
}
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"));
}
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"));
}
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"));
}
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"));
}
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"));
}
//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"));
}
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"));
}
//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"));
}
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"));
}
//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"));
}