public async Task <IActionResult> Edit(int id, AcademicSession academicSession) { if (id != academicSession.Id) { return(NotFound()); } try { var loggedInUser = await _userManager.FindByNameAsync(HttpContext.User.Identity.Name); academicSession.Status = 1; academicSession.InstitutionId = (int)loggedInUser.InstitutionId; var tempAcademicSession = await _context.AcademicSessions.Where(m => m.Id == academicSession.Id).FirstOrDefaultAsync(); tempAcademicSession.Name = academicSession.Name; _context.Update(tempAcademicSession); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AcademicSessionExists(academicSession.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); }
public static int Insert(AcademicSession AcademicSession) { int id = RepositoryManager.AcademicSession_Repository.Insert(AcademicSession); InvalidateCache(); return(id); }
public static bool Update(AcademicSession AcademicSession) { bool isExecute = RepositoryManager.AcademicSession_Repository.Update(AcademicSession); InvalidateCache(); return(isExecute); }
public bool Update(AcademicSession AcademicSession) { bool isInsert = false; bool isUpate = false; try { db = EnterpriseLibraryContainer.Current.GetInstance <Database>(); DbCommand cmd = db.GetStoredProcCommand("AcademicSessionUpdate"); db = AddParam(db, cmd, AcademicSession, isInsert); int rowAffected = db.ExecuteNonQuery(cmd); if (rowAffected > 0) { isUpate = true; } } catch (Exception ex) { throw ex; } return(isUpate); }
public int Insert(AcademicSession AcademicSession) { int id = 0; bool isInsert = true; try { db = EnterpriseLibraryContainer.Current.GetInstance <Database>(); DbCommand cmd = db.GetStoredProcCommand("AcademicSessionInsert"); db = AddParam(db, cmd, AcademicSession, isInsert); db.ExecuteNonQuery(cmd); Object obj = db.GetParameterValue(cmd, "Id"); if (obj != null) { int.TryParse(obj.ToString(), out id); } } catch (Exception ex) { throw ex; } return(id); }
public async Task <ActionResult <AcademicSession> > PostAcademicSession(AcademicSession academicSession) { _context.AcademicSessions.Add(academicSession); await _context.SaveChangesAsync(); return(CreatedAtAction("GetAcademicSession", new { id = academicSession.AcademicSessionId }, academicSession)); }
public async Task <IActionResult> PutAcademicSession(int id, AcademicSession academicSession) { if (id != academicSession.AcademicSessionId) { return(BadRequest()); } _context.Entry(academicSession).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AcademicSessionExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Create(AcademicSession academicSession) { var loggedInUser = await _userManager.FindByNameAsync(HttpContext.User.Identity.Name); academicSession.Status = 1; academicSession.InstitutionId = (int)loggedInUser.InstitutionId; if (ModelState.IsValid) { _context.Add(academicSession); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(academicSession)); }
public IActionResult GetAcademicSession([FromRoute] string id) { using (var client = _client) { var response = client.GetAsync(BuildSingleRecordUrl <AcademicSession>(id)); var decoded = response.Result.Content.ReadAsStringAsync().Result; var result = JsonConvert.DeserializeObject <CrmAcademicSession>(decoded); var session = new AcademicSession(result); serializer = new OneRosterSerializer("user"); session.AsJson(serializer.writer, BaseUrl()); return(JsonOk(serializer.Finish())); } }
private string AcademicSessions() { var sessions = db.AcademicSessions; var sb = new StringBuilder(); using (var csv = new CsvWriter(new StringWriter(sb))) { AcademicSession.CsvHeader(csv); foreach (var session in sessions) { session.AsCsvRow(csv); } return(sb.ToString()); } }
public static AcademicSession GetById(int?id) { // return RepositoryAdmission.Program_Repository.GetById(id); string rawKey = "AcademicSessionById" + id; AcademicSession AcademicSession = GetCacheItem(rawKey); if (AcademicSession == null) { // Item not found in cache - retrieve it and insert it into the cache AcademicSession = RepositoryManager.AcademicSession_Repository.GetById(id); if (AcademicSession != null) { AddCacheItem(rawKey, AcademicSession); } } return(AcademicSession); }
public AcademicSession GetById(int?id) { AcademicSession AcademicSession = null; try { db = EnterpriseLibraryContainer.Current.GetInstance <Database>(); IRowMapper <AcademicSession> rowMapper = GetMaper(); var accessor = db.CreateSprocAccessor <AcademicSession>("AcademicSessionGetById"); AcademicSession = accessor.Execute(id).FirstOrDefault(); } catch (Exception ex) { throw; } return(AcademicSession); }
private Database AddParam(Database db, DbCommand cmd, AcademicSession AcademicSession, bool isInsert) { if (isInsert) { db.AddOutParameter(cmd, "Id", DbType.Int32, Int32.MaxValue); } else { db.AddInParameter(cmd, "Id", DbType.Int32, AcademicSession.Id); } db.AddInParameter(cmd, "Code", DbType.String, AcademicSession.Code); db.AddInParameter(cmd, "AcademicSessionTypeId", DbType.Int32, AcademicSession.AcademicSessionTypeId); db.AddInParameter(cmd, "IsCurrent", DbType.Boolean, AcademicSession.IsCurrent); db.AddInParameter(cmd, "IsNext", DbType.Boolean, AcademicSession.IsNext); db.AddInParameter(cmd, "CreatedBy", DbType.Int32, AcademicSession.CreatedBy); db.AddInParameter(cmd, "CreatedDate", DbType.DateTime, AcademicSession.CreatedDate); db.AddInParameter(cmd, "ModifiedBy", DbType.Int32, AcademicSession.ModifiedBy); db.AddInParameter(cmd, "ModifiedDate", DbType.DateTime, AcademicSession.ModifiedDate); return(db); }
public static AcademicSession GetCacheItem(string rawKey) { AcademicSession item = (AcademicSession)HttpRuntime.Cache[GetCacheKey(rawKey)]; return(item); }