public ActionResult <object> Save([FromBody] TeacherClassSubjectFile teacherClassSubjectFile)
{
try
{
Init();
StringBuilder sbError = new StringBuilder("");
if (!ModelState.IsValid)
{
Response.StatusCode = 400;
return((string)"Failed getting teacherClassSubjectFile id");
}
else
{
var requestFile = Request.Form.Files?.FirstOrDefault();
var isSaved = _teacherClassSubjectFileService.Save(teacherClassSubjectFile, ref sbError);
if (isSaved == null)
{
Response.StatusCode = 400;
return((string)"teacherClassSubjectFile save failed " + sbError.ToString());
}
else
{
return(Ok(new { id = isSaved.TeacherClassSubjectFileId }));
}
}
}
catch (Exception er)
{
return(Error(er));
}
}
public TeacherClassSubjectFile Insert(TeacherClassSubjectFile teacherClassSubjectFile, string modifiedby, ref bool dbError)
{
try
{
using (var connection = GetConnection())
{
teacherClassSubjectFile.TeacherClassSubjectFileId = Guid.NewGuid();
var insert = @"
INSERT INTO TeacherClassSubjectFile
(TeacherClassSubjectFileId
,TeacherClassSubjectID
,TeacherClassSubjectFileTypeID
,Title
,Description
,FileSizeInBytes
,Filename
,FullUrl
,LastModifiedBy
)
VALUES
(@TeacherClassSubjectFileId ,
@TeacherClassSubjectID ,
@TeacherClassSubjectFileTypeID ,
@Title ,
@Description ,
@FileSizeInBytes ,
@Filename ,
@FullUrl ,
@modifiedby
)
";
var id = connection.Execute(insert,
new
{
TeacherClassSubjectFileId = teacherClassSubjectFile.TeacherClassSubjectFileId,
TeacherClassSubjectID = teacherClassSubjectFile.TeacherClassSubjectId,
TeacherClassSubjectFileTypeID = teacherClassSubjectFile.TeacherClassSubjectFileTypeId,
Title = teacherClassSubjectFile.Title,
Description = teacherClassSubjectFile.Description,
FileSizeInBytes = teacherClassSubjectFile.FileSizeInBytes,
Filename = teacherClassSubjectFile.Filename,
FullUrl = teacherClassSubjectFile.FullUrl,
modifiedby = modifiedby
});
return(teacherClassSubjectFile);
}
}
catch (Exception er)
{
dbError = true;
DbLog.Error(er);
return(null);
}
}
public TeacherClassSubjectFile Save(TeacherClassSubjectFile teacherClassSubjectFile, ref StringBuilder sbError)
{
bool dbFlag = false;
if (teacherClassSubjectFile == null)
{
sbError.Append(" please fill in all fields");
return(null);
}
var isSaved = _uofRepository.TeacherClassSubjectFileRepository.Insert(teacherClassSubjectFile, _user.Username, ref dbFlag);
return(isSaved);
}
public TeacherClassSubjectFile PreSaveValidate(Guid TeacherClassSubjectID,
Guid TeacherClassSubjectFileTypeID,
string Description,
string Title,
ref string schoolCode,
ref StringBuilder sbError)
{
bool dbFlag = false;
if (Guid.Empty == TeacherClassSubjectFileTypeID || TeacherClassSubjectFileTypeID == null)
{
sbError.Append("File type is required");
}
else
{
var fileType = _uofRepository.TeacherClassSubjectFileTypeRepository.GetTeacherClassSubjectFileType(TeacherClassSubjectFileTypeID, ref dbFlag);
if (fileType == null)
{
sbError.Append("File type does not exist for school");
}
}
if (Guid.Empty == TeacherClassSubjectID || TeacherClassSubjectID == null)
{
sbError.Append("Failed to get subject class ");
}
else
{
var tcs = _uofRepository.TeacherClassSubjectRepository.GetTeacherClassSubjectByID(TeacherClassSubjectID, ref dbFlag);
if (tcs == null)
{
sbError.Append("Teacher class subject does not exist");
}
}
if (string.IsNullOrEmpty(Description) || Description?.Length >= 200)
{
sbError.Append("Description should be less than 200 characters");
}
if (string.IsNullOrEmpty(Title) || Title?.Length >= 100)
{
sbError.Append("Title should be less than 200 characters");
}
var school = _uofRepository.SchoolRepository.GetSchoolBySchoolID(_user.SchoolID, ref dbFlag);
if (school == null)
{
sbError.Append("Faild getting school");
}
schoolCode = school.SchoolCode;
var teacherClassSubjct = new TeacherClassSubjectFile();
teacherClassSubjct.Description = Description;
teacherClassSubjct.Title = Title;
teacherClassSubjct.TeacherClassSubjectId = TeacherClassSubjectID;
teacherClassSubjct.TeacherClassSubjectFileTypeId = TeacherClassSubjectFileTypeID;
return(teacherClassSubjct);
}
