public static MemoryStream DownloadLessonResource(int resourseID)
{
try
{
using (var conn = new dbEntities())
{
LessonResource resource = new LessonResource();
resource = conn.LessonResources.FirstOrDefault(r => r.ID == resourseID);
if (resource == null)
{
throw new Exception("Lesson resource not found.");
}
using (var memoryStream = new MemoryStream())
{
logic.Helpers.AzureStorage.StoredResources.DownloadLessonResource(memoryStream, resource.Item_Storage_Name);
return(memoryStream);
}
}
}
catch (Exception ex)
{
var ignore = ex;
}
return(null);
}
public static string UploadResource(int lessonId, HttpPostedFileBase resource)
{
try
{
using (var conn = new dbEntities())
{
var lesson = conn.Lessons.FirstOrDefault(l => l.ID == lessonId);
if (lesson == null)
{
throw new Exception("Lesson does not exist.");
}
var lessonResource = new LessonResource()
{
Lession_ID = lessonId,
Original_Name = resource.FileName,
Item_Storage_Name = logic.Helpers.AzureStorage.StoredResources.UploadLessonResource(resource),
Type_ID = Constants.Types.Default
};
conn.LessonResources.Add(lessonResource);
conn.SaveChanges();
}
return(resource.FileName);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string DownloadLessonImage(int resourseID)
{
try
{
using (var conn = new dbEntities())
{
LessonResource resource = new LessonResource();
resource = conn.LessonResources.FirstOrDefault(r => r.ID == resourseID);
if (resource == null)
{
throw new Exception("Lesson resource not found.");
}
using (var memoryStream = new MemoryStream())
{
logic.Helpers.AzureStorage.StoredResources.DownloadLessonResource(memoryStream, resource.Item_Storage_Name);
var imageByte = memoryStream.ToArray();
return(System.Text.Encoding.UTF8.GetString(imageByte, 0, imageByte.Length));
}
}
}
catch (Exception ex)
{
var ignore = ex;
}
return(null);
}
public static string UploadResourceImage(FormDataCollection resourceImage)
{
try
{
var lessonId = Convert.ToInt32(resourceImage["lessonId"]);
using (var conn = new dbEntities())
{
var lesson = conn.Lessons.FirstOrDefault(l => l.ID == lessonId);
if (lesson == null)
{
throw new Exception("Lesson does not exist.");
}
int lessonResourceId = 0;
if (lesson.LessonResources.Count > 0)
{
var lessonResource = lesson.LessonResources.OrderByDescending(r => r.ID).FirstOrDefault();
lessonResource.Lession_ID = lessonId;
lessonResourceId = lessonResource.ID;
lessonResource.Original_Name = resourceImage["title"];
lessonResource.Item_Storage_Name = logic.Helpers.AzureStorage.StoredResources.UploadLessonResourceImage(resourceImage["data"]);
lessonResource.Type_ID = Constants.Types.Image;
}
if (lessonResourceId == 0)
{
var lessonResource = new LessonResource()
{
Lession_ID = lessonId,
Original_Name = resourceImage["title"],
Item_Storage_Name = logic.Helpers.AzureStorage.StoredResources.UploadLessonResourceImage(resourceImage["data"]),
Type_ID = Constants.Types.Image
};
conn.LessonResources.Add(lessonResource);
}
conn.SaveChanges();
}
return(resourceImage["title"]);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string DeleteResource(int resourceID)
{
using (var conn = new dbEntities())
{
LessonResource resource = new LessonResource();
resource = conn.LessonResources.FirstOrDefault(a => a.ID == resourceID);
if (resource == null)
{
throw new Exception("The resource does not exist.");
}
bat.logic.Helpers.AzureStorage.AzureBlobStorage.Delete(bat.logic.Constants.Azure.AZURE_UPLOADED_LESSON_RESOURCES_STORAGE_CONTAINER, resource.Item_Storage_Name);
conn.LessonResources.Remove(conn.LessonResources.FirstOrDefault(i => i.ID == resourceID));
conn.SaveChanges();
}
return(null);
}
