public void Delete(int id)
{
var parameters = new DynamicParameters();
parameters.Add("@id", id);
SqlDB.Execute("Management.DeleteProject", parameters, commandType: StoredProcedure);
}
public void Add(Instructor entity)
{
var parameters = new DynamicParameters();
parameters.Add("@FullName", entity.FullName);
SqlDB.Execute("Management.AddInstructor", parameters, commandType: StoredProcedure);
}
public void ChangeProjectStatus(int id, bool status)
{
var parameters = new DynamicParameters();
parameters.Add("@id", id);
parameters.Add("@isActive", status);
SqlDB.Execute("Management.ChangeProjectStatus", parameters, commandType: StoredProcedure);
}
public void Add(Project entity)
{
var parameters = new DynamicParameters();
parameters.Add("@ProjectName", entity.ProjectName);
parameters.Add("@ProjectDescription", entity.ProjectDescription);
SqlDB.Execute("Management.AddProject", parameters, commandType: StoredProcedure);
}
public void Update(Instructor entity)
{
var parameters = new DynamicParameters();
parameters.Add("@id", entity.Id);
parameters.Add("@FullName", entity.FullName);
parameters.Add("@isActive", entity.IsActive);
SqlDB.Execute("Management.UpdateInstructor", parameters, commandType: StoredProcedure);
}