private async Task <DataTable> CommonEventprocess(FJC_GenerateEVENT fJC_EVSN, string Token) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@EVENT_ID", fJC_EVSN.event_id); dictLogin.Add("@ISIN", fJC_EVSN.isin.Trim()); dictLogin.Add("@TYPE_ISIN", fJC_EVSN.type_isin); dictLogin.Add("@TYPE_EVOTING", fJC_EVSN.type_evoting); dictLogin.Add("@TOTAL_NOF_SHARE", fJC_EVSN.total_nof_share); dictLogin.Add("@VOTING_RIGHTS", fJC_EVSN.voting_rights); dictLogin.Add("@CUT_OF_DATE", fJC_EVSN.cut_of_date); //new DateTime(2012, 12, 25, 10, 30, 50).ToString("yyyy-MM-dd HH:mm:ss")); dictLogin.Add("@SCRUTINIZER", fJC_EVSN.scrutinizer); dictLogin.Add("@token", Token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_Generate_Event", dictLogin); //mailing contents are here if (ds.Tables[0].Columns.Contains("Event_Id")) { SendMail sendmail = new SendMail(); string EmailerType = "GenerateEventEmailer"; int event_id = Convert.ToInt32(ds.Tables[0].Rows[0]["Event_Id"]); sendmail.SendLetterMail(0, EmailerType, event_id); } return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataTable> ReportsData(int event_id, string token) { //Export to Excel var getExcelDetail = await exportToExcel(token, event_id); if (getExcelDetail.Columns.Contains("Error")) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@event_id", event_id); dictLogin.Add("@flag", 0); dictLogin.Add("@error", 1003); dictLogin.Add("@token", token); dictLogin.Add("@doc_no", getExcelDetail.Rows[0]["doc_no"]); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_Scrutinizer_Report", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); } else { //throw new CustomException.InvalidFileRejected(); Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@event_id", event_id); dictLogin.Add("@flag", 0); dictLogin.Add("@token", token); dictLogin.Add("@doc_no", getExcelDetail.Rows[0]["doc_no"]); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_Scrutinizer_Report", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); } }
public async Task <DataTable> ChangePasswordData(FJC_ChangePassword fJC_changePwd, string token) { Dictionary <string, object> dictChangePwd = new Dictionary <string, object>(); dictChangePwd.Add("@DPIIDCLID", fJC_changePwd.UserID); dictChangePwd.Add("@CurrPassword", fJC_changePwd.encrypt_OldPassword); dictChangePwd.Add("@NewPassword", fJC_changePwd.encrypt_NewPassword); dictChangePwd.Add("@token", token); // dictChangePwd.Add("@CurrPassword", DecryptPassword.Decrypt_Password(fJC_changePwd.encrypt_OldPassword)); // dictChangePwd.Add("@NewPassword", DecryptPassword.Decrypt_Password(fJC_changePwd.encrypt_NewPassword)); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_ChangePassword", dictChangePwd); //mailing contents are here if (ds.Tables[0].Columns.Contains("rowid")) { SendMail sendmail = new SendMail(); string EmailerType = "ChangePasswordEmailer"; int row_id = Convert.ToInt32(ds.Tables[0].Rows[0]["rowid"]); sendmail.SendLetterMail(0, EmailerType, 0, row_id); //aud_id missing changes done } return(Reformatter.Validate_DataTable(ds.Tables[0])); }
private async Task <DataTable> UploadToDatabase(string getpath, FJC_FileUpload fjc_FileUpload, string Token) { string filenamewithdatetime, SaveToFolder; //File name with time stamp and Event no filenamewithdatetime = System.DateTime.Now.ToString("yyyyMMdd-HHmmssfff") + "-" + fjc_FileUpload.files.FileName; //Return Full file path to save to database SaveToFolder = FolderPaths.CreateSpecificFolder(getpath, filenamewithdatetime.ToString(), fjc_FileUpload); //-end-create folder directory- //Saving file details to Database if (SaveToFolder != null) { Dictionary <string, object> dictfileUpld = new Dictionary <string, object>(); dictfileUpld.Add("@File_Name", filenamewithdatetime); dictfileUpld.Add("@File_Path", SaveToFolder); dictfileUpld.Add("@token", Token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_spFileUpload", dictfileUpld); return(Reformatter.Validate_DataTable(ds.Tables[0])); } else { throw new CustomException.InvalidPathReference(); } }
public async Task <DataSet> EVENTDetail(FJC_CompanyUpdate_Event fJC_CompanyUpdate_Event, string Token) { DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("EVOTE_companyEVENT_DETAIL", CommonSpParam(fJC_CompanyUpdate_Event, Token), PassResolutionArray(fJC_CompanyUpdate_Event.resolutions)); return(Reformatter.Validate_Dataset(ds)); }
public string DBCheck() { //return JsonConvert.SerializeObject(AppDBCalls.Rel_connection); return(JsonConvert.SerializeObject(AppDBCalls.GetDataSet("TestingServices", new Dictionary <string, object>() { { "@flag", 1 } }))); }
//////////////////////////POST////////////////////////////// public async Task <DataTable> Vote_Investor_data(FJC_Vote_Investor fjc_Vote_Investor, string Token) { DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_Vote_Investor", CommonSpParam(fjc_Vote_Investor, Token), PassResolutionArray(fjc_Vote_Investor.resolutions)); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
///////////////////////Get Method for Speaker List///////////////////////// public async Task<DataTable> GetSpeakerList( int event_id,string token) { Dictionary<string, object> dictLogin = new Dictionary<string, object>(); dictLogin.Add("@event_id", event_id); dictLogin.Add("@flag", 2); dictLogin.Add("@token", token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_SpeakerList", dictLogin); return Reformatter.Validate_DataTable(ds.Tables[0]); }
public async Task <DataSet> GetRegistrationInvestorData(string Token) { Dictionary <string, object> dictRegis = new Dictionary <string, object>(); dictRegis.Add("@token", Token); dictRegis.Add("@flag", "get"); DataSet ds = await AppDBCalls.GetDataSet("Evote_GetRegistrationIDData", dictRegis); return(ds); }
///////////////////////////Bulk Upload stored Procedure called here ///////////////////// private DataTable BulkUpload_ROM_Intimation(int Event_No, int DocID, string Token, string upload_id) { Dictionary <string, object> dictUserDetail = new Dictionary <string, object>(); dictUserDetail.Add("@DocumentID", DocID); dictUserDetail.Add("@event_no", Event_No); dictUserDetail.Add("@token", Token); dictUserDetail.Add("@upload_id", upload_id); return(AppDBCalls.GetDataSet("SP_IMPORTROMFILE_ROM_Intimation", dictUserDetail).Result.Tables[0]); }
public async Task <DataTable> GetRegistrationIDData(string Token) { Dictionary <string, object> dictRegis = new Dictionary <string, object>(); dictRegis.Add("@token", Token); dictRegis.Add("@flag", "get"); DataSet ds = await AppDBCalls.GetDataSet("Evote_GetRegistrationIDData", dictRegis); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataTable> GetInvestorEmailIDData(string UserID) { Dictionary <string, object> dictForgotPwd = new Dictionary <string, object>(); dictForgotPwd.Add("@DPIIDCLID", UserID); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_GetInvestorEmailID", dictForgotPwd); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataTable> Check(string File_Path) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@FilePath", File_Path); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("SP_CHK_COUNT_SHARES", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataTable> GetUserDetailsByTokenID(string TokenID) { Dictionary <string, object> dictUserDetail = new Dictionary <string, object>(); dictUserDetail.Add("@Token", TokenID); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_GetLoginDetails", dictUserDetail); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataTable> AllUploadedDocuments(string Token) { Dictionary <string, object> dictUserDetail = new Dictionary <string, object>(); dictUserDetail.Add("@token", Token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("sp_uploaded_documents", dictUserDetail); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
private DataTable SaveROMUploadErrorFile(string error_log_file_name, string default_path, string Token, int event_id) { Dictionary <string, object> dictfileUpld = new Dictionary <string, object>(); dictfileUpld.Add("@File_Name", error_log_file_name); dictfileUpld.Add("@File_Path", default_path); dictfileUpld.Add("@token", Token); DataSet ds = new DataSet(); return(AppDBCalls.GetDataSet("Evote_spFileUpload", dictfileUpld).Result.Tables[0]); }
/// <summary> /// ////////////////////////////Check Custodian Vote file and return Error-Remark ////////////////////// /// </summary> /// <param name="doc_id"></param> /// <param name="event_id"></param> /// <param name="token"></param> /// <returns></returns> //////////////////////////////////////////Bulk Upload stored Procedure called here //////////////////////////////////////////////////// private async Task <DataTable> InsertBulkFileUpload(int Event_No, int DocID, string Token) { Dictionary <string, object> dictUserDetail = new Dictionary <string, object>(); dictUserDetail.Add("@DocumentID", DocID); dictUserDetail.Add("@token", Token); dictUserDetail.Add("@Flag", 0); DataSet ds = await AppDBCalls.GetDataSet("Sp_ValidateAndInsert_CustodianROM", dictUserDetail); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
private async Task <DataTable> GetAgreementHtmlContent(string Token) { Dictionary <string, object> dictUserDetail = new Dictionary <string, object>(); dictUserDetail.Add("@token", Token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("SP_GETDOCUMENTCONTENT", dictUserDetail); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
////////////////////get For Issuer Controller/////////////////// public async Task <DataTable> GetIssuer_Details(string str) { Dictionary <string, object> dictRegis = new Dictionary <string, object>(); dictRegis.Add("@getCh", str); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_GetList", dictRegis); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
private DataTable Update_ScrutinizerReport_failure(string error_log_file_name, string default_path, string Token, int event_id) { Dictionary <string, object> dictfileDnld = new Dictionary <string, object>(); dictfileDnld.Add("@File_Name", error_log_file_name); dictfileDnld.Add("@File_Path", default_path); dictfileDnld.Add("@token", Token); dictfileDnld.Add("@event_id", event_id); dictfileDnld.Add("@flag", 1); return(AppDBCalls.GetDataSet("Evote_SpExcelFile_Download", dictfileDnld).Result.Tables[0]); }
public async Task <DataTable> RegisterGetSpeakerData(string token) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@flag", 2); dictLogin.Add("@token", token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_InvestortSpeaker_get", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
//////////////////////////////////////////Bulk Upload stored Procedure called here //////////////////////////////////////////////////// private DataTable InsertBulkFileUpload(int Event_No, int DocID, string Token, string upload_id) { Dictionary <string, object> dictUserDetail = new Dictionary <string, object>(); dictUserDetail.Add("@DocumentID", DocID); dictUserDetail.Add("@event_no", Event_No); dictUserDetail.Add("@token", Token); dictUserDetail.Add("@upload_id", upload_id); DataSet ds = AppDBCalls.GetDataSet("SP_IMPORTROMFILE", dictUserDetail).Result; return(ds.Tables[0]); }
public async Task <DataSet> GetCompanyEVENTDetail(int EVENT_ID, string Token) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@EVENT_ID", EVENT_ID); dictLogin.Add("@token", Token); dictLogin.Add("@flag", 1); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("EVOTE_companyEVENT_DETAIL", dictLogin); return(Reformatter.Validate_Dataset(ds)); }
//////////////////////Power OF Attorney (POA) upload/////////////////////// public async Task <DataTable> PowerOfAttorneyDownload(int doc_id, string Token) { Dictionary <string, object> dictUserDetail = new Dictionary <string, object>(); dictUserDetail.Add("@doc_id", doc_id); dictUserDetail.Add("@token", Token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("sp_Upload_POA", dictUserDetail); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataTable> Getprivate_List_Details(string getCh, string Token) { Dictionary <string, object> dictRegis = new Dictionary <string, object>(); dictRegis.Add("@getCh", getCh); dictRegis.Add("@token", Token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_GetPrivateList", dictRegis); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataTable> UnlockEventData(int event_id, string token) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@event_id", event_id); dictLogin.Add("@token", token); dictLogin.Add("@flag", 0); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("sp_LockEvent", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
////////////////////////// Get ////////////////////////////// public async Task <DataTable> Intimation_Getdata(string Token, string type) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@token", Token); dictLogin.Add("@type", type); dictLogin.Add("@flag", 1); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_Intimation", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
public async Task <DataSet> getExcelData(string Token, int event_id) { Dictionary <string, object> dictfileDnld = new Dictionary <string, object>(); dictfileDnld.Add("@token", Token); dictfileDnld.Add("@event_id", event_id); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_ExportToExcel", dictfileDnld); return(Reformatter.Validate_Dataset(ds)); }
public async Task <DataTable> ReportsGetData(int event_id, string token) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@event_id", event_id); dictLogin.Add("@flag", 1); dictLogin.Add("@token", token); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_Scrutinizer_Report", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); }
////////////////////////// Get Request Bill ////////////////////////////// public async Task <DataTable> GetRequestBillData(string Token, int id, int flag) { Dictionary <string, object> dictLogin = new Dictionary <string, object>(); dictLogin.Add("@token", Token); dictLogin.Add("@id", id); dictLogin.Add("@flag", flag); DataSet ds = new DataSet(); ds = await AppDBCalls.GetDataSet("Evote_RequestBill", dictLogin); return(Reformatter.Validate_DataTable(ds.Tables[0])); }