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);
}
