public async Task <IActionResult> Edit(int id, [Bind("SchName,SchAmount,SchDetails,SchId")] Scholarship scholarship) { if (id != scholarship.SchId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(scholarship); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ScholarshipExists(scholarship.SchId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(scholarship)); }
public ActionResult _CreateScholarship(Scholarship scholarship) { scholarship.ValidationPeriod = db.WebSettings.FirstOrDefault().ValidationPeriod; db.Scholarships.Add(scholarship); db.SaveChanges(); return(RedirectToAction("Scholarships", "Admin")); }
public ActionResult _ReviewList(HttpPostedFileBase file) { List <PreValidatedStudent> scholars = new List <PreValidatedStudent>(); var excel = new ExcelPackage(file.InputStream); ExcelWorksheet worksheet = excel.Workbook.Worksheets[1]; //validation for (int i = 12; i <= worksheet.Dimension.End.Row; i++) { //validation //scholarhsip type, student id //loop all columns in a row string studentID = worksheet.Cells[i, 4].Value.ToString(); int scholarshipID = Convert.ToInt32(worksheet.Cells[i, 5].Value); Scholarship type = db.Scholarships.Where(e => e.ScholarshipID.Equals(scholarshipID)).FirstOrDefault(); ValidationPeriod period = db.WebSettings.FirstOrDefault().ValidationPeriod; AspNetUser user = db.AspNetUsers.Where(e => e.UserProfiles.FirstOrDefault().StudentProfile.StudentID.Equals(studentID)).FirstOrDefault(); PreValidatedStudent tempScholar = new PreValidatedStudent(); tempScholar.ScholarshipID = type.ScholarshipID; tempScholar.PeriodID = period.PeriodID; tempScholar.UserID = user.Id; tempScholar.Scholarship = type; tempScholar.ValidationPeriod = period; tempScholar.AspNetUser = user; scholars.Add(tempScholar); } TempData["Scholars"] = scholars; return(PartialView("_ReviewList", scholars)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Amount,StudentId")] Scholarship scholarship) { if (id != scholarship.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(scholarship); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ScholarshipExists(scholarship.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["StudentId"] = new SelectList(_context.StudentViewModel, "id", "FullName", scholarship.StudentId); return(View(scholarship)); }
public bool IsExcelFileValid(ExcelPackage excel) { if (excel.Workbook.Worksheets.ToList().Count != 1) { return(false); } ExcelWorksheet worksheet = excel.Workbook.Worksheets[1]; for (int i = worksheet.Dimension.Start.Row + 11; i <= worksheet.Dimension.End.Row; i++) { string studentID = worksheet.Cells[i, 4].Value.ToString(); AspNetUser user = db.AspNetUsers.Where(e => e.UserProfiles.First().StudentProfile.StudentID.Equals(studentID)).FirstOrDefault(); if (user == null) { return(false); } string excelScholarshipType = worksheet.Cells[i, 5].Value.ToString(); Scholarship type = db.Scholarships.Where(e => e.ScholarshipID.Equals(excelScholarshipType)).FirstOrDefault(); if (type == null) { return(false); } } return(true); }
public ActionResult EditScholarship(Scholarship type) { Scholarship scholarship = db.Scholarships.Where(e => e.ScholarshipID.Equals(type.ScholarshipID)).FirstOrDefault(); db.SaveChanges(); return(View(scholarship)); }
public async Task <IActionResult> PutScholarship([FromRoute] int id, [FromBody] Scholarship Scholarship) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != Scholarship.Id) { return(BadRequest()); } dbContext.Entry(Scholarship).State = EntityState.Modified; try { await dbContext.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ScholarshipExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Applications(int id) // id = ScholarshipId { Scholarship scholarship = await _context.Scholarship.FirstOrDefaultAsync(s => s.ScholarshipId == id); if (scholarship == null) { return(NotFound()); } List <Application> applications = await _context.Application.Include(ap => ap.Profile) .Where(s => s.ScholarshipId == id && s.Submitted) .OrderByDescending(s => s.ApplicantAwarded).ThenByDescending(s => s.ApplicantScore).ThenBy(s => s.Profile.LastName).ThenBy(s => s.Profile.FirstName) .ToListAsync(); ApplicationViewModel vm = new ApplicationViewModel { Scholarship = scholarship, Applications = applications }; if (!await CanAccessScholarship(vm.Scholarship.ScholarshipId)) { return(NotFound()); } return(View(vm)); }
public ActionResult UploadScholarshipDetails(Scholarship scholarship, string newDescription) { try { scholarship.ScholarshipDescription = scholarship.ScholarshipDescription + " " + newDescription; ModelState.Remove("newDescription"); if (ModelState.IsValid) { if (User.IsInRole("Administrator")) { websiteActions.UpdateScholarship(scholarship); return(RedirectToAction("ScholarshipSelection", "WebsiteContent")); } else { TempData["errorMessage"] = "Sorry you do not have access."; return(RedirectToAction("ScholarshipSelection", "WebsiteContent")); } } else { return(View(scholarship)); } } catch (Exception e) { TempData["errorMessage"] = "There was an error in updating the scholarship you wish to edit." + e.ToString(); return(RedirectToAction("ScholarshipSelection")); } }
private void delScholarshipBtn_Click(object sender, EventArgs e) { List <string> checkedScholarships = new List <string>(); int checkBoxColumn = scholarshipGridView.Columns.Count - 1; //List marked scholarships foreach (DataGridViewRow rw in this.scholarshipGridView.Rows) { if (rw.Cells[checkBoxColumn].Value != null && Convert.ToBoolean(rw.Cells[checkBoxColumn].Value) == true) { checkedScholarships.Add(rw.Cells[0].Value.ToString()); } } using (Entities context = new Entities()) { //Delete each marked scholarship foreach (string i in checkedScholarships) { Scholarship scholarship = context.Scholarships.FirstOrDefault(s => s.Scholership_Name == i); context.Scholarships.Remove(scholarship); } //Save changes and reload grid context.SaveChanges(); reloadDataGridView(context); } scholarshipGridView.Refresh(); }
public ActionResult DeleteScholarship(int id) { Scholarship scholarship = db.Scholarships.Where(e => e.ScholarshipID.Equals(id)).FirstOrDefault(); db.Scholarships.Remove(scholarship); db.SaveChanges(); return(RedirectToAction("Scholarships")); }
private void Select_Click(object sender, EventArgs e) { using (MazalEntities context = new MazalEntities()) { Scholarship scholarship = context.Scholarships.FirstOrDefault(s => s.Scholership_Name == "Hachvana"); MessageBox.Show(scholarship.Grant_Amount_shekel_.ToString()); } }
private void Update_Click(object sender, EventArgs e) { using (MazalEntities context = new MazalEntities()) { Scholarship scholarship = context.Scholarships.FirstOrDefault(s => s.Scholership_Name == "Perach"); scholarship.Volunteer_hours++; context.SaveChanges(); } }
private void Remove_Click(object sender, EventArgs e) { using (MazalEntities context = new MazalEntities()) { Scholarship scholarship = context.Scholarships.FirstOrDefault(s => s.Scholership_Name == "Nachshon"); context.Scholarships.Remove(scholarship); context.SaveChanges(); } }
public void TestarIdsNewGuild() { // Arrange var instance = new Scholarship(); instance.Id = default(Guid); // Assert Assert.AreEqual(Guid.Empty, instance.Id); }
/// <summary> /// To update Scholarship details /// </summary> /// <param name="id">scholarshipId</param> /// <param name="scholarshipObj">scholarship Object</param> public void Put(string id, Scholarship scholarshipObj) { try { scholarshipObj.JobSeekerId = SkillsmartUser.GuidStr(HttpContext.Current.User); scholarshipObj.Id = new Guid(id); scholarshipObj.Id = new Guid(id); ServiceFactory.GetJobSeekerScholarship().Update(scholarshipObj); } catch (Exception exp) {} }
public async Task <IActionResult> Create([Bind("SchName,SchAmount,SchDetails,SchId")] Scholarship scholarship) { if (ModelState.IsValid) { _context.Add(scholarship); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(scholarship)); }
public static bool IsAVoucher(Scholarship scholarship) { if (scholarship.ScholarshipType.ScholarshipTypeName.ToLower() == "voucher") { return(true); } else { return(false); } }
public async Task PersistScholarshipReddeUssdData(string requestString) { using (var scope = serviceFactory.CreateScope()) { dbContext = scope.ServiceProvider.GetRequiredService <NtoboaFundDbContext>(); //types : lkm,bus,sch var regex = new Regex(@"^(?<type>\w+)\*(?<amount>\d+)-(?<period>\w+)-(?<institution>[\w\s]+)-(?<program>[\w\s]+)-(?<studentid>[\w\s]+)-(?<playertype>\d+)-(?<momonumber>\d+)-(?<voucher>[\w\s]+)-(?<usernumber>\d+)$").Match(requestString); var type = regex.Groups["type"].ToString(); var amount = regex.Groups["amount"].ToString(); var period = regex.Groups["period"].ToString(); var institution = regex.Groups["institution"].ToString(); var program = regex.Groups["program"].ToString(); var studentId = regex.Groups["studentid"].ToString(); var playerType = regex.Groups["playertype"].ToString(); var voucher = regex.Groups["voucher"].ToString(); var mobileNumber = "0" + Misc.NormalizePhoneNumber(regex.Groups["usernumber"].ToString()); var momoNumber = "0" + Misc.NormalizePhoneNumber(regex.Groups["momonumber"].ToString()); var user = await getMatchedUser(dbContext, mobileNumber); var txRef = Misc.getTxRef(mobileNumber); var scholarship = new Scholarship { Amount = Convert.ToDecimal(amount), Date = DateTime.Now.ToLongDateString(), AmountToWin = Convert.ToDecimal(amount) * Constants.ScholarshipStakeOdds, Status = "pending", TxRef = txRef, Period = period, User = user, Institution = institution, Program = program, StudentId = studentId, PlayerType = Misc.getPlayerType(playerType) }; try { var transactionId = await Misc.GenerateAndSendReddeMomoInvoice(EntityTypes.Scholarship, scholarship, Settings.ReddeSettings, $"{Misc.FormatGhanaianPhoneNumberWp(momoNumber)}*{voucher}"); scholarship.TransferId = transactionId; dbContext.Scholarships.Add(scholarship); await dbContext.SaveChangesAsync(); } catch (Exception ex) { } } }
public async Task <IActionResult> Create([Bind("Id,Amount,StudentId")] Scholarship scholarship) { if (ModelState.IsValid) { _context.Add(scholarship); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["StudentId"] = new SelectList(_context.StudentViewModel, "id", "FullName", scholarship.StudentId); return(View(scholarship)); }
////edit post protected void SaveEdit_Click(object sender, EventArgs e) { if ((txtEditTitle.Text == "") || (txtEditREward.Value == "")) { StringBuilder builder = new StringBuilder(); builder.Append("<script language=JavaScript> ShowEdit(); </script>\n"); Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowEdit", builder.ToString()); lblEditError.Text = "Please enter all required values."; } else { Post post = new Post(1, "Scholarship", HttpUtility.HtmlEncode(txtEditTitle.Text), HttpUtility.HtmlEncode(txtEditDescription.Text)); localDB.Open(); System.Data.SqlClient.SqlCommand editPost = new System.Data.SqlClient.SqlCommand(); editPost.Connection = localDB; editPost.CommandText = "Execute EditPost @id, @title, @PostDate, @description, @lastUpdatedBy, @LastUpdated"; editPost.Parameters.Add("@id", SqlDbType.Int).Value = id.Text; editPost.Parameters.Add("@title", SqlDbType.VarChar, 100).Value = post.getTitle(); editPost.Parameters.Add("@PostDate", SqlDbType.VarChar, 30).Value = post.getPostDate(); editPost.Parameters.Add("@description", SqlDbType.VarChar, 500).Value = post.getDescription(); editPost.Parameters.Add("@lastUpdatedBy", SqlDbType.VarChar, 30).Value = post.getLastUpdatedBy(); editPost.Parameters.Add("@LastUpdated", SqlDbType.VarChar, 30).Value = post.getLastUpdated(); editPost.ExecuteNonQuery(); try { DateTime start = DateTime.Parse(txtEditDueDate.Value); txtEditDueDate.Value = start.ToString("MM/dd/yyyy"); } catch { } Scholarship sch = new Scholarship(id.Text, HttpUtility.HtmlEncode(txtEditRequirements.Text), HttpUtility.HtmlEncode(txtEditREward.Value), HttpUtility.HtmlEncode(txtEditDueDate.Value)); System.Data.SqlClient.SqlCommand editjob = new System.Data.SqlClient.SqlCommand(); editjob.Connection = localDB; editjob.CommandText = "Execute EditScholarship @id, @requirements, @reward, @duedate, @lastUpdatedBy, @lastUpdated"; editjob.Parameters.Add("@id", SqlDbType.Int).Value = sch.getpostID(); editjob.Parameters.Add("@requirements", SqlDbType.VarChar, 100).Value = sch.getReqs(); editjob.Parameters.Add("@reward", SqlDbType.VarChar, 30).Value = sch.getReward(); editjob.Parameters.Add("@duedate", SqlDbType.VarChar, 30).Value = sch.getDueDate(); editjob.Parameters.Add("@lastUpdatedBy", SqlDbType.VarChar, 30).Value = sch.getLastUpdatedBy(); editjob.Parameters.Add("@lastUpdated", SqlDbType.VarChar, 30).Value = sch.getLastUpdated(); editjob.ExecuteNonQuery(); localDB.Close(); showData(); } }
public void TestarOwnerNaoNull() { // Arrange var instance = new Scholarship(); instance.Owner = "NonEmptyString"; // Act instance.ToString(); // Assert Assert.AreNotEqual(instance.Owner, ""); }
private void gvScholarship_SelectionChanged(object sender, EventArgs e) { int selectedIndex = gvScholarship.CurrentRow.Index; if (selectedIndex >= 0) { string sID = gvScholarship.Rows[selectedIndex].Cells["ScholarshipCode"].Value.ToString(); List <Scholarship> item = new List <Scholarship>(); item = scholarshipList.FindAll(x => x.ScholarshipCode.ToString() == sID); scholarshipSelected = new Scholarship(); scholarshipSelected = (Scholarship)item[0]; } }
private void Save() { ScholarshipServiceClient scholarshipService = new ScholarshipServiceClient(); Boolean ret = false; string message = String.Empty; Scholarship scholarship = new Scholarship() { ScholarshipCode = txtScholarshipCode.Text.ToString(), Privilege = txtPrivilege.Text.ToString(), Condition = txtCondition.Text.ToString(), Description = txtDescription.Text.ToString() //StopRightHere }; }
public ActionResult EditScholarship(Scholarship model) { Scholarship scholarship = db.Scholarships.Where(e => e.ScholarshipID.Equals(model.ScholarshipID)).FirstOrDefault(); scholarship.ScholarshipName = model.ScholarshipName; scholarship.ScholarshipDescription = model.ScholarshipDescription; scholarship.ApplicationForm = model.ApplicationForm; scholarship.ScholarshipTypeID = model.ScholarshipTypeID; db.SaveChanges(); TempData["Message"] = "Changes saved successfully"; TempData["MessageType"] = "success"; return(RedirectToAction("Scholarships", "Admin")); }
private void gvScholarship_SelectionChanged(object sender, EventArgs e) { int selectedIndex = gvScholarship.CurrentRow.Index; if (selectedIndex >= 0) { string sID = gvScholarship.Rows[selectedIndex].Cells["ScholarshipCode"].Value.ToString(); List<Scholarship> item = new List<Scholarship>(); item = scholarshipList.FindAll(x => x.ScholarshipCode.ToString() == sID); scholarshipSelected = new Scholarship(); scholarshipSelected = (Scholarship)item[0]; } }
public async Task <List <ScholarshipFieldStatus> > VerifyApplicationStatus(Scholarship scholarship) { List <ScholarshipFieldStatus> status = new List <ScholarshipFieldStatus>(); ICollection <ValidationResult> results = new List <ValidationResult>(); Profile profile = await GetProfileAsync(); ValidationContext vc = new ValidationContext(profile); bool isValid = Validator.TryValidateObject(profile, vc, results, true); foreach (var result in results) { List <string> MemberNames = result.MemberNames.ToList(); if (MemberNames.Count > 0) { string field = MemberNames[0]; ScholarshipProfileProperty prop = scholarship.ProfileProperties.FirstOrDefault(p => p.ProfileProperty.PropertyKey == field); if (prop != null) { status.Add(new ScholarshipFieldStatus { FieldName = prop.ProfileProperty.PropertyName, ErrorMessage = result.ErrorMessage.Replace(prop.ProfileProperty.PropertyKey, prop.ProfileProperty.PropertyName), Validated = false, FormURI = ProfileFieldToURI(MemberNames[0]) }); } } } var guardprop = scholarship.ProfileProperties.FirstOrDefault(gprop => gprop.ProfileProperty.PropertyKey == "Guardians"); if (guardprop != null) { if (profile.Guardians.Count == 0) { status.Add(new ScholarshipFieldStatus { FieldName = guardprop.ProfileProperty.PropertyName, ErrorMessage = "You must have at least one family member listed in the Family Income section of your profile", Validated = false, FormURI = ProfileFieldToURI("Guardians") }); } } return(status); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Scholarship = await _context.Scholarships.FirstOrDefaultAsync(m => m.ScholarshipID == id); if (Scholarship == null) { return(NotFound()); } return(Page()); }
public List <Scholarship> getScholarshipManual(string sql) { List <Scholarship> scholarshipData = new List <Scholarship>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); //oracleObj.SelectCommand = "Select * From SCHOLARSHIP Order By ACADEMIC_YEAR"; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { Scholarship scholarship_data = new Scholarship(); scholarship_data.SCHOLARSHIP_ACADEMIC_YEAR = rowData["ACADEMIC_YEAR"].ToString(); scholarship_data.SCHOLARSHIP_SEMESTER = rowData["SEMESTER"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLARSHIP_CODE = rowData["SCHOLARSHIP_CODE"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLARSHIP_THAINAME = rowData["SCHOLARSHIP_THAINAME"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLARSHIP_ENGNAME = rowData["SCHOLARSHIP_ENGNAME"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLARSHIP_IN_OUT = rowData["SCHOLARSHIP_IN_OUT"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLARSHIP_TYPE = rowData["SCHOLARSHIP_TYPE"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLARSHIP_SOURCE = rowData["SCHOLARSHIP_SOURCE"].ToString(); scholarship_data.SCHOLARSHIP_NEW_REGIS_FEE = rowData["NEW_REGIS_FEE"].ToString(); scholarship_data.SCHOLARSHIP_PROPERTIES_FEE = rowData["PROPERTIES_FEE"].ToString(); scholarship_data.SCHOLARSHIP_STUDY_FACILITY_FEE = rowData["STUDY_FACILITY_FEE"].ToString(); scholarship_data.SCHOLARSHIP_IT_FEE = rowData["IT_FEE"].ToString(); scholarship_data.SCHOLARSHIP_LIBRARY_FEE = rowData["LIBRARY_FEE"].ToString(); scholarship_data.SCHOLARSHIP_HEALTH_FEE = rowData["HEALTH_FEE"].ToString(); scholarship_data.SCHOLARSHIP_ACTIVITY_FEE = rowData["ACTIVITY_FEE"].ToString(); scholarship_data.SCHOLARSHIP_CREDIT_3000 = rowData["CREDIT_3000"].ToString(); scholarship_data.SCHOLARSHIP_ACCIDENT_FEE = rowData["ACCIDENT_FEE"].ToString(); scholarship_data.SCHOLARSHIP_ACADEMIC_FEE_BACHELOR = rowData["ACADEMIC_FEE_BACHELOR"].ToString(); scholarship_data.SCHOLARSHIP_SPECIAL_PROJECT_FEE = rowData["SPECIAL_PROJECT_FEE"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLAR_FEE_COMMENT = rowData["SCHOLAR_FEE_COMMENT"].ToString(); scholarship_data.SCHOLARSHIP_MULTIPLE_SCHOLARSHIP = rowData["MULTIPLE_SCHOLARSHIP"].ToString(); scholarship_data.SCHOLARSHIP_ACADEMIC_FEE_MASTER = rowData["ACADEMIC_FEE_MASTER"].ToString(); scholarship_data.SCHOLARSHIP_FINE_FEE = rowData["FINE_FEE"].ToString(); scholarship_data.SCHOLARSHIP_THEORY_PRACTICE_FEE = rowData["THEORY_PRACTICE_FEE"].ToString(); scholarship_data.SCHOLARSHIP_THESIS_FEE = rowData["THESIS_FEE"].ToString(); scholarship_data.SCHOLARSHIP_SCHOLARSHIP_STATUS = rowData["SCHOLARSHIP_STATUS"].ToString(); scholarshipData.Add(scholarship_data); } return(scholarshipData); }
public async Task<IActionResult> OnPostAsync(int? id) { if (id == null) { return NotFound(); } Scholarship = await _context.Scholarships.FindAsync(id); if (Scholarship != null) { _context.Scholarships.Remove(Scholarship); await _context.SaveChangesAsync(); } return RedirectToPage("./Index"); }
private void Insert_Click(object sender, EventArgs e) { using (MazalEntities context = new MazalEntities()) { Scholarship nachshon = new Scholarship { Scholership_ID = "4", Grant_Amount_shekel_ = 10000, Scholership_Name = "Nachshon", Intended_for = "Any", Duration_years_ = 1, Volunteer_hours = 150 }; context.Scholarships.Add(nachshon); context.SaveChanges(); } }