/// <summary>
///
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <param name="i_nUserInfoId"></param>
/// <param name="o_nReturnValue"></param>
/// <param name="o_nErroCode"></param>
/// <param name="o_sErrorMessage"></param>
/// <returns></returns>
public List <TradingTransactionMasterDTO> Get_CDTransIdduringPE(TradingTransactionMasterDTO objTradingTransactionMasterDTO, string i_sConnectionString, bool cdDuringPE)
{
List <TradingTransactionMasterDTO> lstTransId = new List <TradingTransactionMasterDTO>();
try
{
using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
{
lstTransId = objTradingTransactionDAL.GetCDTransIdduringPE(objTradingTransactionMasterDTO, i_sConnectionString, cdDuringPE).ToList <TradingTransactionMasterDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstTransId);
}
/// <summary>
///
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <param name="i_nUserInfoId"></param>
/// <param name="o_nReturnValue"></param>
/// <param name="o_nErroCode"></param>
/// <param name="o_sErrorMessage"></param>
/// <returns></returns>
public List <TradingTransactionMasterDTO> Get_PanNumber(TradingTransactionMasterDTO objTradingTransactionMasterDTO, string i_sConnectionString)
{
List <TradingTransactionMasterDTO> lstPanNo = new List <TradingTransactionMasterDTO>();
try
{
using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
{
lstPanNo = objTradingTransactionDAL.GetPanNumber(objTradingTransactionMasterDTO, i_sConnectionString).ToList <TradingTransactionMasterDTO>();
}
}
catch (Exception exp)
{
throw exp;
}
return(lstPanNo);
}
public ActionResult Summary(int acid, int period, int year, int pdtype, int uid = 0, int tmid = 0)
{
LoginUserDetails objLoginUserDetails = null;
UserInfoDTO objUserInfoDTO = null;
ViewBag.showAddTransactionBtn = false;
DateTime dtEndDate = DateTime.Now;
Dictionary <string, object> dicPeriodStartEnd = null;
try
{
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
//set activity id for summary page as this page is access from both menu - insider and CO
ViewBag.activity_id = acid;
using (PeriodEndDisclosureSL objPeriodEndDisclosure = new PeriodEndDisclosureSL())
{
dicPeriodStartEnd = objPeriodEndDisclosure.GetPeriodStarEndDate(objLoginUserDetails.CompanyDBConnectionString, year, period, pdtype);
DateTime dtStartDate = Convert.ToDateTime(dicPeriodStartEnd["start_date"]);
dtEndDate = Convert.ToDateTime(dicPeriodStartEnd["end_date"]);
String dtFormat = "dd MMM yyyy";
ViewBag.Period = dtStartDate.ToString(dtFormat) + " - " + dtEndDate.ToString(dtFormat);
}
//set input vaules for period end summary grid
ViewBag.UserId = (uid == 0) ? objLoginUserDetails.LoggedInUserID : uid;
ViewBag.YearCode = year;
ViewBag.PeriodCode = period;
ViewBag.PeriodType = pdtype;
ViewBag.TransactionMasterId = (tmid == 0) ? "" : tmid.ToString();
ViewBag.GridType = ConstEnum.GridType.PeriodEndDisclosurePeriodSummary;
//if activity id is for CO then fetch employee insider details
if (acid == ConstEnum.UserActions.CO_DISCLOSURE_DETAILS_PERIOD_END_DISCLOSURE)
{
using (UserInfoSL objUserInfoSL = new UserInfoSL())
{
objUserInfoDTO = objUserInfoSL.GetUserDetails(objLoginUserDetails.CompanyDBConnectionString, uid);
ViewBag.EmployeeId = objUserInfoDTO.EmployeeId;
ViewBag.InsiderName = (objUserInfoDTO.UserTypeCodeId == ConstEnum.Code.CorporateUserType) ? objUserInfoDTO.CompanyName : objUserInfoDTO.FirstName + " " + objUserInfoDTO.LastName;
}
}
}
catch (Exception ex)
{
}
finally
{
dicPeriodStartEnd = null;
//objLoginUserDetails = null;
objUserInfoDTO = null;
}
int contDisStatusCount = 0;
int PEDisStatusCount = 0;
int IsIDPending = 0;
using (TradingTransactionSL objTradingTransactionSL = new TradingTransactionSL())
{
acid = ConstEnum.UserActions.INSIDER_DISCLOSURE_DETAILS_PERIOD_END_DISCLOSURE;
year = 0;
List <ContinuousDisclosureStatusDTO> lstConDisclosureStatus = objTradingTransactionSL.Get_ContinuousDisclosureStatus(objLoginUserDetails.CompanyDBConnectionString, uid, dtEndDate);
foreach (var contDisStatus in lstConDisclosureStatus)
{
contDisStatusCount = contDisStatus.ContDisPendingStatus;
}
if (contDisStatusCount > 0)
{
int ContDisCheck = contDisStatusCount;
return(RedirectToAction("PeriodStatus", "PeriodEndDisclosure", new { acid, year, uid, ContDisCheck }));
}
else
{
List <ContinuousDisclosureStatusDTO> lstPEDisclosureStatus = objTradingTransactionSL.Get_PEDisclosureStatus(objLoginUserDetails.CompanyDBConnectionString, uid, dtEndDate);
foreach (var periodEndStatus in lstPEDisclosureStatus)
{
PEDisStatusCount = periodEndStatus.PEDisPendingStatus;
IsIDPending = periodEndStatus.IsRelativeFound;
}
if (IsIDPending > 0)
{
return(RedirectToAction("PeriodStatus", "PeriodEndDisclosure", new { acid, year, uid, PEDisStatusCount, IsIDPending }));
}
else if (PEDisStatusCount > 0)
{
int PeriodEndDisCheck = PEDisStatusCount;
return(RedirectToAction("PeriodStatus", "PeriodEndDisclosure", new { acid, year, uid, PeriodEndDisCheck }));
}
else
{
TradingTransactionMasterDTO objTradingTransactionMasterDTO = null;
objTradingTransactionMasterDTO = new TradingTransactionMasterDTO();
objTradingTransactionMasterDTO = objTradingTransactionSL.GetTradingTransactionMasterDetails(objLoginUserDetails.CompanyDBConnectionString, tmid);
if (objTradingTransactionMasterDTO.TransactionStatusCodeId == 148002)
{
ViewBag.showAddTransactionBtn = true;
}
return(View("Summary"));
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <param name="i_nUserInfoId"></param>
/// <param name="o_nReturnValue"></param>
/// <param name="o_nErroCode"></param>
/// <param name="o_sErrorMessage"></param>
/// <returns></returns>
public InsiderTradingDAL.TradingTransactionMasterDTO GetTradingTransactionMasterCreate(string i_sConnectionString,
TradingTransactionMasterDTO objTradingTransactionMasterDTO, int i_nLoggedInUserId, out int o_iDisclosureCompletedFlag)
{
InsiderTradingDAL.TradingTransactionMasterDTO res = null;
try
{
//InsiderTradingDAL.TradingTransactionDAL objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL();
using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
{
res = objTradingTransactionDAL.GetTransactionMasterCreate(i_sConnectionString, objTradingTransactionMasterDTO, i_nLoggedInUserId, out o_iDisclosureCompletedFlag);
}
}
catch (Exception exp)
{
throw exp;
}
return(res);
}
public ActionResult Save(InsiderTrading.Models.NSEGroupDocumentMappingModel objNSEGroupDocumentModel, Dictionary <int, List <DocumentDetailsModel> > dicPolicyDocumentsUploadFileList, int GroupId)
{
ModelState.Remove("KEY");
ModelState.Add("KEY", new ModelState());
ModelState.Clear();
var StockExchangeDateSubmission = Request.Form["SubmissionFromDate"];
LoginUserDetails objLoginUserDetails = null;
DocumentDetailsSL objDocumentDetailsSL = new DocumentDetailsSL();
List <DocumentDetailsModel> UploadFileDocumentDetailsModelList = null;
NSEGroupDocumentMappingDTO objNSEGroupDocDTO = new NSEGroupDocumentMappingDTO();
NSEGroupDetailsDTO objNSEGroupDetailsDTO = new NSEGroupDetailsDTO();
NSEGroupDTO objNSEGroupDTO = new NSEGroupDTO();
objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
DateTime?date = null;
using (NSEGroupSL ObjNSEGroupSL = new NSEGroupSL())
{
List <NSEGroupDTO> lstDate = ObjNSEGroupSL.Get_Group_Date(objLoginUserDetails.CompanyDBConnectionString, GroupId);
foreach (var submitdate in lstDate)
{
date = submitdate.DownloadedDate;
}
}
if (StockExchangeDateSubmission == "")
{
ModelState.AddModelError("DateOfSubmissionToNSE", Common.Common.getResource("nse_lbl_50535"));
}
else
{
objNSEGroupDTO.SubmissionDate = Convert.ToDateTime(StockExchangeDateSubmission);
if (objNSEGroupDTO.SubmissionDate > Common.Common.GetCurrentDate(objLoginUserDetails.CompanyDBConnectionString))
{
ModelState.AddModelError("DateOfSubmissionToNSE", Common.Common.getResource("nse_lbl_50534"));
}
if (Convert.ToDateTime(date).Date > objNSEGroupDTO.SubmissionDate)
{
ModelState.AddModelError("DateOfSubmissionToNSE", Common.Common.getResource("nse_lbl_50536"));
}
}
if (ModelState.IsValid)
{
if (dicPolicyDocumentsUploadFileList.Count > 0) // file is uploaded and data found for file upload
{
UploadFileDocumentDetailsModelList = dicPolicyDocumentsUploadFileList[ConstEnum.Code.UploadNseDocument];
}
List <DocumentDetailsModel> objSavedDocumentDetialsModelList = objDocumentDetailsSL.SaveDocumentDetails(objLoginUserDetails.CompanyDBConnectionString, UploadFileDocumentDetailsModelList, ConstEnum.Code.UploadNseDocument, GroupId, objLoginUserDetails.LoggedInUserID, objLoginUserDetails.CompanyName);
DocumentDetailsDTO objDocumentDetailsDTO = null;
objDocumentDetailsDTO = new DocumentDetailsDTO();
using (NSEGroupSL objNSEGroupSL = new NSEGroupSL())
{
if (UploadFileDocumentDetailsModelList != null)
{
foreach (var fleGUID in UploadFileDocumentDetailsModelList)
{
objNSEGroupDetailsDTO.LoggedInUserId = objLoginUserDetails.LoggedInUserID;
objNSEGroupDetailsDTO.GroupId = GroupId;
List <NSEGroupDetailsDTO> GrouplistDetails = objNSEGroupSL.Save_NSEGroup_Details(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDetailsDTO);
foreach (var nseuserId in GrouplistDetails)
{
objNSEGroupDocDTO.NSEGroupDetailsId = nseuserId.NSEGroupDetailsId;
objNSEGroupDetailsDTO.GroupId = Convert.ToInt32(GroupId);
bool bReturnDoc = objNSEGroupSL.Save_New_NSEDocument(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDocDTO, fleGUID.GUID);
}
}
}
objNSEGroupDTO.GroupId = GroupId;
objNSEGroupDTO.LoggedInUserId = objLoginUserDetails.LoggedInUserID;
objNSEGroupDTO.StatusCodeId = 508007;
bool bReturn = objNSEGroupSL.Update_NSEGroup(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDTO);
}
TradingTransactionMasterDTO objTradingTransactionMasterDTO = null;
using (TradingTransactionSL objTradingTransactionSL = new TradingTransactionSL())
{
using (NSEGroupSL objNSEGroupSL = new NSEGroupSL())
{
List <NSEGroupDetailsDTO> grpTransIdList = objNSEGroupSL.Get_Group_TransactionId(objLoginUserDetails.CompanyDBConnectionString, GroupId);
foreach (var TransId in grpTransIdList)
{
objTradingTransactionMasterDTO = new TradingTransactionMasterDTO();
objTradingTransactionMasterDTO.TransactionMasterId = TransId.transId;
objTradingTransactionMasterDTO.TransactionStatusCodeId = ConstEnum.Code.DisclosureStatusForHardCopySubmittedByCO;
objTradingTransactionMasterDTO.HardCopyByCOSubmissionDate = Convert.ToDateTime(StockExchangeDateSubmission);
objTradingTransactionMasterDTO = objTradingTransactionSL.GetTradingTransactionMasterCreate(objLoginUserDetails.CompanyDBConnectionString, objTradingTransactionMasterDTO, objLoginUserDetails.LoggedInUserID, out nDisclosureCompletedFlag);
}
}
}
return(RedirectToAction("Index", "NSEDownload", new { acid = ConstEnum.UserActions.NSEDownload }));
}
else
{
ViewBag.groupId = GroupId;
ViewBag.DownloadDate = date;
ViewBag.UserAction = Common.ConstEnum.UserActions.NSEDownload;
objNSEGroupDocumentModel.NSEGroupDocumentFile = Common.Common.GenerateDocumentList(ConstEnum.Code.UploadNseDocument, 0, 0, null, 0, false, 0, ConstEnum.FileUploadControlCount.NSEUploadFile);
return(View("NSEUploadDoc", objNSEGroupDocumentModel));
}
}
