/// <summary>
/// This function will return all the mass uploaded from the system, this is to show all the mass uploads on the AllMass uploads pages
/// </summary>
/// <returns></returns>
private List <MassUploadDTO> GetAllMassUpload()
{
List <MassUploadDTO> lstMassUploadDTO = new List <MassUploadDTO>();
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)Common.ConstEnum.SessionValue.UserDetails);
try
{
using (var objMassUploadSL = new MassUploadSL())
{
lstMassUploadDTO = objMassUploadSL.GetAllMassUpload(objLoginUserDetails.CompanyDBConnectionString);
}
}
catch (Exception exp)
{
}
return(lstMassUploadDTO);
}
/// <summary>
///
/// </summary>
/// <param name="SelectedParentId"></param>
/// <returns></returns>
public ActionResult SetSession(string SelectedParentId)
{
Common.Common.WriteLogToFile("Start Method", System.Reflection.MethodBase.GetCurrentMethod());
LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
objLoginUserDetails.SelectedParentID = SelectedParentId;
objLoginUserDetails.SelectedChildId = "";
Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails);
objLoginUserDetails = null;
Common.Common.WriteLogToFile("End Method", System.Reflection.MethodBase.GetCurrentMethod());
return(this.Json(new { success = true }));
}
public FileStreamResult Download(int nDocumentDetailsID, string GUID, string sDocumentName, string sFileType, int acid)
{
string directory = ConfigurationManager.AppSettings["Document"];
string sExtension = "";
LoginUserDetails objLoginUserDetails = null;
DocumentDetailsDTO objDocumentDetailsDTO = null;
try
{
if (nDocumentDetailsID == 0)
{
directory = Path.Combine(directory, "temp", GUID);
if (System.IO.File.Exists(directory))
{
return(File(new FileStream(directory, FileMode.Open), sFileType, sDocumentName));
}
}
else
{
objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
using (DocumentDetailsSL objDocumentDetailsSL = new DocumentDetailsSL())
{
objDocumentDetailsDTO = objDocumentDetailsSL.GetDocumentDetails(objLoginUserDetails.CompanyDBConnectionString, nDocumentDetailsID);
/*For user document, extensions are not stored in the file name, so that are to be explicitly concatenated */
if (objDocumentDetailsDTO.MapToTypeCodeId == ConstEnum.Code.UserDocument)
{
sExtension = objDocumentDetailsDTO.FileType;
}
directory = Path.Combine(directory, Common.Common.ConvertToString(objDocumentDetailsDTO.MapToTypeCodeId), Common.Common.ConvertToString(objDocumentDetailsDTO.MapToId), objDocumentDetailsDTO.GUID);
if (System.IO.File.Exists(directory))
{
return(File(new FileStream(directory, FileMode.Open), objDocumentDetailsDTO.FileType, objDocumentDetailsDTO.DocumentName + sExtension /*+ objDocumentDetailsDTO.FileType*/));
}
}
}
}
finally
{
objLoginUserDetails = null;
objDocumentDetailsDTO = null;
}
return(null);
}
public ActionResult DownloadTemplateExcel(int acid, string MassUploadId, string Type = "xls")
{
string sExportDocumentPath = ConfigurationManager.AppSettings["Document"] + "Templates/MassUpload/";
string[] sFilesfromExportFolder = Directory.GetFiles(sExportDocumentPath);
LoginUserDetails objLoginUserDetails = null;
string sDownloadfileName = "";
//MassUploadSL objMassUploadSL = new MassUploadSL();
MassUploadDTO objMassUploadDTO = null;
if (MassUploadId == "")
{
MassUploadId = "0";
}
try
{
objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)InsiderTrading.Common.ConstEnum.SessionValue.UserDetails);
if (MassUploadId == "0")
{
return(RedirectToAction("AllMassUpload", "MassUpload",
new { acid = Common.ConstEnum.UserActions.MASSUPLOAD_LIST }).
Warning(HttpUtility.UrlEncode("Template file is missing, please contact the Administrator.")));
}
using (var objMassUploadSL = new MassUploadSL())
{
objMassUploadDTO = objMassUploadSL.GetSingleMassUploadDetails(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(MassUploadId));
}
sDownloadfileName = objMassUploadDTO.TemplateFileName;
string sFilePathToDownload = sExportDocumentPath + sDownloadfileName + "." + Type;
return(File(new FileStream(sFilePathToDownload, FileMode.Open), "." + Type, sDownloadfileName + "." + Type));
}
catch (Exception exp)
{
string sErrorMessage = exp.Message;
return(RedirectToAction("AllMassUpload", "MassUpload",
new { acid = Common.ConstEnum.UserActions.MASSUPLOAD_LIST }).
Warning(HttpUtility.UrlEncode("Template file is missing, please contact the Administrator.")));
}
finally
{
objLoginUserDetails = null;
objMassUploadDTO = null;
}
}
public JsonResult Autocomplete(string sSearchString)
{
LoginUserDetails objLoginUserDetails = null;
try
{
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
var suggestions = Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.DesignationList, null, null, null, null, null, sLookUpPrefix);
var result = suggestions.Where(s => s.Value.ToLower().Contains(sSearchString.ToLower())).Select(w => w).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
finally
{
objLoginUserDetails = null;
}
}
public void CaptchaValidation(ActionExecutingContext filterContext)
{
LoginUserDetails objLoginUserDetails = null;
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
string strServerPath = string.Empty;
using (ImageGenrator generateImage = new ImageGenrator())
{
using (Image image = generateImage.DrawText(ref ActualText))
{
strServerPath = ConfigurationManager.AppSettings["Document"].ToString() + @"captcha\";
if (!Directory.Exists(strServerPath))
{
Directory.CreateDirectory(strServerPath);
}
string captchaImage = Guid.NewGuid().ToString() + ".png";
image.Save(strServerPath + captchaImage, ImageFormat.Png);
filterContext.HttpContext.Session["CaptchaValue"] = ActualText;
string strImagePath = string.Empty;
strImagePath = strServerPath;
strImagePath = HttpRuntime.AppDomainAppVirtualPath.ToString().ToUpper() + "" + strImagePath.Substring(strImagePath.IndexOf("Document")).Replace("\\", "/");
string ImagePath = strImagePath + captchaImage;
//string ImagePath = strServerPath + captchaImage;
filterContext.HttpContext.Session["CaptchaPath"] = ImagePath;
filterContext.HttpContext.Session["CaptchaFileName"] = captchaImage;
}
string CaptchaDirServerPath = string.Empty;
CaptchaDirServerPath = strServerPath;
filterContext.HttpContext.Session["SerCaptchaPath"] = CaptchaDirServerPath;
objLoginUserDetails = new LoginUserDetails();
objLoginUserDetails.IsAccountValidated = false;
Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails);
filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary {
{ "controller", "Account" }, { "action", "Login" }
});
}
}
private InsiderDashboardOtherModel BindDashboardForOtherSecurities()
{
LoginUserDetails objLoginUserDetails = null;
InsiderDashboardDTO_OS objInsiderDashboardDTO_OS = null;
UserInfoDTO objUserInfoDTO = null;
ApprovedPCLDTO objApprovedPCLDTO = null;
PasswordExpiryReminderDTO objPassExpiryReminderDTO = null;
DateTime CurrentDate;
ArrayList lst = new ArrayList();
UserPolicyDocumentEventLogDTO objChangePasswordEventLogDTO = null;
CompanyConfigurationDTO objCompanyConfigurationDTO = null;
int noOfDays;
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
using (InsiderDashboardSL_OS objInsiderDashboardSL_OS = new InsiderDashboardSL_OS())
{
objInsiderDashboardDTO_OS = objInsiderDashboardSL_OS.GetDashboardDetails_OS(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
Common.Common.CopyObjectPropertyByName(objInsiderDashboardDTO_OS, objInsiderDashboardModel.objInsiderDashboardOtherModel);
CurrentDate = Convert.ToDateTime(DateTime.Now.Date.ToString("dd/MM/yyyy"), System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);
objPassExpiryReminderDTO = objInsiderDashboardSL_OS.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)
{
objInsiderDashboardModel.objInsiderDashboardOtherModel.IsChangePassword = true;
}
}
return(objInsiderDashboardModel.objInsiderDashboardOtherModel);
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
try
{
int RedirectionType;
object path = null;
string sController = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName;
string sAction = filterContext.ActionDescriptor.ActionName;
string ControllerAction = sController + sAction;
int ValidationType = ConstEnum.ValidateTo[ControllerAction];
int LoggenInUserId = objLoginUserDetails.LoggedInUserID;
CommonDAL objCommonDAL = new CommonDAL();
CommonModel objCommonModel = new CommonModel();
CommonDTO objCommonDTO = new CommonDTO();
objCommonDTO = objCommonDAL.InitialChecks(objLoginUserDetails.CompanyDBConnectionString, ValidationType, LoggenInUserId, out RedirectionType);
if (RedirectionType != 0)
{
path = ConstEnum.Redirect[RedirectionType];
var sType = path.GetType();
var values = new System.Web.Routing.RouteValueDictionary();
foreach (var prop in sType.GetProperties(BindingFlags.Public | BindingFlags.Instance))
{
values.Add(prop.Name, Convert.ToString(prop.GetValue(path, null)));
}
if (objCommonDTO != null)
{
var sourceType = objCommonDTO.GetType();
foreach (var property in sourceType.GetProperties(BindingFlags.Public | BindingFlags.Instance))
{
if (Convert.ToString(property.GetValue(objCommonDTO, null)) != null && Convert.ToString(property.GetValue(objCommonDTO, null)) != "")
{
values.Add(property.Name, Convert.ToString(property.GetValue(objCommonDTO, null)));
}
}
}
filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(values));
}
}
catch (Exception exp)
{
throw exp;
}
}
public ActionResult Delete(int RoleId, int acid)
{
bool statusFlag = false;
var ErrorDictionary = new Dictionary <string, string>();
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
RoleMasterSL objRoleMasterSL = new RoleMasterSL();
RoleMasterModel objRoleMasterModel = new RoleMasterModel();
List <PopulateComboDTO> lstList = new List <PopulateComboDTO>();
try
{
bool result = objRoleMasterSL.DeleteRoleMasterDetails(objLoginUserDetails.CompanyDBConnectionString, RoleId, objLoginUserDetails.LoggedInUserID);
//return RedirectToAction("Index", "RoleMaster", new { acid = InsiderTrading.Common.ConstEnum.UserActions.CRUSER_ROLEMASTER_VIEW }).Success("Role deleted successfully.");//Common.Common.getResource("tra_msg_12054"));
statusFlag = true;
ErrorDictionary.Add("success", Common.Common.getResource("usr_msg_12054"));
}
catch (Exception exp)
{
lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.RoleStatus).ToString(), null, null, null, null, true);
ViewBag.RoleStatus = lstList;
lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.UserType).ToString(), null, null, null, null, true);
ViewBag.UserType = lstList;
FillGrid(ConstEnum.GridType.RoleMasterList, null, null, null);
ModelState.Remove("KEY");
ModelState.Add("KEY", new ModelState());
ModelState.Clear();
string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString());
ModelState.AddModelError("error", sErrMessage);
ErrorDictionary = GetModelStateErrorsAsString();
}
finally
{
objLoginUserDetails = null;
objRoleMasterSL = null;
objRoleMasterModel = null;
lstList = null;
}
return(Json(new
{
status = statusFlag,
Message = ErrorDictionary
}, JsonRequestBehavior.AllowGet));
}
public ActionResult SetChildSession(string SelectedChildId)
{
Common.Common.WriteLogToFile("Start Method", System.Reflection.MethodBase.GetCurrentMethod());
LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
bool bReturn = false;
if (objLoginUserDetails != null)
{
objLoginUserDetails.SelectedChildId = SelectedChildId;
Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails);
bReturn = true;
}
Common.Common.WriteLogToFile("End Method", System.Reflection.MethodBase.GetCurrentMethod());
return(this.Json(new { success = bReturn }));
}
public ActionResult Accept(UsersPolicyDocumentModel objUsersPolicyDocumentModel, int acid)
{
bool bReturn = false;
UserPolicyDocumentEventLogModel objUserPolicyDocumentEventLogModel = new UserPolicyDocumentEventLogModel();
UserPolicyDocumentEventLogDTO objUserPolicyDocumentEventLogDTO = new UserPolicyDocumentEventLogDTO();
InsiderInitialDisclosureSL objInsiderInitialDisclosureSL = new InsiderInitialDisclosureSL();
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
InsiderInitialDisclosureDTO objInsiderInitialDisclosureDTO = null;
try
{
objUserPolicyDocumentEventLogModel.EventCodeId = ConstEnum.Code.PolicyDocumentAgreed;
objUserPolicyDocumentEventLogModel.MapToTypeCodeId = ConstEnum.Code.PolicyDocument;
objUserPolicyDocumentEventLogModel.MapToId = objUsersPolicyDocumentModel.PolicyDocumentId;
Common.Common.CopyObjectPropertyByName(objUserPolicyDocumentEventLogModel, objUserPolicyDocumentEventLogDTO);
bReturn = objInsiderInitialDisclosureSL.SaveEvent(objLoginUserDetails.CompanyDBConnectionString, objUserPolicyDocumentEventLogDTO, objLoginUserDetails.LoggedInUserID);
if (bReturn)
{
objInsiderInitialDisclosureDTO = objInsiderInitialDisclosureSL.GetInitialDisclosureDetails(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID).FirstOrDefault();
}
if (objInsiderInitialDisclosureDTO.EventDate != null)
{
return(RedirectToAction("List", "InsiderInitialDisclosure", new { acid = ConstEnum.UserActions.INSIDER_DISCLOSURE_DETAILS_POLICY_DOCUMENT_LIST }).Success(InsiderTrading.Common.Common.getResource("dis_grd_17452")));//"Policy is accepted.");
}
else
{
return(RedirectToAction("Index", "InsiderInitialDisclosure", new { acid = ConstEnum.UserActions.INSIDER_DISCLOSURE_DETAILS_INITIAL_DISCLOSURE, ReqModuleId = objUsersPolicyDocumentModel.RequiredModuleID }).Success(InsiderTrading.Common.Common.getResource("dis_grd_17452")));//"Policy is accepted.");
}
}
catch
{
return(View());
}
finally
{
objUserPolicyDocumentEventLogModel = null;
objUserPolicyDocumentEventLogDTO = null;
objInsiderInitialDisclosureSL = null;
objLoginUserDetails = null;
}
}
public JsonResult DeleteDocumentDetails(int acid, int nDocumentDetailsID, string sGUID, int nMapToTypeCodeId = 0, int nMapToId = 0, int nPurposeCodeId = 0)
{
bool bReturn = false;
bool statusFlag = false;
var ErrorDictionary = new Dictionary <string, string>();
LoginUserDetails objLoginUserDetails = null;
try
{
objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
using (DocumentDetailsSL objDocumentDetailsSL = new DocumentDetailsSL())
{
bReturn = objDocumentDetailsSL.DeleteDocumentDetails(objLoginUserDetails.CompanyDBConnectionString, nDocumentDetailsID, objLoginUserDetails.LoggedInUserID, nMapToTypeCodeId, nMapToId, nPurposeCodeId);
if (bReturn)
{
string directory = ConfigurationManager.AppSettings["Document"];
FileInfo file = new FileInfo(Path.Combine(directory, nMapToTypeCodeId.ToString(), nMapToId.ToString(), sGUID));
file.Delete();
statusFlag = true;
ErrorDictionary.Add("success", "Record deleted");
}
}
}
catch (Exception exp)
{
ModelState.Remove("KEY");
ModelState.Add("KEY", new ModelState());
ModelState.Clear();
string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString());
ModelState.AddModelError("error", sErrMessage);
}
finally
{
objLoginUserDetails = null;
}
return(Json(new
{
status = statusFlag,
Message = ErrorDictionary
}, "text/html"));
}
public ActionResult ShowUserConsent(int acid, int DocumentID)
{
DocumentDetailsSL objDocumentDetailsSL = null;
EULAAcceptanceModel objEULAAcceptanceModel = new EULAAcceptanceModel();
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
DocumentDetailsDTO objDocumentDetailsDTO = new DocumentDetailsDTO();
try
{
objDocumentDetailsSL = new DocumentDetailsSL();
//check if document has uploaded or not -- by checking document id - in case of not uploaded document id is "0"
if (DocumentID > 0)
{
objDocumentDetailsDTO = objDocumentDetailsSL.GetDocumentDetails(objLoginUserDetails.CompanyDBConnectionString, DocumentID);
}
//copy document details DTO into User policy document model
objEULAAcceptanceModel.DocumentID = objDocumentDetailsDTO.DocumentId;
objEULAAcceptanceModel.DocumentName = objDocumentDetailsDTO.DocumentName;
objEULAAcceptanceModel.DocumentFileType = objDocumentDetailsDTO.FileType;
objEULAAcceptanceModel.DocumentPath = objDocumentDetailsDTO.DocumentPath;
objEULAAcceptanceModel.UserInfoID = objLoginUserDetails.LoggedInUserID;
objEULAAcceptanceModel.EULAAcceptanceFlag = false;
ViewBag.UserAction = acid;
return(View("~/Views/UserDetails/UserConsent.cshtml", objEULAAcceptanceModel));
}
catch (Exception ex)
{
string sErrMessage = Common.Common.getResource(ex.InnerException.Data[0].ToString());
ModelState.AddModelError("Error", sErrMessage);
return(View("~/Views/UserDetails/UserConsent.cshtml"));
}
finally
{
objDocumentDetailsSL = null;
objEULAAcceptanceModel = null;
objLoginUserDetails = null;
objDocumentDetailsDTO = null;
}
}
private void PopulateCombo()
{
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
PopulateComboDTO objPopulateComboDTO = new PopulateComboDTO();
objPopulateComboDTO.Key = "";
objPopulateComboDTO.Value = "Select";
List <PopulateComboDTO> lstMCQ_StatusList = new List <PopulateComboDTO>();
lstMCQ_StatusList.Add(objPopulateComboDTO);
lstMCQ_StatusList.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.ListOfCode,
Convert.ToInt32(ConstEnum.CodeGroup.MCQStatus).ToString(), null, null, null, null, "usr_msg_").ToList <PopulateComboDTO>());
ViewBag.MCQ_Status = lstMCQ_StatusList;
lstMCQ_StatusList = null;
}
public ActionResult List(int acid)
{
InsiderInitialDisclosureCountDTO objInsiderInitialDisclosureCountDTO = null;
InsiderInitialDisclosureCountModel objInsiderInitialDisclosureCountModel = null;
LoginUserDetails objLoginUserDetails = null;
try
{
objInsiderInitialDisclosureCountModel = new InsiderInitialDisclosureCountModel();
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
using (InsiderInitialDisclosureSL objInsiderInitialDisclosureSL = new InsiderInitialDisclosureSL())
{
objInsiderInitialDisclosureCountDTO = objInsiderInitialDisclosureSL.GetDashBoardInsiderCount(objLoginUserDetails.CompanyDBConnectionString);
Common.Common.CopyObjectPropertyByName(objInsiderInitialDisclosureCountDTO, objInsiderInitialDisclosureCountModel);
}
if (objLoginUserDetails.BackURL != null && objLoginUserDetails.BackURL != "")
{
ViewBag.BackButton = true;
ViewBag.BackURL = objLoginUserDetails.BackURL;
objLoginUserDetails.BackURL = "";
Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails);
}
else
{
ViewBag.BackButton = false;
}
return(View(objInsiderInitialDisclosureCountModel));
}
catch (Exception exp)
{
string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString());
ModelState.AddModelError("Error", sErrMessage);
return(View("Index"));
}
finally
{
objLoginUserDetails = null;
}
}
public ActionResult Index(int acid, int PendingPeriodEndCount = 0, int PendingTransactionsCountPNT = 0, int PendingTransactionsCountPCL = 0)
{
LoginUserDetails objLoginUserDetails = null;
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
@ViewBag.UserInfoId = objLoginUserDetails.LoggedInUserID;
ViewBag.HoldingForList = FillComboValues(ConstEnum.ComboType.ListOfCode, InsiderTrading.Common.ConstEnum.CodeGroup.PreclearanceRequestor, null, null, null, null, false);
ViewBag.SecurityTypeList = FillComboValues(ConstEnum.ComboType.ListOfCode, InsiderTrading.Common.ConstEnum.CodeGroup.SecurityType, null, null, null, null, false);
if (PendingPeriodEndCount > 0)
{
ModelState.AddModelError("HoldingList", Common.Common.getResource("usr_msg_11470"));
}
if (PendingTransactionsCountPNT > 0 || PendingTransactionsCountPCL > 0)
{
ModelState.AddModelError("HoldingList", Common.Common.getResource("usr_msg_11467"));
}
return(View("HoldingList"));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult Create(int nUserInfoID = 0)
{
LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
EmployeeModel objEmployeeModel = new EmployeeModel();
UserInfoModel objUserInfoModel = new UserInfoModel();
DMATDetailsModel objDMATDetailsModel = new DMATDetailsModel();
DocumentDetailsModel objDocumentDetailsModel = new DocumentDetailsModel();
UserInfoSL objUserInfoSL = new UserInfoSL();
try
{
if (nUserInfoID != 0)
{
UserInfoDTO objUserInfoDTO = new UserInfoDTO();
objUserInfoDTO = objUserInfoSL.GetUserDetails(objLoginUserDetails.CompanyDBConnectionString, nUserInfoID);
string sPwdMask = "●●●●●●●●●●●●●";
objUserInfoDTO.Password = sPwdMask.PadRight(15, '●');
Common.Common.CopyObjectPropertyByName(objUserInfoDTO, objUserInfoModel);
objDMATDetailsModel.UserInfoID = nUserInfoID;
}
objEmployeeModel.userInfoModel = objUserInfoModel;
objEmployeeModel.dmatDetailsModel = objDMATDetailsModel;
objEmployeeModel.documentDetailsModel = objDocumentDetailsModel;
PopulateCombo();
return(View("Create", objEmployeeModel));
}
catch (Exception exp)
{
string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString());
ModelState.AddModelError("Error", sErrMessage);
return(View("Create", objEmployeeModel));
}
finally
{
objLoginUserDetails = null;
objEmployeeModel = null;
objUserInfoModel = null;
objDMATDetailsModel = null;
objDocumentDetailsModel = null;
objUserInfoSL = null;
}
}
public bool AddCarrier(CarrierModel carrier)
{
var entity = new Carrier()
{
Name = carrier.Name,
AddressLine1 = carrier.AddressLine1,
AddressLine2 = carrier.AddressLine2,
City = carrier.City,
State = carrier.State,
ZipCode = carrier.ZipCode,
Email = carrier.Email,
Phone = carrier.Phone,
IsActive = true,
AddUser = LoginUserDetails.GetWindowsLoginUserName(),
AddDate = DateUtil.GetCurrentDate()
};
return(_carrierRepository.Add(entity));
}
public ActionResult MCQQuestions(int acid = 0, int QuestionID = 0)
{
objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
MCQModel objMCQSettingsModel = new MCQModel();
PopulateCombo();
ViewBag.EditQuestion = 0;
if (QuestionID != 0)
{
objMCQSettingsModel.QuestionID = QuestionID;
ViewBag.EditQuestion = 1;
using (var objMCQSL = new MCQSL())
{
objMCQ_QUESTION_DTO = objMCQSL.GetMCQQuestionDetails(objLoginUserDetails.CompanyDBConnectionString, QuestionID, "SELECT", out msg, objLoginUserDetails.LoggedInUserID);
}
objMCQSettingsModel.Question = objMCQ_QUESTION_DTO.Question;
objMCQSettingsModel.Answer_Type = (objMCQ_QUESTION_DTO.AnswerTypes == 1) ? "Radio" : "CheckBox";
objMCQSettingsModel.Option_number = objMCQ_QUESTION_DTO.OptionNumbers;
objMCQSettingsModel.QuestionsAnswer = objMCQ_QUESTION_DTO.QuestionAnswer;
objMCQSettingsModel.objQuestionsAnswerList = new List <string>();
objMCQSettingsModel.objCorrectAnswerList = new List <string>();
objMCQSettingsModel.objQuestionBankDetailsIDList = new List <int>();
for (int i = 0; i < objMCQ_QUESTION_DTO.OptionNumbers; i++)
{
objMCQSettingsModel.objQuestionsAnswerList.Add(objMCQ_QUESTION_DTO.QuestionAnswer.Split('~')[i].Split('.')[1]);
objMCQSettingsModel.objQuestionBankDetailsIDList.Add(Convert.ToInt32(objMCQ_QUESTION_DTO.QuestionAnswerWithID.Split('~')[i]));
string[] correctAns = objMCQ_QUESTION_DTO.CorrectAnswer.Split('~');
foreach (string Ans in correctAns)
{
if (Ans == objMCQ_QUESTION_DTO.QuestionAnswer.Split('~')[i].Split('.')[1])
{
objMCQSettingsModel.objCorrectAnswerList.Add(Ans);
}
}
}
}
return(View(objMCQSettingsModel));
}
public ActionResult ViewNofication_OS(int acid, int NotificationId)
{
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
NotificationModel objNotificationModel = new NotificationModel();
NotificationDTO objNotificationDTO = new NotificationDTO();
List <PopulateComboDTO> lstList = new List <PopulateComboDTO>();
try
{
lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.CommunicationModes).ToString(), Convert.ToInt32(ConstEnum.Code.CommunicationCategory).ToString(), null, null, null, true);
ViewBag.ModeCodeList = lstList;
if (NotificationId > 0)
{
using (var objNotificationSL = new NotificationSL_OS())
{
objNotificationDTO = objNotificationSL.GetDetails_OS(objLoginUserDetails.CompanyDBConnectionString, NotificationId);
}
InsiderTrading.Common.Common.CopyObjectPropertyByName(objNotificationDTO, objNotificationModel);
objNotificationModel.Contents = objNotificationModel.Contents.Replace("\\r\\n", "<br/>");
if (objNotificationModel.Signature != null)
{
objNotificationModel.Signature = objNotificationModel.Signature.Replace("\\r\\n", "<br/>");
}
}
ViewBag.ModeCodeId = objNotificationDTO.ModeCodeId;
ViewBag.NotificationQueueId = NotificationId;
ViewBag.UserId = objLoginUserDetails.LoggedInUserID;
//ViewBag.CommunicationMode_id = objCommunicationRuleMasterModel.CommunicationModeCodeId;
return(View("ViewNofication_OS", objNotificationModel));
}
catch (Exception exp)
{
//NotificationModel objNotificationModel = new NotificationModel();
string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString());
ModelState.AddModelError("Error", sErrMessage);
return(View("ViewNofication_OS", objNotificationModel));
}
}
/// <summary>
/// This method is used to fetch sub category drop down view (partial)
/// </summary>
/// <param name="category_id"></param>
/// <returns></returns>
public ActionResult PartialCreateView(int CommunicationMode_id)
{
LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
List <PopulateComboDTO> lstList = new List <PopulateComboDTO>();
//get list of disclousre type
lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, ConstEnum.CodeGroup.DisclosureType, null, null, null, null, true);
ViewBag.DisclosureType = lstList;
//get list of user type for letter type communicaiton mode
lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, ConstEnum.CodeGroup.DisclosureLetterForUserType, ConstEnum.Code.CommunicationModeForLetter.ToString(), null, null, null, true);
ViewBag.LetterFor = lstList;
//get list of user type for FAQ type communicaiton mode
lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, ConstEnum.CodeGroup.DisclosureLetterForUserType, ConstEnum.Code.CommunicationModeForFAQ.ToString(), null, null, null, true);
ViewBag.FAQFor = lstList;
ViewBag.CommunicationMode_id = CommunicationMode_id;
return(PartialView("PartialCreate"));
}
public void DownloadClawBackExcel(int acid)
{
string exlFilename = string.Empty;
string sConnectionString = string.Empty;
string spName = string.Empty;
string workSheetName = string.Empty;
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
sConnectionString = objLoginUserDetails.CompanyDBConnectionString;
SqlConnection con = new SqlConnection(sConnectionString);
SqlCommand cmd = new SqlCommand();
con.Open();
DataTable dt = new DataTable();
spName = "st_rpt_DownloadClawBackReportExcel";
exlFilename = "Claw Back Report.xls";
workSheetName = "Claw Back Report";
cmd = new SqlCommand(spName, con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Charset = "";
Response.AddHeader("content-disposition", "attachment;filename=" + exlFilename + "");
StringWriter sWriter = new StringWriter();
System.Web.UI.HtmlTextWriter hWriter = new System.Web.UI.HtmlTextWriter(sWriter);
System.Web.UI.WebControls.GridView dtGrid = new System.Web.UI.WebControls.GridView();
dtGrid.DataSource = dt;
dtGrid.DataBind();
dtGrid.RenderControl(hWriter);
Response.Write(@"<style> TD { mso-number-format:\@; } </style>");
Response.Output.Write(sWriter.ToString());
Response.Flush();
Response.End();
}
private MCQ_REPORT_DTO[] GeSearchResult(string Action, string term)
{
MCQ_REPORT_DTO[] matching = null;
MCQ_REPORT_DTO mCQ_REPORTListModel = new MCQ_REPORT_DTO();
LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
mCQ_REPORTListModel.Action = Action;
switch (Action)
{
case "SEARCH_BY_EMPLOYEEID":
mCQ_REPORTListModel.EmployeeId = term;
break;
case "SEARCH_BY_NAME":
mCQ_REPORTListModel.Name = term;
break;
case "SEARCH_BY_DEPARTMENT":
mCQ_REPORTListModel.Department = term;
break;
case "SEARCH_BY_DESIGNATION":
mCQ_REPORTListModel.Designation = term;
break;
default:
Console.WriteLine("Default case");
break;
}
using (var objMCQSL = new MCQSL())
{
matching = String.IsNullOrEmpty(term) ? objMCQSL.AutoCompleteListSL(objLoginUserDetails.CompanyDBConnectionString, AutoCompleteSearchParameters(mCQ_REPORTListModel)).ToArray() :
objMCQSL.AutoCompleteListSL(objLoginUserDetails.CompanyDBConnectionString, AutoCompleteSearchParameters(mCQ_REPORTListModel)).ToArray();
}
return(matching);
}
public ActionResult Delete(int acid, int id)
{
bool bDeleteFlag = false;
var ErrorDictionary = new Dictionary <string, string>();
LoginUserDetails objLoginUserDetails = null;
try
{
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
using (DelegationMasterSL objDelegationMasterSL = new DelegationMasterSL())
{
bDeleteFlag = objDelegationMasterSL.Delete(id, objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
if (bDeleteFlag)
{
ErrorDictionary.Add("success", "Successfully deleted the delegation record");
}
}
}
catch (Exception e)
{
ModelState.Remove("KEY");
ModelState.Add("KEY", new ModelState());
ModelState.Clear();
string sErrMessage = Common.Common.getResource(e.InnerException.Data[0].ToString());
ModelState.AddModelError("error", sErrMessage);
ErrorDictionary = GetModelStateErrorsAsString();
}
finally
{
objLoginUserDetails = null;
}
return(Json(new
{
status = bDeleteFlag,
Message = ErrorDictionary
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// This method is used to setup all the pre-requisite for Login to applicaton
/// </summary>
/// <param name="HT_Params">Collection of EmailID and CompanyName</param>
/// <returns>returns True for Sucessfull and false for Failure</returns>
internal bool SetupLoginDetails(Hashtable HT_Params)
{
bool IsLoginSetupSucceed = false;
using (CompaniesSL objCompaniesSL = new CompaniesSL())
{
LoginUserDetails objLoginUserDetails = new LoginUserDetails();
CompanyDTO objSelectedCompany = new CompanyDTO();
objSelectedCompany = objCompaniesSL.getSingleCompanies(InsiderTrading.Common.Common.getSystemConnectionString(), HT_Params[CommonConstant.s_AttributeComapnyName].ToString());
objLoginUserDetails.CompanyDBConnectionString = objSelectedCompany.CompanyConnectionString;
using (DataSecurity objDataSecurity = new DataSecurity())
{
UserInfoDTO userInfoDTO = new UserInfoDTO();
UserInfoDAL objUserInfoDAL = new UserInfoDAL();
userInfoDTO = objUserInfoDAL.LoginSSOUserInfo(objLoginUserDetails.CompanyDBConnectionString, HT_Params);
if (userInfoDTO.LoginID == null)
{
foreach (string perKey in HT_Params.Keys)
{
if (!perKey.Equals("CompanyName"))
{
throw new Exception(string.Format(CommonConstant.s_InvalidAttribute, perKey));
}
}
}
objLoginUserDetails.UserName = userInfoDTO.LoginID;
objLoginUserDetails.Password = userInfoDTO.Password;
objLoginUserDetails.CompanyDBConnectionString = objSelectedCompany.CompanyConnectionString;
objLoginUserDetails.CompanyName = objSelectedCompany.sCompanyDatabaseName;
objLoginUserDetails.IsUserLogin = false; //this flag indicate that user is not yet login sucessfully
Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails);
IsLoginSetupSucceed = true;
}
}
return(IsLoginSetupSucceed);
}
public ActionResult BackToIndex(int acid, string sCodeGroupId, string nParentId)
{
ComCodeModel objComCodeModel = null;
PopulateComboDTO objPopulateComboDTO = null;
LoginUserDetails objLoginUserDetails = null;
List <PopulateComboDTO> lstCodeGroup = null;
try
{
ViewBag.GridType = ConstEnum.GridType.ComCodeList;
ViewBag.Param1 = null;
objComCodeModel = new ComCodeModel();
objPopulateComboDTO = new PopulateComboDTO();
objPopulateComboDTO.Key = "0";
objPopulateComboDTO.Value = "Select";
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
lstCodeGroup = new List <PopulateComboDTO>();
lstCodeGroup.Add(objPopulateComboDTO);
lstCodeGroup.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.CodeParentList,
null, null, null, null, null, sLookUpPrefix));
ViewBag.CodeGroupDropDown = lstCodeGroup;
ViewBag.ParentCodeName = null;
objComCodeModel.CodeGroupId = sCodeGroupId;
objComCodeModel.ParentCodeId = Convert.ToInt32(nParentId);
ViewBag.CodeGroupId = "0";
}
finally
{
objComCodeModel = null;
objPopulateComboDTO = null;
objLoginUserDetails = null;
lstCodeGroup = null;
}
return(View("Index"));
}
public ActionResult Transfer(int acid)
{
SecurityTransferLogModel objSecurityTransferLogModel = new SecurityTransferLogModel();
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
int PendingPeriodEndCount = 0;
int PendingTransactionsCountPNT = 0;
int PendingTransactionsCountPCL = 0;
try{
objSecurityTransferLogModel.TransferFor = InsiderTrading.Common.ConstEnum.Code.PreclearanceRequestForSelf;
objSecurityTransferLogModel.UserInfoId = objLoginUserDetails.LoggedInUserID;
objSecurityTransferLogModel.ForUserInfoId = objLoginUserDetails.LoggedInUserID;
objSecurityTransferLogModel.SecurityTransferOption = InsiderTrading.Common.ConstEnum.Code.SecurityTransferfromselectedDemataccount;
//objSecurityTransferLogModel.TransferQuantity = null;
using (var objSecurityTransferSL = new SecurityTransferSL())
{
objSecurityTransferSL.GetPendingTransactionforSecurityTransfer(objLoginUserDetails.CompanyDBConnectionString,
objSecurityTransferLogModel.UserInfoId, out PendingPeriodEndCount, out PendingTransactionsCountPNT, out PendingTransactionsCountPCL);
}
}catch (Exception) {
}
finally{
objLoginUserDetails = null;
}
if (PendingPeriodEndCount > 0)
{
acid = ConstEnum.UserActions.Security_Transfer_Holding_List;
return(RedirectToAction("Index", "SecurityTransfer", new { acid, PendingPeriodEndCount, PendingTransactionsCountPNT, PendingTransactionsCountPCL }));
}
else if (PendingTransactionsCountPNT > 0 || PendingTransactionsCountPCL > 0)
{
acid = ConstEnum.UserActions.Security_Transfer_Holding_List;
return(RedirectToAction("Index", "SecurityTransfer", new { acid, PendingPeriodEndCount, PendingTransactionsCountPNT, PendingTransactionsCountPCL }));
}
else
{
return(View("TransferView", objSecurityTransferLogModel));
}
}
public ActionResult UploadDocument(int acid, int GroupId)
{
NSEGroupSL ObjNSEGroupSL = new NSEGroupSL();
NSEGroupDocumentMappingModel objNSEDocumentModel = null;
LoginUserDetails objLoginUserDetails = null;
objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
objNSEDocumentModel = new NSEGroupDocumentMappingModel();
ViewBag.UserAction = acid;
DateTime? date = null;
List <NSEGroupDTO> lstDate = ObjNSEGroupSL.Get_Group_Date(objLoginUserDetails.CompanyDBConnectionString, GroupId);
foreach (var submitdate in lstDate)
{
date = submitdate.DownloadedDate;
}
ViewBag.groupId = GroupId;
ViewBag.DownloadDate = date;
objNSEDocumentModel.NSEGroupDocumentFile = Common.Common.GenerateDocumentList(ConstEnum.Code.UploadNseDocument, 0, 0, null, 0, false, 0, ConstEnum.FileUploadControlCount.NSEUploadFile);
return(View("NSEUploadDoc", objNSEDocumentModel));
}
public bool ModifyPolicy(PolicyModel policy)
{
var entity = new Policie()
{
Id = policy.Id,
PolicyNumber = policy.PolicyNumber,
IsActive = policy.IsActive,
CarId = policy.CarId,
CoverageId = policy.CoverageId,
ProductId = policy.ProductId,
EffectiveDate = (DateTime)policy.EffectiveDate,
EndDate = policy.EndDate,
IsGroupInsurance = policy.IsGroupInsurance,
AddUser = policy.AddUser,
AddDate = policy.AddDate,
RevDate = DateUtil.GetCurrentDate(),
RevUser = LoginUserDetails.GetWindowsLoginUserName()
};
return(_policyRepository.Update(entity));
}
public LoginUserDetails GetLastUserLoginInfo()
{//when first login ,user is null,return value is null
LoginUserDetails loginUserDetails = null;
var user = userAccess.GetLastUserLoginInfo();
if (user != null)
{
var country = ConfigurationService.GetAllCountryMap().FirstOrDefault(o => o.CountryCode == user.CountryCode);
loginUserDetails = new LoginUserDetails(user.Email,
user.LockedStatus,
user.Password,
country,
user.NeedChangePassword,
user.SyncAnnotations,
user.SymmetricKey,
user.FirstName,
user.LastName,
user.LastSyncDate);
}
return(loginUserDetails);
}
