public async Task <IActionResult> Download_Document([FromQuery] string DownloadType)
{
try
{
var identity = (ClaimsIdentity)User.Identity;
var Token = Token_Handling.Get_Token_FromHeader(Request.Headers, identity);
switch (DownloadType.ToLower())
{
case "agreement":
var result = await _documentDownloadService.AgreementGenerator(Token);
Response.Headers.Add("Access-Control-Expose-Headers", "Content-Disposition");
Response.Headers.Add("Content-Disposition", "attachment");
Response.Headers.Add("filename", result.Rows[0]["file_name"].ToString());
return(Ok(Reformatter.Response_Object("Agreement must be executed on Stamp Paper of Rs. 600", ref result)));
break;
default:
throw new CustomException.InvalidAttempt();
}
}
catch (Exception ex)
{
return((new HandleCatches()).ManageExceptions(ex));
}
}
public async Task <IActionResult> UploadAgreement(FJC_DOC_Upload fJC_DOC_Upload)
{
var identity = (ClaimsIdentity)User.Identity;
var Token = Token_Handling.Get_Token_FromHeader(Request.Headers, identity);
var result = (System.Data.DataTable)null;
switch (fJC_DOC_Upload.upload_type.ToLower())
{
case "agreement":
result = await _documentUploadService.AgreementUpload_Details(fJC_DOC_Upload.doc_id, Token);
return(Ok(Reformatter.Response_Object("File uploaded successfully and will be validated soon", ref result)));
break;
case "power_of_attorney":
result = await _documentUploadService.PowerOfAttorneyDownload(fJC_DOC_Upload.doc_id, Token);
return(Ok(Reformatter.Response_Object("File uploaded successfully", ref result)));
break;
default:
throw new CustomException.InvalidActivity();
}
}
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> 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]));
}
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 <IActionResult> RegistrationSave(FJC_Registration fJC_Registration)
{
try
{
await ManageRecaptcha.ValidateUser(fJC_Registration.captcha);
if (fJC_Registration.reg_type_id == 1 || fJC_Registration.reg_type_id == 2)
{
fJC_Registration.panid = "XXXXX0000X";
}
if (fJC_Registration.reg_type_id != 3)
{
if (!Regex.IsMatch(fJC_Registration.reg_no, @"^[a-zA-Z0-9 -,_]*$"))
{
throw new CustomException.InvalidRegNo();
}
}
var result = await _registrationService.Registration_InsertData(fJC_Registration);
return(Ok(Reformatter.Response_Object("UserID: " + result.Rows[0][0] + " generated. New Registration completed Successfully", ref result)));
}
catch (Exception ex)
{
return((new HandleCatches()).ManageExceptions(ex));
}
}
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));
}
//////////////////////////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]));
}
////////////////////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> 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]));
}
public async Task <IActionResult> ForgotPassword(FJC_ForgotPassword fJC_forgot)
{
//TypeOfUser attribute
//Scrutinizer - S, Investor - I, Company - C, Custodian - T, Corporate Shareholder - H, RTA - R
try
{
await ManageRecaptcha.ValidateUser(fJC_forgot.captcha);
var result = (DataTable)null;
if ((fJC_forgot.TypeOfUser == 'I' && fJC_forgot.TypeOfUpdate != 'E'))
{
if (!Regex.IsMatch(fJC_forgot.PAN_ID, @"^[a-zA-Z0-9]*$"))
{
throw new CustomException.InvalidPanPattern();
}
}
else //if(fJC_forgot.TypeOfUser == 'C' || fJC_forgot.TypeOfUser == 'R' || fJC_forgot.TypeOfUser == 'S' || fJC_forgot.TypeOfUser == 'T' || fJC_forgot.TypeOfUser == 'H')
{
fJC_forgot.PAN_ID = "XXXXX0000X";
}
if (fJC_forgot.TypeOfUser == 'I')
{
switch (fJC_forgot.TypeOfUpdate)
{
case 'D': //Date of birth cases
result = await _loginService.ForgotPassword_DOB_Data(fJC_forgot);
break;
case 'B': //Bank Account cases
result = await _loginService.ForgotPassword_BANK_ACC_Data(fJC_forgot);
break;
case 'E': //Email Cases
result = await _loginService.ForgotPasswordData(fJC_forgot);
break;
}
}
else
{
result = await _loginService.ForgotPasswordData(fJC_forgot);
}
return(Ok(Reformatter.Response_Object("Password reset successfully", ref result)));
}
catch (Exception ex)
{
return((new HandleCatches()).ManageExceptions(ex));
}
}
/// <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]));
}
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]));
}
//////////////////////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 //////////////////////////////
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]));
}
////////////////////////// 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> 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]));
}
public async Task <IActionResult> GetNotice(FJC_Notice fjc_notice)
{
try
{
var result = await _noticeService.GetNotice_Details(fjc_notice);
return(Ok(Reformatter.Response_ArrayObject("Notice details retrieved successfully", ref result)));
}
catch (Exception ex)
{
return((new HandleCatches()).ManageExceptions(ex));
}
}
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));
}
////////////////////////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 <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));
}
/////////////////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]));
}
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]));
}
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 <IActionResult> GetList([FromQuery] string str)
{
try
{
var result = await _listService.GetList_Details(str);
return(Ok(Reformatter.Response_ArrayObject("", ref result)));
}
catch (Exception ex)
{
return((new HandleCatches()).ManageExceptions(ex));
}
}
