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