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"));
}
}
}
}
public ActionResult Index(int acid)
{
TempData.Remove("SearchArray");
LoginUserDetails objLoginUserDetails = null;
InsiderDashboardDTO objInsiderDashboardDTO = null;
UserInfoDTO objUserInfoDTO = null;
ApprovedPCLDTO objApprovedPCLDTO = null;
PasswordExpiryReminderDTO objPassExpiryReminderDTO = null;
DateTime CurrentDate;
ArrayList lst = new ArrayList();
UserPolicyDocumentEventLogDTO objChangePasswordEventLogDTO = null;
CompanyConfigurationDTO objCompanyConfigurationDTO = null;
int RequiredModuleID = 0;
int noOfDays = 0;
object path;
ViewBag.dupTransCnt = false;
ViewBag.ApprovedPCLCnt = false;
Common.Common.WriteLogToFile("Start Method", System.Reflection.MethodBase.GetCurrentMethod());
try
{
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
// check IsUserLogin flag in session, and set flag true -- this will indicate user is login and redirect here for first time
if (!objLoginUserDetails.IsUserLogin)
{
objLoginUserDetails.IsUserLogin = true;
Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails);
}
if (objLoginUserDetails.CompanyName == "DCBBank")
{
ViewBag.IsVisible = 0;
}
else
{
ViewBag.IsVisible = 1;
}
using (var objInsiderInitialDisclosureSL = new InsiderInitialDisclosureSL())
{
InsiderInitialDisclosureDTO objInsiderInitialDisclosureDTO = null;
objInsiderInitialDisclosureDTO = objInsiderInitialDisclosureSL.Get_mst_company_details(objLoginUserDetails.CompanyDBConnectionString);
RequiredModuleID = objInsiderInitialDisclosureDTO.RequiredModule;
}
objInsiderDashboardModel = new InsiderDashboardModel();
objInsiderDashboardModel.objInsiderDashboardOtherModel = new InsiderDashboardOtherModel();
switch (RequiredModuleID)
{
case ConstEnum.Code.RequiredModuleOwnSecurity:
ViewBag.RequiredModuleOwn = true;
ViewBag.RequiredModuleBoth = false;
ViewBag.RequiredModuleOther = false;
break;
case ConstEnum.Code.RequiredModuleOtherSecurity:
ViewBag.RequiredModuleOwn = false;
ViewBag.RequiredModuleBoth = false;
ViewBag.RequiredModuleOther = true;
objInsiderDashboardModel.objInsiderDashboardOtherModel = BindDashboardForOtherSecurities();
break;
case ConstEnum.Code.RequiredModuleBoth:
ViewBag.RequiredModuleOwn = true;
int?TradingPolicyID_OS;
//check other sericity model is applicable for user or not
InsiderInitialDisclosureDTO objInsiderInitialDisclosureDTO = null;
using (var objInsiderInitialDisclosureSL = new InsiderInitialDisclosureSL())
{
objInsiderInitialDisclosureDTO = objInsiderInitialDisclosureSL.Get_TradingPolicyID_forOS(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
TradingPolicyID_OS = objInsiderInitialDisclosureDTO.TradingPolicyID_OS;
}
if (TradingPolicyID_OS == null || TradingPolicyID_OS == 0)
{
ViewBag.RequiredModuleBoth = false;
ViewBag.RequiredModuleOther = false;
}
else
{
ViewBag.RequiredModuleBoth = true;
ViewBag.RequiredModuleOther = true;
}
objInsiderDashboardModel.objInsiderDashboardOtherModel = BindDashboardForOtherSecurities();
break;
}
if (objInsiderDashboardModel.objInsiderDashboardOtherModel.IsChangePassword)
{
Common.Common.SetSessionValue("IsChangePassword", true);
return(RedirectToAction("ChangePassword", "UserDetails", new { acid = Convert.ToString(Common.ConstEnum.UserActions.CHANGE_PASSWORD) }));
}
using (InsiderDashboardSL objInsiderDashboardSL = new InsiderDashboardSL())
{
objInsiderDashboardDTO = objInsiderDashboardSL.GetTradingCalenderDetails(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
if (objInsiderDashboardDTO.IsActivated == 1)
{
ViewBag.hideTrading = 0;
}
else
{
ViewBag.hideTrading = 1;
}
objInsiderDashboardDTO = objInsiderDashboardSL.GetDashboardDetails(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
Common.Common.CopyObjectPropertyByName(objInsiderDashboardDTO, objInsiderDashboardModel);
CurrentDate = Convert.ToDateTime(DateTime.Now.Date.ToString("dd/MM/yyyy"), System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);
objPassExpiryReminderDTO = objInsiderDashboardSL.GetPasswordExpiryReminder(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
if (objLoginUserDetails.LoggedInUserID == objPassExpiryReminderDTO.UserID &&
objPassExpiryReminderDTO.ValidityDate.Date >= CurrentDate &&
objPassExpiryReminderDTO.ExpiryReminderDate.Date <= CurrentDate)
{
if ((objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days == 1)
{
noOfDays = (objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days;
}
else
{
noOfDays = (objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days + 1;
}
lst.Add(noOfDays);
lst.Add(objPassExpiryReminderDTO.ValidityDate.Date.ToString("dd/MM/yyyy"));
ViewBag.PasswordReminderMsg = Common.Common.getResource("pc_msg_50569", lst);
}
else if (objPassExpiryReminderDTO.ValidityDate.Date < CurrentDate)
{
Common.Common.SetSessionValue("IsChangePassword", true);
return(RedirectToAction("ChangePassword", "UserDetails", new { acid = Convert.ToString(Common.ConstEnum.UserActions.CHANGE_PASSWORD) }));
}
}
using (UserInfoSL objUserInfoSL = new UserInfoSL())
{
objUserInfoDTO = objUserInfoSL.GetUserDetails(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
if (objUserInfoDTO.DateOfBecomingInsider != null)
{
ViewBag.InsiderTypeUser = 1;
}
else
{
ViewBag.InsiderTypeUser = 0;
}
}
int SecurityTypeCodeIdCnt = 0;
int TransactionTypeCodeIdCnt = 0;
int DateOfAcquisitionCnt = 0;
using (InsiderDashboardSL objInsiderDashboardSL = new InsiderDashboardSL())
{
List <DupTransCntDTO> lstDupTransCnt = objInsiderDashboardSL.Get_DupTransCnt(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
foreach (var dupTransCnt in lstDupTransCnt)
{
SecurityTypeCodeIdCnt = dupTransCnt.SecurityTypeCodeIdCnt;
TransactionTypeCodeIdCnt = dupTransCnt.TransactionTypeCodeIdCnt;
DateOfAcquisitionCnt = dupTransCnt.DateOfAcquisitionCnt;
}
}
if (SecurityTypeCodeIdCnt != 0 && TransactionTypeCodeIdCnt != 0 && DateOfAcquisitionCnt != 0)
{
ViewBag.dupTransCnt = true;
TempData["TradingTransactionModel"] = null;
TempData["DuplicateTransaction"] = null;
}
int localApprovedPCLCnt = 0;
using (TradingTransactionSL objTradingTransactionSL = new TradingTransactionSL())
{
List <ApprovedPCLDTO> lstApprovedPCLCnt = objTradingTransactionSL.GetApprovedPCLCntSL(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
foreach (var ApprovedPCLCnt in lstApprovedPCLCnt)
{
localApprovedPCLCnt = ApprovedPCLCnt.ApprovedPCLCnt;
}
}
if (localApprovedPCLCnt != 0)
{
ViewBag.ApprovedPCLCnt = true;
}
}
catch (Exception exp)
{
Common.Common.WriteLogToFile("Exception occurred ", System.Reflection.MethodBase.GetCurrentMethod(), exp);
}
finally
{
objLoginUserDetails = null;
objInsiderDashboardDTO = null;
objUserInfoDTO = null;
}
Common.Common.WriteLogToFile("End Method", System.Reflection.MethodBase.GetCurrentMethod());
return(View(objInsiderDashboardModel));
}
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));
}
}
