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