public ActionResult Create() { LibraryLog logDetails = new LibraryLog(); //ViewBag.BookCategory = bookCategoryRepository.Get(); return(View(logDetails)); }
public ActionResult Delete(int?Id) { if (Id.HasValue) { LibraryLog logDetails = libraryLogRepository.Get(Id.Value); return(View(logDetails)); } return(RedirectToActionPermanent("list")); }
public ActionResult Edit(int?Id) { //ViewBag.BookCategory = bookCategoryRepository.Get(); if (Id.HasValue) { LibraryLog logDetails = libraryLogRepository.Get(Id.Value); return(View(logDetails)); } return(RedirectToActionPermanent("list")); }
public ActionResult Delete(LibraryLog logDetails) { try { libraryLogRepository.Delete(logDetails.Id); return(RedirectToActionPermanent("List")); } catch (Exception ex) { ViewBag.Error = ex.Message; } return(View(logDetails)); }
public ActionResult Create(LibraryLog logDetails) { try { if (logDetails.IsValid) { libraryLogRepository.Add(logDetails); return(RedirectToActionPermanent("List")); } } catch (Exception ex) { ViewBag.Error = ex.Message; } return(View(logDetails)); }
//public static bool TruncateTable() //{ // connectionString = GetAppPath(@"\Zoiperdb.sdf"); // string query = "DELETE from TblPhoneContact"; // string dropConstraint = @"ALTER TABLE [TblPhoneContact] DROP CONSTRAINT [PK__TblPhoneContact__0000000000000019]"; // string dropIdColumn = "ALTER TABLE[TblPhoneContact] DROP COLUMN[Id]"; // string addIdColumn = @"ALTER TABLE [TblPhoneContact] ADD [Id] int IDENTITY (1,1) NOT NULL"; // string addIdConstraint = "ALTER TABLE[TblPhoneContact] ADD CONSTRAINT[PK__TblPhoneContact__0000000000000019] PRIMARY KEY ([Id])"; // bool result = false; // try // { // dbContext = new ZoiperdbContext(connectionString); // if (dbContext.DatabaseExists()) // { // int idropConstraint = dbContext.ExecuteCommand(dropConstraint); // if (idropConstraint >= 0) // result = true; // int idropIdColumn = dbContext.ExecuteCommand(dropIdColumn); // if (idropIdColumn >= 0) // result = true; // int iQuery = dbContext.ExecuteCommand(query); // if (iQuery >= 0) // result = true; // int iaddIdColumn = dbContext.ExecuteCommand(addIdColumn); // int iaddIdConstraint = dbContext.ExecuteCommand(addIdConstraint); // } // } // catch (Exception ex) // { // LibraryLog.WriteErrorLog(ex); // } // return result; //} /// <summary> /// Get User account for calling /// </summary> /// <returns></returns> public static string GetSettings() { string account = string.Empty; try { //AuthenticateConnectionToDB(); dbContext = new ZoiperdbContext(AuthenticateConnectionToDB()); TblZoiperSetting tblSetting = dbContext.TblZoiperSetting.FirstOrDefault(); account = tblSetting.CallerId + "@" + tblSetting.Domain; } catch (Exception ex) { LibraryLog.WriteErrorLog(ex); } return(account); }
public ActionResult Edit(LibraryLog logDetails) { try { if (logDetails.IsValid) { libraryLogRepository.Update(logDetails); } List <LibraryLog> logList = libraryLogRepository.Get(); return(RedirectToActionPermanent("List")); } catch (Exception ex) { ViewBag.Error = ex.Message; } return(View(logDetails)); }
public static int GetServiceDuration() { connectionString = GetAppPath(@"\Zoiperdb.sdf"); //GetPath(@"..\..\SqlData\Zoiperdb.sdf"); dbContext = new ZoiperdbContext(connectionString); int duration = 0; try { TblZoiperSetting setting = dbContext.TblZoiperSetting.FirstOrDefault(); duration = setting.ServiceDuration; } catch (Exception ex) { logger.Error(ex, ex?.Message); LibraryLog.WriteErrorLog(ex); duration = Convert.ToInt32(false); } return(duration); }
public async Task <Book> UpdateIsAvailable(int id, bool newStatus) { // var book = await _bookRepository.GetBookById(id); book.IsAvailable = newStatus; LibraryLog log = new LibraryLog(); log.BookId = id; log.Operation = Operations.Update; log.Date = DateTime.Now; _libraryLogRepository.AddLog(log); return(await _bookRepository.UpdateBook(book)); }
//Remove book using id and add a log for it using unit of work principle public async Task RemoveBook(int id) { var book = await GetBookById(id); LibraryLog log = new LibraryLog(); log.BookId = id; log.Operation = Operations.Delete; log.Date = DateTime.Now; _libraryLogRepository.AddLog(log); _bookRepository.RemoveBook(book); await _bookRepository.CommitChange(); }
//CREATE public void AddLog(LibraryLog log) { _dbContext.LibraryLogs.Add(log); }