public ActionResult <object> Save([FromBody] TeacherClassSubjectFileType teacherClassSubjectFileType)
{
try
{
Init();
StringBuilder sbError = new StringBuilder("");
if (!ModelState.IsValid)
{
Response.StatusCode = 400;
return((string)"Failed getting teacherClassSubjectFileType id");
}
else
{
if (string.IsNullOrEmpty(teacherClassSubjectFileType?.TeacherClassSubjectFileTypeId.ToString()))
{
teacherClassSubjectFileType.SchoolId = _user.SchoolID;
}
var isSaved = _TeacherClassSubjectFileTypeService.Save(teacherClassSubjectFileType, ref sbError);
if (isSaved == null)
{
Response.StatusCode = 400;
return((string)"teacherClassSubjectFileType save failed " + sbError.ToString());
}
else
{
return(Ok(new { id = isSaved.TeacherClassSubjectFileTypeId }));
}
}
}
catch (Exception er)
{
return(Error(er));
}
}
public TeacherClassSubjectFileType Save(TeacherClassSubjectFileType teacherClassSubjectFileType, ref StringBuilder sbError)
{
bool dbFlag = false;
if (teacherClassSubjectFileType.TeacherClassSubjectFileTypeId == null || teacherClassSubjectFileType.TeacherClassSubjectFileTypeId == Guid.Empty)
{
teacherClassSubjectFileType.SchoolId = _user.SchoolID;
}
if (string.IsNullOrEmpty(teacherClassSubjectFileType.Description))
{
sbError.Append("Description is required");
return(null);
}
if (string.IsNullOrEmpty(teacherClassSubjectFileType.Code))
{
sbError.Append("Cod is required");
return(null);
}
var list = _uofRepository.TeacherClassSubjectFileTypeRepository.GetListBySchoolId(_user.SchoolID, ref dbFlag);
if (list.Count() > 100)
{
sbError.Append("You have reached maximum teacherClassSubjectFileTypes allowed");
return(null);
}
else
{
if (!string.IsNullOrEmpty(teacherClassSubjectFileType.TeacherClassSubjectFileTypeId.ToString()))
{
var dbTeacherClassSubjectFileType = list.Where(c => c.TeacherClassSubjectFileTypeId == teacherClassSubjectFileType.TeacherClassSubjectFileTypeId).FirstOrDefault();
if (dbTeacherClassSubjectFileType == null)
{
sbError.Append("TeacherClassSubjectFileType does not exist for school");
return(null);
}
else
{
teacherClassSubjectFileType.Code = dbTeacherClassSubjectFileType.Code;
teacherClassSubjectFileType.SchoolId = _user.SchoolID;
}
}
else
{
teacherClassSubjectFileType.SchoolId = _user.SchoolID;
}
}
var isSaved = _uofRepository.TeacherClassSubjectFileTypeRepository.Save(teacherClassSubjectFileType, _user.Username, ref dbFlag);
return(isSaved);
}
public TeacherClassSubjectFileType Save(TeacherClassSubjectFileType teacherClassSubjectFileType, string modifiedby, ref bool dbError)
{
var teacherClassSubjectFileTypeIsExist = GetTeacherClassSubjectFileTypeByCode(teacherClassSubjectFileType.Code, teacherClassSubjectFileType.SchoolId, ref dbError);
if (dbError)
{
return(null);
}
try
{
using (var connection = GetConnection())
{
teacherClassSubjectFileType.Code = CleanIDcodeAlphanumeric(teacherClassSubjectFileType.Code);
if (teacherClassSubjectFileTypeIsExist == null)
{
teacherClassSubjectFileType.TeacherClassSubjectFileTypeId = Guid.NewGuid();
var insert = @"
INSERT INTO TeacherClassSubjectFileType
(TeacherClassSubjectFileTypeID
,Description
,Code
,SchoolID
,CanParentAccessFile
,CanStudentAccessFile
,LastModifiedBy
)
VALUES
(
@id ,
@Description ,
@code ,
@schoolID ,
@CanParentAccessFile ,
@CanStudentAccessFile ,
@modifiedby
)
";
var id = connection.Execute(insert,
new
{
id = teacherClassSubjectFileType.TeacherClassSubjectFileTypeId,
Description = teacherClassSubjectFileType.Description,
code = teacherClassSubjectFileType.Code,
schoolID = teacherClassSubjectFileType.SchoolId,
CanStudentAccessFile = teacherClassSubjectFileType.CanStudentAccessFile,
CanParentAccessFile = teacherClassSubjectFileType.CanParentAccessFile,
modifiedby = modifiedby
});
}
else
{
var update = @"
UPDATE TeacherClassSubjectFileType
SET Description = @Description , lastmodifiedby = @modifiedby
,CanStudentAccessFile = @CanStudentAccessFile
,CanParentAccessFile = @CanParentAccessFile
WHERE TeacherClassSubjectFileTypeID = @id AND ISDELETED IS NULL
";
var id = connection.Execute(update,
new
{
id = teacherClassSubjectFileType.TeacherClassSubjectFileTypeId,
Description = teacherClassSubjectFileType.Description,
CanStudentAccessFile = teacherClassSubjectFileType.CanStudentAccessFile,
CanParentAccessFile = teacherClassSubjectFileType.CanParentAccessFile,
modifiedby = modifiedby
});
}
return(teacherClassSubjectFileType);
}
}
catch (Exception er)
{
dbError = true;
DbLog.Error(er);
return(null);
}
}
