public ProfessionalLevel GetProfessionalLevelById(int professionalLevelId)
{
try
{
ProfessionalLevel professionalLevel = null;
parameters.Clear();
parameters.Add("@ProfessionalLevelId", professionalLevelId.ToString());
var read = _repositoryConnection.SearchCommand("GetProfessionalLevelById", parameters);
DataTable dataTable = JsonConvert.DeserializeObject <DataTable>(read);
foreach (DataRow row in dataTable.Rows)
{
professionalLevel = new ProfessionalLevel();
professionalLevel.ProfessionalLevelId = Convert.ToInt32(row["ProfessionalLevelId"]);
professionalLevel.ProfessionalLevelName = row["ProfessionalLevelName"].ToString();
professionalLevel.ProfessionalLevelSection = Convert.ToInt32(row["ProfessionalLevelSection"]);
professionalLevel.DateRegister = Convert.ToDateTime(row["DateRegister"]);
professionalLevel.ProfessionalLevelStatus = Convert.ToBoolean(row["ProfessionalLevelStatus"]);
}
return(professionalLevel);
}
catch (Exception ex)
{
throw ex;
}
}
public List <ProfessionalLevel> GetAllProfessionalLevels()
{
try
{
List <ProfessionalLevel> listProfessionalLevels = new List <ProfessionalLevel>();
ProfessionalLevel professionalLevel = null;
var read = _repositoryConnection.SearchCommand("GetAllProfessionalLevels", parameters);
DataTable dataTable = JsonConvert.DeserializeObject <DataTable>(read);
foreach (DataRow row in dataTable.Rows)
{
professionalLevel = new ProfessionalLevel();
professionalLevel.ProfessionalLevelId = Convert.ToInt32(row["ProfessionalLevelId"]);
professionalLevel.ProfessionalLevelName = row["ProfessionalLevelName"].ToString();
professionalLevel.ProfessionalLevelSection = Convert.ToInt32(row["ProfessionalLevelSection"]);
professionalLevel.DateRegister = Convert.ToDateTime(row["DateRegister"]);
professionalLevel.ProfessionalLevelStatus = Convert.ToBoolean(row["ProfessionalLevelStatus"]);
listProfessionalLevels.Add(professionalLevel);
}
return(listProfessionalLevels);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteProfessionalLevel(ProfessionalLevel professionalLevel)
{
try
{
parameters.Add("@ProfessionalLevelId", professionalLevel.ProfessionalLevelId.ToString());
_repositoryConnection.SimpleExecuteCommand("DeleteProfessionalLevel", parameters);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateProfessionalLevel(ProfessionalLevel professionalLevel)
{
try
{
parameters.Add("@ProfessionalLevelName", professionalLevel.ProfessionalLevelName);
parameters.Add("@ProfessionalLevelSection", professionalLevel.ProfessionalLevelSection.ToString());
parameters.Add("@DateRegister", professionalLevel.DateRegister.ToString());
parameters.Add("@ProfessionalLevelStatus", professionalLevel.ProfessionalLevelStatus.ToString());
parameters.Add("@ProfessionalLevelId", professionalLevel.ProfessionalLevelId.ToString());
_repositoryConnection.SimpleExecuteCommand("UpdateProfessionalLevel", parameters);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertProfessionalLevel(ProfessionalLevel professionalLevel)
{
try
{
parameters.Add("@ProfessionalLevelName", professionalLevel.ProfessionalLevelName);
parameters.Add("@ProfessionalLevelSection", professionalLevel.ProfessionalLevelSection.ToString());
parameters.Add("@DateRegister", professionalLevel.DateRegister.ToString());
parameters.Add("@ProfessionalLevelStatus", professionalLevel.ProfessionalLevelStatus.ToString());
int professionalLevelId = _repositoryConnection.InsertCommand("InsertProfessionalLevel", parameters);
return(professionalLevelId);
}
catch (Exception ex)
{
throw ex;
}
}
