public int Delete(int id)
{
int affectedRows = 0;
using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
{
using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
OnlineDrive deleteModel = dbo.OnlineDrives.Find(id);
dbo.OnlineDrives.Remove(deleteModel);
affectedRows = dbo.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
finally
{
transaction.Dispose();
}
}
}
return(affectedRows);
}
public int Post(Menu model)
{
int affectedRows = 0;
using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
{
using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
dbo.Menus.Add(model);
affectedRows = dbo.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
finally
{
transaction.Dispose();
}
}
}
return(affectedRows);
}
public List <OnlineDrive> Get(int id)
{
this.ListOnlineDrive.Clear();
using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
{
using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
var queries = from o in dbo.OnlineDrives
where o.Id == id
select o;
foreach (var row in queries)
{
this.ListOnlineDrive.Add(new OnlineDrive
{
Id = row.Id,
FileNameGUID = row.FileName,
FileName = row.FileName,
FilePath = row.FilePath,
UploadedOn = row.UploadedOn,
UploadedBy = row.UploadedBy,
LastUpdatedOn = row.LastUpdatedOn,
LastUpdatedBy = row.LastUpdatedBy
});
}
//transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
finally
{
transaction.Dispose();
}
}
}
return(this.ListOnlineDrive);
}
public List <Menu> Get(int id)
{
this.ListMenu.Clear();
using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
{
using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
var queries = from o in dbo.Menus
where o.PageID == id
select o;
foreach (var row in queries)
{
this.ListMenu.Add(new Menu
{
PageID = row.PageID,
PageName = row.PageName,
PageDescription = row.PageDescription,
PageURL = row.PageURL,
PageIcon = row.PageIcon,
isEnabled = row.isEnabled,
CreatedOn = row.CreatedOn,
CreatedBy = row.CreatedBy
});
}
//transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
finally
{
transaction.Dispose();
}
}
}
return(this.ListMenu);
}
public int Put(OnlineDrive model)
{
int affectedRows = 0;
using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
{
using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
OnlineDrive updateModel = dbo.OnlineDrives.Find(model.Id);
updateModel.Id = model.Id;
updateModel.FileNameGUID = model.FileName;
updateModel.FileName = model.FileName;
updateModel.FilePath = model.FilePath;
updateModel.UploadedOn = model.UploadedOn;
updateModel.UploadedBy = model.UploadedBy;
updateModel.LastUpdatedOn = model.LastUpdatedOn;
updateModel.LastUpdatedBy = model.LastUpdatedBy;
dbo.OnlineDrives.Add(updateModel);
dbo.Entry(updateModel).State = System.Data.Entity.EntityState.Modified;
affectedRows = dbo.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
finally
{
transaction.Dispose();
}
}
}
return(affectedRows);
}
public int Put(Menu model)
{
int affectedRows = 0;
using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
{
using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
Menu updateModel = dbo.Menus.Find(model.PageID);
updateModel.PageID = model.PageID;
updateModel.PageName = model.PageName;
updateModel.PageDescription = model.PageDescription;
updateModel.PageURL = model.PageURL;
updateModel.PageIcon = model.PageIcon;
updateModel.isEnabled = model.isEnabled;
updateModel.CreatedOn = model.CreatedOn;
updateModel.CreatedBy = model.CreatedBy;
dbo.Menus.Add(updateModel);
dbo.Entry(updateModel).State = System.Data.Entity.EntityState.Modified;
affectedRows = dbo.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
finally
{
transaction.Dispose();
}
}
}
return(affectedRows);
}
