public async Task <int> UpdateAsync(ClassSpecialized clas)
{
int rowAffected = 0;
using (SqlConnection con = new SqlConnection(_connectionString))
{
if (con.State == ConnectionState.Closed)
{
await con.OpenAsync();
}
DynamicParameters param = new DynamicParameters();
param.Add("@Id", clas.id);
param.Add("@IdClass", clas.IdClass);
param.Add("@ClassName", clas.ClassName);
param.Add("@IdSpecialized", clas.IdSpecialized);
param.Add("@IdEducationProgram", clas.IdEducationProgram);
param.Add("@Course", clas.Course);
if (clas.Createdate != null && clas.Createdate != DateTime.MinValue)
{
param.Add("@Createdate", clas.Createdate);
}
if (clas.LastUpdate != null && clas.LastUpdate != DateTime.MinValue)
{
param.Add("@LastUpdate", clas.LastUpdate);
}
rowAffected = await con.ExecuteAsync("[dbo].[spClas_Update]", param, commandType : CommandType.StoredProcedure);
}
return(rowAffected);
}
public async Task <ActionResultReponese <string> > InsertAsync(string className, string idClass, ClassMeta clasMeta)
{
var idGui = Guid.NewGuid().ToString();
var isNameExit = await _classRepository.CheckExistsAsync(idClass);
if (isNameExit)
{
return(new ActionResultReponese <string>(-2, "da ton tai", "ClassSpecialized"));
}
var isSpecialized = await _ispecializedRepository.CheckExistByIdSpecialized(clasMeta.IdSpecialized);
if (!isSpecialized)
{
return(new ActionResultReponese <string>(-3, "IdSpecialized khong ton tai", "Specialized"));
}
var isEducation = await _iEducationProgramRepository.CheckExistsAsync(clasMeta.IdEducationProgram);
if (!isEducation)
{
return(new ActionResultReponese <string>(-5, "EducationProgram khong ton tai", "EducationProgram"));
}
var clas = new ClassSpecialized
{
id = idGui,
IdClass = idClass.Trim(),
ClassName = className.Trim(),
IdSpecialized = clasMeta.IdSpecialized?.Trim(),
IdEducationProgram = clasMeta.IdEducationProgram?.Trim(),
Course = clasMeta.Course?.Trim(),
Createdate = DateTime.Now,
LastUpdate = null,
IsActive = true,
IsDelete = false
};
var result = await _classRepository.InsertAsync(clas);
if (result >= 0)
{
return(new ActionResultReponese <string>(result, "thanh cong", "ClassSpecializd", null));
}
return(new ActionResultReponese <string>(result, "that bai", "ClassSpecializd", null));
}
