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