public DataSet Login_Usermaster(Usermaster _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_tbl_user_master", _cn); _cmd.Parameters.AddWithValue("@User_Name", _obj.User_Name); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); _cmd.CommandTimeout = 300; DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public JsonResult CheckLogin(Usermaster _obj) { bool flagLogin = false; bool flagCaptcha = false; bool flagValidID = false; UserRepository _objRepository = new UserRepository(); DataSet ds = _objRepository.Login_Usermaster(_obj); try { if (this.Session["CaptchaImageText"].ToString() == _obj.Captchastr) { flagCaptcha = true; if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { flagValidID = true; DataRow dr = ds.Tables[0].Rows[0]; if (dr["Password"].ToString() == _obj.Password) { string localIPadmin = "?"; localIPadmin = Request.ServerVariables["REMOTE_ADDR"].ToString(); Session["localIPADmin"] = localIPadmin; Session["is_callCentre"] = dr["is_callCentre"].ToString(); Session["User_id"] = dr["User_id"]; Session["User_Name"] = dr["User_Name"]; Session["Name"] = dr["Name"].ToString(); Session["is_admin"] = dr["is_admin"].ToString(); Session["AdminRole"] = dr["AdminRole"].ToString(); Session["is_doc_verification"] = dr["is_doc_verification"].ToString(); string localIP = "?"; localIP = Request.ServerVariables["REMOTE_ADDR"].ToString(); Session["localIP"] = localIP; flagLogin = true; } } } } else { flagCaptcha = false; } } catch (Exception) { throw; } return(Json(new { flagLogin = flagLogin, flagValidID = flagValidID, flagCaptcha = flagCaptcha }, JsonRequestBehavior.AllowGet )); }
public ActionResult Create(CreateNewUserViewModel createUserViewModel) { try { if (ModelState.IsValid) { if (_iUserMaster.CheckEmailIdExists(createUserViewModel.EmailId)) { TempData["MessageCreateUsersErrors"] = "EmailId Already Exists"; } else if (_iUserMaster.CheckMobileNoExists(createUserViewModel.MobileNo)) { TempData["MessageCreateUsersErrors"] = "MobileNo Already Exists"; } else { string username = GenerateUserName(createUserViewModel); Usermaster usermaster = new Usermaster(); usermaster.Status = true; usermaster.CreateDate = DateTime.Now; usermaster.UserId = 0; usermaster.FirstName = createUserViewModel.FirstName; usermaster.LastName = createUserViewModel.LastName; usermaster.EmailId = createUserViewModel.EmailId; usermaster.MobileNo = createUserViewModel.MobileNo; usermaster.UserName = username; usermaster.CreatedBy = Convert.ToInt32(_sessionHandler.UserId); usermaster.Gender = createUserViewModel.Gender; var salt = GenerateRandomNumbers.RandomNumbers(20); var password = GeneratePassword(createUserViewModel, salt); var userId = _iUserMaster.AddUser(usermaster, password, salt, Convert.ToInt16(StatusMain.Roles.User)); if (userId != -1) { TempData["MessageCreateUsers"] = $"User Created Successfully Username :- {usermaster.UserName}"; } return(RedirectToAction("Create", "CreateNewUser")); } return(View("Create", createUserViewModel)); } else { return(View("Create", createUserViewModel)); } } catch { throw; } }
public void DeleteUser(int?userId) { try { Usermaster usermaster = _context.Usermasters.Find(userId); if (usermaster != null) { _context.Usermasters.Remove(usermaster); } _context.SaveChanges(); } catch (Exception) { throw; } }
public ActionResult Login(LoginModel Model) { if (ModelState.IsValid) { Usermaster user = _user.DoLogin(Model.Username, Model.Password); if (user != null) { TempData["UserId"] = user.UserId; AddLoginCookie(user.UserId, user.Name, user.UserName, user.Role, "Token"); // Using for new registration var registrationDetails = _registrationRepository.FindBy(x => x.UserId == user.UserId).FirstOrDefault(); if (registrationDetails != null && user.Role == (int)Roles.Admin && user.Status == (int)Status.Active) { return(RedirectToAction("Index", "Dashboard", new { area = "Admin" })); } else if (registrationDetails != null && user.Role == (int)Roles.Distributor && user.Status == (int)Status.Active) { return(RedirectToAction("Index", "Account")); } else if (registrationDetails != null && user.Role == (int)Roles.Retrailer && user.Status == (int)Status.Active) { return(RedirectToAction("Index", "Account")); } else if (registrationDetails != null && user.Status == (int)Status.InActive) { return(RedirectToAction("RequestForApproving", "Account")); } else if (registrationDetails == null && user.Status == (int)Status.Created) { return(RedirectToAction("CreateRegistration", "Account")); } else { return(RedirectToAction("CreateRegistration", "Account")); } } else { ViewBag.Message = "The Username Or Password you enterd is invalid"; } } return(View()); }
private bool IsCategogryAssigned(Usermaster usermasterModel, SavedAssignedRolesViewModel rolesModel) { if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Agent) && _agentCheckInStatus.CheckIsCategoryAssignedtoAgent(usermasterModel.UserId)) { return(true); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.AgentAdmin) && _iUserMaster.CheckIsCategogryAssignedtoAgentAdmin(usermasterModel.UserId)) { return(true); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Hod) && _iUserMaster.CheckIsCategogryAssignedtoHod(usermasterModel.UserId)) { return(true); } return(false); }
public long?UpdateUser(Usermaster usermaster) { try { long?result = -1; if (usermaster != null) { usermaster.CreateDate = DateTime.Now; _context.Entry(usermaster).State = EntityState.Modified; _context.SaveChanges(); result = usermaster.UserId; } return(result); } catch (Exception) { throw; } }
public ActionResult RedirectionManager(Usermaster usermasterModel, SavedAssignedRolesViewModel rolesModel) { if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.SuperAdmin)) { return(RedirectToAction("Dashboard", "SuperDashboard")); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.User)) { return(RedirectToAction("Dashboard", "UserDashboard")); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Admin)) { return(RedirectToAction("Dashboard", "AdminDashboard")); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.AgentAdmin)) { return(RedirectToAction("Dashboard", "AgentAdminDashboard")); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Hod)) { return(RedirectToAction("Dashboard", "HODDashboard")); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Agent)) { if (_agentCheckInStatus.CheckIsalreadyCheckedIn(usermasterModel.UserId)) { return(RedirectToAction("Dashboard", "AgentDashboard")); } else { return(RedirectToAction("Alerts", "CheckInAlert")); } } return(RedirectToAction("Login", "Login")); }
public long?AddUser(Usermaster usermaster) { try { long?result = -1; if (usermaster != null) { usermaster.Status = true; usermaster.CreateDate = DateTime.Now; _context.Usermasters.Add(usermaster); _context.SaveChanges(); result = usermaster.UserId; } return(result); } catch (Exception) { throw; } }
private void AssignSessionValues(Usermaster usermasterModel, SavedAssignedRolesViewModel rolesModel) { var sessionHandler = new SessionHandler { UserId = Convert.ToString(usermasterModel.UserId), UserName = usermasterModel.FirstName + " " + usermasterModel.LastName, EmailId = usermasterModel.EmailId, RoleId = Convert.ToString(rolesModel.RoleId), RoleName = Convert.ToString(rolesModel.RoleName), CacheProfileKey = "Cache_" + usermasterModel.UserId }; if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.AgentAdmin)) { sessionHandler.AgentAdminCategoryId = Convert.ToString(_category.GetAdminCategory(usermasterModel.UserId)); } if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Hod)) { sessionHandler.HodCategoryId = Convert.ToString(_category.GetHodCategory(usermasterModel.UserId)); } var result = _iProfile.IsProfileImageExists(Convert.ToInt64(sessionHandler.UserId)); if (result) { string cacheProfileKey = Convert.ToString(sessionHandler.CacheProfileKey); if (!CacheHelper.CheckExists(cacheProfileKey)) { var imageBase64String = _iProfile.GetProfileImageBase64String(Convert.ToInt64(sessionHandler.UserId)); var tempimageBase64String = string.Concat("data:image/png;base64,", imageBase64String); CacheHelper.AddToCacheWithNoExpiration(cacheProfileKey, tempimageBase64String); } } }
public HttpResponseMessage CreateRegistration(RegistrationModel registrationModel) { ResponseModel _response = new ResponseModel(); var _getUser = _userMaster.FindBy(x => x.UserId == registrationModel.UserId).FirstOrDefault(); if (_getUser == null) { _response.Type = "error"; _response.Message = "User not Exist"; return(Request.CreateResponse(HttpStatusCode.OK, _response)); } var _getDetail = _registrationRepository.FindBy(x => x.UserId == registrationModel.UserId).FirstOrDefault(); if (_getDetail != null) { _response.Type = "error"; _response.Message = "Profile already Created"; return(Request.CreateResponse(HttpStatusCode.OK, _response)); } var model = Mapper.Map <RegistrationModel, Registration>(registrationModel); model.CreatedDate = DateTime.Now; model.CreatedBy = registrationModel.CreatedBy; model.Status = (int)Status.InActive; model.IsDeleted = false; var Result = _registrationRepository.CreateUserProfile(model); if (Result != null) { // Update UserMaster Status for Inactive Usermaster _details = _userMaster.FindBy(x => x.UserId == Result.UserId).FirstOrDefault(); if (_details != null) { _details.Status = (int)Status.InActive; _userMaster.Update(_details); _userMaster.SaveChanges(); } // For Uploading Licence image ---- foreach (var item in registrationModel.lstDocLicence) { if (item != null) { UploadDocumentModel UploadDocument = new UploadDocumentModel(); UploadDocument.documents = new List <DocumentModel>(); UploadDocument.ImageSize = 250; UploadDocument.ImageQuality = 250; UploadDocument.documents.Add(item); List <string> uploadedFileName = SavePicture(UploadDocument); if (uploadedFileName.Count > 0) { LicenceImages licenceImages = new LicenceImages(); licenceImages.ImagePath = uploadedFileName[0].ToString(); licenceImages.RegistrationId = Result.RegistrationId; licenceImages.IsActive = true; _licenceImagesReposiory.Add(licenceImages); _licenceImagesReposiory.SaveChanges(); } } } // For Uploading image ---- if (registrationModel.DocGSTNo != null) { UploadDocumentModel UploadDocumentGSTNo = new UploadDocumentModel(); UploadDocumentGSTNo.documents = new List <DocumentModel>(); UploadDocumentGSTNo.ImageSize = 250; UploadDocumentGSTNo.ImageQuality = 250; UploadDocumentGSTNo.documents.Add(registrationModel.DocGSTNo); List <string> uploadedFileName = SavePicture(UploadDocumentGSTNo); if (uploadedFileName.Count > 0) { Registration _registration = _registrationRepository.FindBy(x => x.RegistrationId == Result.RegistrationId).FirstOrDefault(); if (_registration != null) { _registration.GSTNoImage = uploadedFileName[0].ToString(); _registrationRepository.Update(_registration); _registrationRepository.SaveChanges(); } } } _response.Type = "success"; _response.Message = "Profile created successfully"; return(Request.CreateResponse(HttpStatusCode.OK, _response)); } else { _response.Type = "error"; _response.Message = "somehing went wrong"; return(Request.CreateResponse(HttpStatusCode.OK, _response)); } }
public IEnumerable <DocumentModel> SearchDocuments(SearchModel searchModel) { string result = "load"; IEnumerable <DocumentModel> documents = null; Usermaster resultObjUM = null; string username, password; (username, password) = SecurityHelper.GetCredentials(User.Identity as ClaimsIdentity); try { using (var client = new HttpClient()) { try { string uri = ConfigurationManager.AppSettings["GetEPFMSettings"] + "?Username="******"N" ? resultObjUM.EpfmUsername : username; password = resultObjUM.Isaduser == "N" ? resultObjUM.EpfmPassword : password; Logger.WriteLog(JsonConvert.SerializeObject(resultObjUM)); } else { new Exception("ERCMS Core API failed" + httpresult.ReasonPhrase); } } catch (Exception ex) { Logger.WriteLog("ERCMS Core API failed " + ex.Message + Environment.NewLine + ex.StackTrace); throw ex; } } //string username, password; //(username, password) = SecurityHelper.GetCredentials(User.Identity as ClaimsIdentity); String repository = ConfigurationManager.AppSettings["EPFMRepository"]; //String username = ConfigurationManager.AppSettings["EPFMUsername"]; //String password = ConfigurationManager.AppSettings["EPFMPassword"]; String address = ConfigurationManager.AppSettings["EPFMAddress"]; Logger.WriteLog("SearchDocuments Log details " + username + Environment.NewLine + password + Environment.NewLine + address); SearchServiceDemo searchServiceDemo = new SearchServiceDemo(repository, null, username, password, address); Logger.WriteLog("SearchDocuments searchServiceDemo " + searchServiceDemo.ToString()); documents = searchServiceDemo.SimplePassthroughQueryDocumentWithPath_New(searchModel); } catch (Exception ex) { result = result + "Got exception" + ex.StackTrace; Logger.WriteLog("SearchDocuments searchServiceDemo " + result); throw new Exception(result); } return(documents); }
public IHttpActionResult DownloadDocument(DownloadContextDTO Dto) { string result = ""; try { Usermaster resultObjUM = null; string username, password; (username, password) = SecurityHelper.GetCredentials(User.Identity as ClaimsIdentity); using (var client = new HttpClient()) { try { string uri = ConfigurationManager.AppSettings["GetEPFMSettings"] + "?Username="******"N" ? resultObjUM.EpfmUsername : username; password = resultObjUM.Isaduser == "N" ? resultObjUM.EpfmPassword : password; Logger.WriteLog(JsonConvert.SerializeObject(resultObjUM)); } else { new Exception("ERCMS Core API failed" + httpresult.ReasonPhrase); } } catch (Exception ex) { Logger.WriteLog("ERCMS Core API failed " + ex.Message + Environment.NewLine + ex.StackTrace); throw ex; } } String repository = ConfigurationManager.AppSettings["EPFMRepository"]; //String username = ConfigurationManager.AppSettings["EPFMUsername"]; //String password = ConfigurationManager.AppSettings["EPFMPassword"]; String address = ConfigurationManager.AppSettings["EPFMAddress"]; ObjectServiceDemo objectService = new ObjectServiceDemo(repository, null, username, password, address); //string object_id = "090181cd80054c37"; ObjectIdentity objIdentity = new ObjectIdentity(new Qualification("dm_document where r_object_id = '" + Dto.object_id + "'"), repository); FileInfo fileInfo = null; try { fileInfo = objectService.GetWithContent(objIdentity, "Pleasanton", Emc.Documentum.FS.DataModel.Core.Content.ContentTransferMode.MTOM, Dto.object_id); } catch (Exception ex) { } if (fileInfo == null) { string TemplateFilePath = ConfigurationManager.AppSettings["TemplateFilePath"]; string Fullpath = Path.Combine(TemplateFilePath, Dto.SaveFilename); StreamWriter sw = new StreamWriter(Fullpath, false); sw.WriteLine("This is a sample file created at " + DateTime.Now); sw.Close(); fileInfo = new FileInfo(Fullpath); } MoveEPFMResultWrapper resultObj = null; // using (var client = new HttpClient()) { try { string uri = ConfigurationManager.AppSettings["CoreMoveEPFMUri"] + "?RidType=" + Dto.RidType + "&category=" + Dto.category + "&Tmpfilename=" + fileInfo.FullName + "&SaveFilename=" + Dto.SaveFilename + "&attachsequence=" + Dto.attachsequence + "&objectid=" + Dto.object_id + "&attachmentguid=" + Dto.attachmentguid; client.DefaultRequestHeaders.Authorization = ActionContext.Request.Headers.Authorization; var responseTask = client.GetAsync(uri); responseTask.Wait(); var httpresult = responseTask.Result; if (httpresult.IsSuccessStatusCode) { //var readTask = result.Content.ReadAsAsync<IList<StudentViewModel>>(); var readTask = httpresult.Content.ReadAsAsync <MoveEPFMResultWrapper>(); readTask.Wait(); resultObj = readTask.Result; Logger.WriteLog(JsonConvert.SerializeObject(resultObj)); } else { new Exception("ERCMS Core API failed" + httpresult.ReasonPhrase); } } catch (Exception ex) { Logger.WriteLog("ERCMS Core API failed " + ex.Message + Environment.NewLine + ex.StackTrace); throw ex; } } return(Content(HttpStatusCode.OK, resultObj)); } catch (Exception ex) { result = result + "Got exception" + ex.StackTrace; return(Ok(ex.Message)); } }