public ActionResult Edit(Applicants app) { int Userid = app.Userid; string Fname = app.Fname, Lname = app.Lname, School = app.School, Aemail = app.Aemail, Degree = app.Degree, DegreeField = app.DegreeField; ApplicantsRepository.UpdateApplicant(Userid, Fname, Lname, School, Aemail, Degree, DegreeField); return RedirectToAction("Index", "Jobs"); }
public ActionResult Pro(Applicants app) { Database db = DatabaseFactory.CreateDatabase(); DbCommand command = db.GetStoredProcCommand("Applicant_Update"); db.AddInParameter(command, "@Appid", System.Data.DbType.Int32, 2); db.AddInParameter(command, "@Userid", System.Data.DbType.Int32, 1); db.AddInParameter(command, "@Fname", System.Data.DbType.String, app.Fname); db.AddInParameter(command, "@Lname", System.Data.DbType.String, app.Lname); db.AddInParameter(command, "@School", System.Data.DbType.String, app.School); db.AddInParameter(command, "@Aemail", System.Data.DbType.String, app.Aemail); db.AddInParameter(command, "@Degree", System.Data.DbType.String, app.Degree); db.AddInParameter(command, "@DegreeField", System.Data.DbType.String, app.DegreeField); db.ExecuteScalar(command); return RedirectToAction("Index", "Jobs"); }
public Applicants FindAppid(int Userid) { DbCommand command = db.GetStoredProcCommand("Applicants_FindAppid"); db.AddInParameter(command, "@Userid", System.Data.DbType.Int32, Userid); db.ExecuteScalar(command); var result = new Applicants(); using (var reader = db.ExecuteReader(command)) { while (reader.Read()) { if (!reader.IsDBNull(reader.GetOrdinal("Appid"))) { result.Appid = reader.GetInt32(reader.GetOrdinal("Appid")); } } return result; } }
public Applicants ViewEditApplicant(int id) { DbCommand command = db.GetStoredProcCommand("Applicants_BuildList"); db.AddInParameter(command, "@Userid", System.Data.DbType.Int32, id); db.ExecuteScalar(command); var result = new Applicants(); using (var reader = db.ExecuteReader(command)) { while (reader.Read()) { if (!reader.IsDBNull(reader.GetOrdinal("Appid"))) { result.Appid = reader.GetInt32(reader.GetOrdinal("Appid")); } if (!reader.IsDBNull(reader.GetOrdinal("Userid"))) { result.Userid = reader.GetInt32(reader.GetOrdinal("Userid")); } if (!reader.IsDBNull(reader.GetOrdinal("Fname"))) { result.Fname = reader.GetString(reader.GetOrdinal("Fname")); } if (!reader.IsDBNull(reader.GetOrdinal("Lname"))) { result.Lname = reader.GetString(reader.GetOrdinal("Lname")); } if (!reader.IsDBNull(reader.GetOrdinal("Aemail"))) { result.Aemail = reader.GetString(reader.GetOrdinal("Aemail")); } if (!reader.IsDBNull(reader.GetOrdinal("DegreeField"))) { result.DegreeField = reader.GetString(reader.GetOrdinal("DegreeField")); } if (!reader.IsDBNull(reader.GetOrdinal("Degree"))) { result.Degree = reader.GetString(reader.GetOrdinal("Degree")); } if (!reader.IsDBNull(reader.GetOrdinal("School"))) { result.School = reader.GetString(reader.GetOrdinal("School")); } } } return result; }
public ActionResult Create(Applicants app) { ApplicantsRepository.InsertApplicant(app.Userid, app.Fname, app.Lname, app.School, app.Aemail, app.Degree, app.DegreeField); return RedirectToAction("LogOn", "Account"); }
public void Update(string Id, Applicants applicantIn) { applicants.ReplaceOne(applicant => applicant.objectId == Id, applicantIn); }
public void Remove(Applicants applicantIn) { applicants.DeleteOne(applicant => applicant.objectId == applicantIn.objectId); }
public void Update(Applicants applicants) => _applicants.ReplaceOne(sub => sub.Id == applicants.Id, applicants);
public Applicants Create(Applicants applicant) { applicants.InsertOne(applicant); return(applicant); }
public ApplicantsDto GetApplicantById(string id) { return(Applicants.FirstOrDefault((applicant) => applicant.Id == id)); }
/// <summary> /// Click on the Applicants link on the main menu /// </summary> public void ClickApplicants() { Applicants.WaitRetry(_driver).Click(); }
protected void Page_Load(object sender, EventArgs e) { Response.ContentType = "application/json"; string pattern = HttpUtility.UrlDecode(Request.QueryString["Pattern"]); string geographyString = Request.QueryString["GeographyId"]; int geographyId = int.Parse(geographyString); Geography geography = Geography.FromIdentity(geographyId); if ( !CurrentAuthority.HasAccess(new Access(CurrentOrganization, geography, AccessAspect.PersonalData, AccessType.Read))) { throw new UnauthorizedAccessException("nope"); } People matches = People.FromOrganizationAndGeographyWithPattern(CurrentOrganization, geography, pattern); matches = CurrentAuthority.FilterPeople(matches); if (matches == null) { matches = new People(); } if (matches.Count > 1000) { matches.RemoveRange(1000, matches.Count - 1000); } List <string> jsonPeople = new List <string>(); string editPersonTemplate = "\"actions\":\"<a href='javascript:masterBeginEditPerson({0})'><img src='/Images/Icons/iconshock-wrench-128x96px-centered.png' height='16' width='24' /></a>\""; Dictionary <int, Applicant> applicantLookup = new Dictionary <int, Applicant>(); if (CurrentOrganization.Parameters.ParticipationEntry == "ApplicationApproval") { // There are applications possible for this org; find them and put the Score in the Notes field Applicants applicants = Applicants.FromPeopleInOrganization(matches, CurrentOrganization); foreach (Applicant applicant in applicants) { applicantLookup[applicant.PersonId] = applicant; } } foreach (Person person in matches) { string notes = Participant.Localized(CurrentOrganization.RegularLabel, person.Gender); if (applicantLookup.ContainsKey(person.Identity)) { // If this is an applicant, use the "Notes" field for score notes = "<span class='align-for-numbers'>" + applicantLookup[person.Identity].ScoreTotal.ToString("N0") + "</span>"; } string onePerson = '{' + String.Format( "\"id\":\"{0}\",\"name\":\"<span class='spanUser{0}Name'>{1}</span>\",\"avatar16Url\":\"{2}\",\"geographyName\":\"{3}\",\"mail\":\"<span class='spanUser{0}Mail'>{4}</span>\",\"notes\":\"{6}\",\"phone\":\"<span class='spanUser{0}Phone'>{5}</span>\"", person.Identity, JsonSanitize(person.Canonical), person.GetSecureAvatarLink(16), JsonSanitize(person.Geography.Localized), JsonSanitize(person.Mail), JsonSanitize(person.Phone), JsonSanitize(notes)) + "," + String.Format( editPersonTemplate, person.Identity) + '}'; jsonPeople.Add(onePerson); } string result = '[' + String.Join(",", jsonPeople.ToArray()) + ']'; Response.Output.WriteLine(result); Response.End(); }
public IActionResult Import([FromForm(Name = "file")] IFormFile file) { string filePath = string.Empty; if (file != null) { try { string fileExtension = Path.GetExtension(file.FileName); if (fileExtension != ".csv") { ViewBag.Message = "Please select the csv file"; return(RedirectToAction("ListApplicants", "Applicants")); } using (var reader = new StreamReader(file.OpenReadStream())) { string[] header = reader.ReadLine().Split(','); while (!reader.EndOfStream) { string[] rows = reader.ReadLine().Split(','); Console.WriteLine(rows[1]); Console.WriteLine(rows[2]); Console.WriteLine(rows[3]); Console.WriteLine(rows[4]); Console.WriteLine(rows[5]); Console.WriteLine(rows[6]); Console.WriteLine(rows[7]); Console.WriteLine(rows[8]); Console.WriteLine(rows[9]); Console.WriteLine(rows[10]); Console.WriteLine(rows[11]); Console.WriteLine(rows[12]); Console.WriteLine(rows[13]); Console.WriteLine(rows[14]); Console.WriteLine(rows[15]); Console.WriteLine(rows[16]); Console.WriteLine(rows[17]); Console.WriteLine(rows[18]); var emp = new Applicants() { Name = rows[1].ToString(), Email = rows[2].ToString(), Phone = rows[3].ToString(), Gender = rows[4].ToString(), BirthDate = Convert.ToDateTime(rows[5].ToString()), BirthPlace = rows[6].ToString(), Position = rows[7].ToString(), Departement = rows[8].ToString(), Address = rows[9].ToString(), Status = rows[10].ToString(), CreatedAt = Convert.ToDateTime(rows[11].ToString()), NameEmergencyContact1 = rows[12].ToString(), PhoneEmergencyContact1 = rows[13].ToString(), NameEmergencyContact2 = rows[14].ToString(), PhoneEmergencyContact2 = rows[15].ToString(), NameEmergencyContact3 = rows[16].ToString(), PhoneEmergencyContact3 = rows[17].ToString(), Image = rows[18].ToString() }; _AppDbContext.applicants.Add(emp); } _AppDbContext.SaveChanges(); } return(RedirectToAction("ListApplicants", "Applicants")); } catch (Exception e) { ; ViewBag.Message = e.Message; } } return(RedirectToAction("ListApplicants", "Applicants")); }
protected override void OnSaving() { s_ApplicantCodes = string.Join(";", Applicants.Select(a => a.Code).ToList()); s_ApplicantNames = string.Join(";", Applicants.Select(a => a.Name).ToList()); base.OnSaving(); }
public void GetPatentInfo() { EnumsAll.CaseType caseType = EnumsAll.CaseType.Internal; var sOurNo = CommonFunction.GetOurNo(_sOurNo, ref caseType); if (string.IsNullOrEmpty(sOurNo)) { return; } s_OurNo = sOurNo; switch (caseType) { case EnumsAll.CaseType.Internal: { var dr = DbHelperOra.Query( $"select RECEIVED,CLIENT,CLIENT_NAME,APPL_CODE1,APPLICANT1,APPLICANT_CH1,APPL_CODE2,APPLICANT2,APPLICANT_CH2,APPL_CODE3,APPLICANT3,APPLICANT_CH3,APPL_CODE4,APPLICANT4,APPLICANT_CH4,APPL_CODE5,APPLICANT5,APPLICANT_CH5,TITLE_CHINESE,CLIENT_NUMBER,FILING_DUE,TITLE from PATENTCASE where OURNO = '{_sOurNo}'").Tables[0].Rows[0]; s_Name = dr["TITLE_CHINESE"].ToString(); if (string.IsNullOrWhiteSpace(s_Name)) { s_Name = dr["TITLE"].ToString(); } s_ClientRef = dr["CLIENT_NUMBER"].ToString(); if (!string.IsNullOrWhiteSpace(dr["RECEIVED"].ToString())) { dt_ReceiveDate = Convert.ToDateTime(dr["RECEIVED"].ToString()); } if (!string.IsNullOrWhiteSpace(dr["FILING_DUE"].ToString())) { dt_FilingDeadline = Convert.ToDateTime(dr["FILING_DUE"].ToString()); } if (!string.IsNullOrWhiteSpace(dr["CLIENT"].ToString())) { Client = Session.FindObject <Corporation>(CriteriaOperator.Parse($"Code = '{dr["CLIENT"]}'")) ?? new Corporation(Session) { Code = dr["CLIENT"].ToString(), Name = dr["CLIENT_NAME"].ToString() } } ; Applicants.ToList().ForEach(a => Applicants.Remove(a)); for (int i = 1; i <= 5; i++) { if (!string.IsNullOrWhiteSpace(dr[$"APPL_CODE{i}"].ToString())) { Applicants.Add( Session.FindObject <Corporation>(CriteriaOperator.Parse($"Code = '{dr[$"APPL_CODE{i}"]}'")) ?? new Corporation(Session) { Code = dr[$"APPL_CODE{i}"].ToString(), Name = string.IsNullOrWhiteSpace(dr[$"APPLICANT{i}"].ToString()) ? dr[$"APPLICANT_CH{i}"].ToString() : dr[$"APPLICANT{i}"].ToString() }); } } var objDate = DbHelperOra.GetSingle( $"select duedate from generalalert where typeid = 'tohandle_presubmit' and comments like '%返稿发明人%' and ourno = '{s_OurNo}'"); if (objDate != null) { dt_ReturnInventorDate = Convert.ToDateTime(objDate); } objDate = DbHelperOra.GetSingle( $"select duedate from generalalert where typeid = 'tohandle_presubmit' and comments like '%返稿工程师%' and ourno = '{s_OurNo}'"); if (objDate != null) { dt_ReturnIPRDate = Convert.ToDateTime(objDate); } break; } case EnumsAll.CaseType.Foreign: { var dr = DbHelperOra.Query( $"select RECEIVED,CTITLE,TITLE from FCASE where OURNO = '{_sOurNo}'") .Tables[0].Rows[0]; if (!string.IsNullOrWhiteSpace(dr["RECEIVED"].ToString())) { dt_ReceiveDate = Convert.ToDateTime(dr["RECEIVED"].ToString()); } s_Name = dr["CTITLE"].ToString(); if (string.IsNullOrWhiteSpace(s_Name)) { s_Name = dr["TITLE"].ToString(); } var dt = DbHelperOra.Query($"select EID,ROLE,ORIG_NAME,TRAN_NAME,ENT_ORDER from FCASE_ENT_REL where OURNO = '{_sOurNo}'").Tables[0]; var tempclient = dt.Select("ROLE = 'CLI' OR ROLE = 'APPCLI'"); if (tempclient.Length > 0) { Client = Session.FindObject <Corporation>(CriteriaOperator.Parse($"Code = '{tempclient[0]["EID"]}'")) ?? new Corporation(Session) { Code = tempclient[0]["EID"].ToString(), Name = !string.IsNullOrWhiteSpace(tempclient[0]["ORIG_NAME"].ToString()) ? tempclient[0]["ORIG_NAME"].ToString() : tempclient[0]["TRAN_NAME"].ToString() } } ; Applicants.ToList().ForEach(a => Applicants.Remove(a)); foreach (var dataRow in dt.Select("ROLE = 'APP' OR ROLE = 'APPCLI'", "ENT_ORDER ASC")) { Applicants.Add( Session.FindObject <Corporation>(CriteriaOperator.Parse($"Code = '{dataRow["EID"]}'")) ?? new Corporation(Session) { Code = dataRow["EID"].ToString(), Name = !string.IsNullOrWhiteSpace(dataRow["ORIG_NAME"].ToString()) ? dataRow["ORIG_NAME"].ToString() : dataRow["TRAN_NAME"].ToString() }); } break; } } var sOurNoShort = s_OurNo.Substring(0, s_OurNo.IndexOf("-", StringComparison.Ordinal)); if (sOurNoShort.Contains("I")) { s_PatentType = EnumsAll.PatentType.发明; } else if (sOurNoShort.Contains("U")) { s_PatentType = EnumsAll.PatentType.实用新型; } else if (sOurNoShort.Contains("D")) { s_PatentType = EnumsAll.PatentType.外观设计; } else if (sOurNoShort.Contains("CR")) { s_PatentType = EnumsAll.PatentType.软件著作权; } Save(); } }
public People FilterPeople(People rawList, AccessAspect aspect = AccessAspect.Participation) { if (!this.Person.TwoFactorEnabled) { if (this.Organization.Identity != Organization.SandboxIdentity) { // GPDR compliance: to see any personal data, require 2FA to be turned on return(new People()); } } if (aspect != AccessAspect.Participation && aspect != AccessAspect.PersonalData) { throw new ArgumentException(@"AccessAspect needs to reflect visibility of people data", "aspect"); } // Three cases: // 1) the current Position has system-level access. // 2) the current Position has org-level, but not system-level, access. // 3) the current Position has org-and-geo-level access. Dictionary <int, bool> orgLookup = new Dictionary <int, bool>(); Dictionary <int, bool> geoLookup = new Dictionary <int, bool>(); People result = new People(); // Org lookup will always be needed. Geo lookup may be needed for case 3. Organizations orgStructure = this.Organization.ThisAndBelow(); int[] orgIds = orgStructure.Identities; foreach (int orgId in orgIds) { orgLookup[orgId] = true; } orgLookup[Organization.Identity] = true; Dictionary <int, List <BasicParticipation> > membershipLookup = null; Dictionary <int, List <BasicApplicant> > applicantLookup = null; if (HasSystemAccess(AccessType.Read) || HasAccess(new Access(Organization, aspect, AccessType.Read))) { // cases 1 and 2: systemwide access, return everybody at or under the current Organization, // or org-wide read access (at least) to participant/personal data at current Organization // Optimization: Get all memberships in advance, without instantiating logic objects membershipLookup = Participations.GetParticipationsForPeople(rawList, 0); applicantLookup = Applicants.GetApplicantsFromPeople(rawList); foreach (Person person in rawList) { // For each person, we must test the list of active memberships to see if one of // them is visible to this Authority - if it's a membership in an org at or below the // Authority object's organization if (membershipLookup.ContainsKey(person.Identity)) { List <BasicParticipation> list = membershipLookup[person.Identity]; foreach (BasicParticipation basicMembership in list) { if (orgLookup.ContainsKey(basicMembership.OrganizationId)) { // hit - this person has an active membership that makes them visible to this Authority result.Add(person); break; } } } // If membership check fails, then check for membership applications if (applicantLookup.ContainsKey(person.Identity)) { List <BasicApplicant> applicantList = applicantLookup[person.Identity]; foreach (BasicApplicant applicant in applicantList) { if (orgLookup.ContainsKey(applicant.OrganizationId)) { // hit - this person has an active membership _application_ that makes them visible to this Authority result.Add(person); break; } } } } return(result); } // Case 3: Same as above but also check for Geography (in an AND pattern). if (this.Position == null) { // No access at all. That was an easy case! return(new People()); // return empty list } if (this.Position.Geography == null) { // Org-level position, but one that doesn't have access to personal data, apparently. return(new People()); // empty list again } if (!HasAccess(new Access(this.Organization, Position.Geography, aspect, AccessType.Read))) { // No people access for active position. Also a reasonably easy case. return(new People()); // also return empty list } Geographies geoStructure = this.Position.Geography.ThisAndBelow(); int[] geoIds = geoStructure.Identities; foreach (int geoId in geoIds) { geoLookup[geoId] = true; } geoLookup[Position.GeographyId] = true; // Optimization: Get all memberships in advance, without instantiating logic objects Dictionary <int, List <BasicParticipation> > personLookup = Participations.GetParticipationsForPeople(rawList, 0); applicantLookup = Applicants.GetApplicantsFromPeople(rawList); foreach (Person person in rawList) { // For each person, we must test the list of active memberships to see if one of // them is visible to this Authority - if it's a membership in an org at or below the // Authority object's organization - and also test the person's Geography against // the list (lookup) of visible Geographies. We do Geographies first, because that test is // much cheaper. if (geoLookup[person.GeographyId]) { // Geography hit. Test Membership / Organization. bool added = false; List <BasicParticipation> participationList = personLookup[person.Identity]; foreach (BasicParticipation basicMembership in participationList) { if (orgLookup.ContainsKey(basicMembership.OrganizationId) && !added) { // Organization hit - this person has an active membership that makes them visible to this Authority result.Add(person); added = true; } } List <BasicApplicant> applicantList = applicantLookup[person.Identity]; foreach (BasicApplicant basicApplicant in applicantList) { if (orgLookup.ContainsKey(basicApplicant.OrganizationId) && !added) { result.Add(person); added = true; } } } } return(result); }