public async Task <IActionResult> ROM(FJC_ROMUpload std)
{
try
{
var identity = (ClaimsIdentity)User.Identity;
var Token = Token_Handling.Get_Token_FromHeader(Request.Headers, identity);
var result = await _CustodianROMUploadService.Cutodian_ROMUpload_Details(std, Token);
return(Ok(Reformatter.Response_Object("File Uploaded successfully", ref result)));
}
catch (Exception ex)
{
return((new HandleCatches()).ManageExceptions(ex));
}
}
//////////////////////////////////////////ROM File Upload ////////////////////////////////////////////////////
public async Task <DataTable> Cutodian_ROMUpload_Details(FJC_ROMUpload fjc_ROMUpload, string Token)
{
//validation job
//Here Validate bulk file
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
dt1 = await RegisterCustodianROM(fjc_ROMUpload.event_id, fjc_ROMUpload.doc_id, Token, 0);
ManageErrorUploads dd = new ManageErrorUploads();
dt2 = dd.Manage_ROM_ErrorUploads(dt1, FolderPaths.ProcessType.Custodian_ROMUpload, fjc_ROMUpload.doc_id, fjc_ROMUpload.event_id, Token);
return(dt2);
}
//////////////////////////////////////////ROM File Upload ////////////////////////////////////////////////////
public async Task <DataTable> ROMUpload_Details(FJC_ROMUpload fjc_ROMUpload, string Token)
{
DataTable dtUserType = new DataTable();
dtUserType = await(new ManageFileUpload()).GetUserDetailsByTokenID(Token);
switch (fjc_ROMUpload.upload_type.ToLower())
{
//////////////////////////////ROM Intimation////////////////////////
case "intimation":
DataTable dt1 = new DataTable();
dt1 = await RegisterROM_Intimation(fjc_ROMUpload.event_id, fjc_ROMUpload.doc_id, Token, 0); // GetROMUpload_Details(Token);
if (dt1.Rows.Count > 0)
{
Validate_ROM val_ROM = new Validate_ROM();
bool isValid = val_ROM.Validate_File(dt1.Rows[0]["url"].ToString(), Token, fjc_ROMUpload.event_id, dt1.Rows[0]["upload_id"].ToString(), "Yes");
if (isValid)
{
// return await BulkUpload_ROM_Intimation(fjc_ROMUpload.event_id ,fjc_ROMUpload.doc_id, Token,dt1.Rows[0]["upload_id"].ToString());
DataTable dt = new DataTable();
dt = BulkUpload_ROM_Intimation(fjc_ROMUpload.event_id, fjc_ROMUpload.doc_id, Token, dt1.Rows[0]["upload_id"].ToString());
//return await InsertBulkFileUpload(fjc_ROMUpload.event_id ,fjc_ROMUpload.doc_id, Token,dt2.Rows[0]["upload_id"].ToString());
if (dt.Columns.Contains("Error_Num"))
{
ManageErrorUploads _err = new ManageErrorUploads();
DataTable dtSecROMErr = new DataTable();
//Below here return error datatble for second ROM upload file
switch (dtUserType.Rows[0]["type"])
{
case "Issuer Company":
dtSecROMErr = _err.Manage_ROM_ErrorUploads(dt, FolderPaths.ProcessType.Company_ROMUpload, 0, fjc_ROMUpload.event_id, Token);
break;
case "RTA":
dtSecROMErr = _err.Manage_ROM_ErrorUploads(dt, FolderPaths.ProcessType.RTA_ROMUpload, 0, fjc_ROMUpload.event_id, Token);
break;
}
if (dtSecROMErr.Rows.Count > 0)
{
DataTable dtget = new DataTable();
//Below here Register ROM for Error file for second ROM upload file
return(dtget = await RegisterROM_Intimation(fjc_ROMUpload.event_id, Convert.ToInt32(dtSecROMErr.Rows[0]["doc_id"]), Token, 0, "SecondROM", dt1.Rows[0]["upload_id"].ToString()));
}
else
{
return(null);
}
}
else
{
DataSet ds = new DataSet();
DataTable _dt = new DataTable();
_dt.TableName = "Table2";
_dt.Columns.Add("Remark");
ds.Tables.Add(_dt);
_dt.Rows.Add("Process Completed");
return(ds.Tables[0]);
}
}
else
{
return(null); // throw new CustomException.InvalidFileRejected();
}
}
else
{
return(null); //throw new CustomException.InvalidFileNotUploaded();
}
break;
//////////////////Normal ROM Upload ////////////////////////
case "notice":
//Here Validate bulk file
DataTable dt2 = new DataTable();
dt2 = await RegisterROM(fjc_ROMUpload.event_id, fjc_ROMUpload.doc_id, Token, 0); // GetROMUpload_Details(Token);
if (dt2.Rows.Count > 0)
{
Validate_ROM val_ROM = new Validate_ROM();
bool isValid = val_ROM.Validate_File(dt2.Rows[0]["url"].ToString(), Token, fjc_ROMUpload.event_id, dt2.Rows[0]["upload_id"].ToString(), "No"); //("C:\\evoting\\RTA\\ROM\\2020-09-18\\20200918-112617505-CDSL_FileUpload_128_ROM_ANUH_PHARMA_LTD_13220201.txt");//(dt1.Rows[0]["url"].ToString());
if (isValid)
{
//return await InsertBulkFileUpload(fjc_ROMUpload.event_id ,fjc_ROMUpload.doc_id, Token,dt2.Rows[0]["upload_id"].ToString());
DataTable dt = new DataTable();
dt = InsertBulkFileUpload(fjc_ROMUpload.event_id, fjc_ROMUpload.doc_id, Token, dt2.Rows[0]["upload_id"].ToString());
//return await InsertBulkFileUpload(fjc_ROMUpload.event_id ,fjc_ROMUpload.doc_id, Token,dt2.Rows[0]["upload_id"].ToString());
if (dt.Columns.Contains("Error_Num"))
{
ManageErrorUploads _err = new ManageErrorUploads();
DataTable dtSecROMErr = new DataTable();
//Below here return error datatble for second ROM upload file
switch (dtUserType.Rows[0]["type"])
{
case "Issuer Company":
dtSecROMErr = _err.Manage_ROM_ErrorUploads(dt, FolderPaths.ProcessType.Company_ROMUpload, 0, fjc_ROMUpload.event_id, Token);
break;
case "RTA":
dtSecROMErr = _err.Manage_ROM_ErrorUploads(dt, FolderPaths.ProcessType.RTA_ROMUpload, 0, fjc_ROMUpload.event_id, Token);
break;
}
if (dtSecROMErr.Rows.Count > 0)
{
DataTable dtget = new DataTable();
//Below here Register ROM for Error file for second ROM upload file
return(dtget = await RegisterROM(fjc_ROMUpload.event_id, Convert.ToInt32(dtSecROMErr.Rows[0]["doc_id"]), Token, 0, "SecondROM", dt2.Rows[0]["upload_id"].ToString()));
}
else
{
return(null);
}
}
else
{
DataSet ds = new DataSet();
DataTable _dt = new DataTable();
_dt.TableName = "Table1";
_dt.Columns.Add("Remark");
_dt.Rows.Add("Process Completed");
ds.Tables.Add(_dt);
return(ds.Tables[0]);
}
}
else
{
return(null); //throw new CustomException.InvalidFileRejected();
}
}
else
{
return(null); //throw new CustomException.InvalidFileNotUploaded();
}
break;
default:
throw new CustomException.InvalidActivity();
}
}
public async Task <dynamic> Post_Rom_Upload(FJC_ROMUpload fJC_ROM)
{
var get_url1 = await CommanUrl.ComRomUpload().WithHeader("Token", token).PostJsonAsync(fJC_ROM).ReceiveString();
return(JsonConvert.DeserializeObject <ExpandoObject>(get_url1, new ExpandoObjectConverter()));
}
