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> 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]));
}
}
//////////////////////////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 <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> 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> 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> 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]));
}
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]));
}
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]));
}
/// <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]));
}
////////////////////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 async Task <DataTable> RegisterCustodianROM(int Event_No, int DocID, string Token, int flag)
{
Dictionary <string, object> dictUserDetail = new Dictionary <string, object>();
dictUserDetail.Add("@doc_id", DocID);
dictUserDetail.Add("@event_id", Event_No);
dictUserDetail.Add("@token", Token);
dictUserDetail.Add("@flag", flag);
DataSet ds = await AppDBCalls.GetDataSet("Evote_Sp_Cust_ROM_Register", dictUserDetail);
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 Audience Details using get method //////////////////////////
public async Task <DataTable> GetAudience_Details(int aud_id, string Token)
{
Dictionary <string, object> dictRegis = new Dictionary <string, object>();
dictRegis.Add("@aud_id", aud_id);
dictRegis.Add("@token", Token);
DataSet ds = new DataSet();
ds = await AppDBCalls.GetDataSet("Evote_GetAudienceDetails", dictRegis);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
//////////////////////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]));
}
////////////////////////// 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]));
}
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]));
}
////////////////////////// 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]));
}
////////////////////////POST Method for Speaker List//////////////////////////
public async Task<DataTable> SpeakerListData(FJC_SpeakerList fJC_SpeakerList, string token)
{
Dictionary<string, object> dictLogin = new Dictionary<string, object>();
dictLogin.Add("@event_id", fJC_SpeakerList.event_id);
dictLogin.Add("@email_id", fJC_SpeakerList.email_id);
dictLogin.Add("@name", fJC_SpeakerList.name);
dictLogin.Add("@flag", 1);
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 <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 Serach using POST method/////////////////////
public async Task <DataTable> GetSearch_Details(FJC_AccountSearch fJC_AccountSearch, string Token)
{
Dictionary <string, object> dictRegis = new Dictionary <string, object>();
dictRegis.Add("@user_type", fJC_AccountSearch.user_type);
dictRegis.Add("@str", fJC_AccountSearch.str);
dictRegis.Add("@token", Token);
DataSet ds = new DataSet();
ds = await AppDBCalls.GetDataSet("Evote_GetAccountSearch", dictRegis);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
//////////////////////////////ShareHolder Derestrict/////////////////////////////////
public async Task <DataTable> ShareHolder_DerestrictData(FJC_SharedHolder_Derestrict fjc_SharedHolder_Derestrict, string token)
{
Dictionary <string, object> dictLogin = new Dictionary <string, object>();
dictLogin.Add("@event_id", fjc_SharedHolder_Derestrict.event_id);
dictLogin.Add("@dpcl", fjc_SharedHolder_Derestrict.dpcl);
dictLogin.Add("@flag", 3);
dictLogin.Add("@token", token);
DataSet ds = new DataSet();
ds = await AppDBCalls.GetDataSet("Evote_ShareHolder_Restrict", dictLogin);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
public async Task <DataTable> Modify_Vote(FJC_Event_Update _event, string Token)
{
DataTable dt1 = new DataTable();
Dictionary <string, object> dictUserDetail = new Dictionary <string, object>();
dictUserDetail.Add("@event_id", _event.event_id);
dictUserDetail.Add("@token", Token);
dictUserDetail.Add("@Flag", 1);
DataSet ds = await AppDBCalls.GetDataSet("Custodian_VoteUpdate", dictUserDetail);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
public async Task <DataTable> Get_VideoConf(int event_id, string Token)
{
Dictionary <string, object> dictRegis = new Dictionary <string, object>();
dictRegis.Add("@event_id", event_id);
dictRegis.Add("@flag", 2);
dictRegis.Add("@token", Token);
DataSet ds = new DataSet();
ds = await AppDBCalls.GetDataSet("Evote_VideoConf", dictRegis);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
/////////////////Get Account List Details using "List" get method //////////////////////////
public async Task <DataTable> GetAccountList_Details(int user_type, string status, string Token)
{
Dictionary <string, object> dictRegis = new Dictionary <string, object>();
dictRegis.Add("@user_type", user_type);
dictRegis.Add("@status", status);
dictRegis.Add("@token", Token);
DataSet ds = new DataSet();
ds = await AppDBCalls.GetDataSet("Evote_GetAccountList", dictRegis);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
private DataTable UpdateRegisterROM(int Event_No, string upload_id, string error_log_file_name, string default_path, string Token, int flag)
{
Dictionary <string, object> dictUserDetail = new Dictionary <string, object>();
dictUserDetail.Add("@upload_id", Convert.ToInt32(upload_id));
dictUserDetail.Add("@error_log_file_name", error_log_file_name);
dictUserDetail.Add("@default_path", default_path);
dictUserDetail.Add("@event_id", Event_No);
dictUserDetail.Add("@token", Token);
dictUserDetail.Add("@flag", flag);
DataSet ds = Persistence.Contexts.AppDBCalls.GetDataSet("Evote_Sp_ROM_Register", dictUserDetail).Result;
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
public async Task <DataTable> GetFileDetails(int doc_id, string Token)
{
Dictionary <string, object> dictfileUpld = new Dictionary <string, object>();
dictfileUpld.Add("@doc_id", doc_id);
dictfileUpld.Add("@flag", 1);
dictfileUpld.Add("@token", Token);
DataSet ds = new DataSet();
ds = await AppDBCalls.GetDataSet("Evote_spFileUpload", dictfileUpld);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}
////////////////Get For Notice Controller/////////////////
public async Task <DataTable> GetNotice_Details(FJC_Notice fjc_notice)
{
Dictionary <string, object> dictRegis = new Dictionary <string, object>();
dictRegis.Add("@issuer_name", fjc_notice.issuer_name);
dictRegis.Add("@type", fjc_notice.type);
dictRegis.Add("@start_date", fjc_notice.start_date);
dictRegis.Add("@end_date", fjc_notice.end_date);
DataSet ds = new DataSet();
ds = await AppDBCalls.GetDataSet("Evote_notice_result_fetch", dictRegis);
return(Reformatter.Validate_DataTable(ds.Tables[0]));
}