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]));
}