//public List<CsAdmRoles> GetAll()
//{
// //cmd.CommandText = "spx_AdmRoles_GetAll";
// List<CsAdmRoles> rows = new List<CsAdmRoles>();
// try
// {
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
private List <CsAdmRoles> Fill(SqlDataReader reader, List <CsAdmRoles> rows, int start, int pageLength)
{
try
{
for (int i = 0; i < start; i++)
{
if (!reader.Read())
{
return(rows);
}
}
for (int i = 0; i < pageLength; i++)
{
if (!reader.Read())
{
break;
}
CsAdmRoles c = new CsAdmRoles();
c.RoleID = (Convert.IsDBNull(reader["RoleID"])) ? Guid.Empty : (System.Guid)reader["RoleID"];
c.CodeFonc = (Convert.IsDBNull(reader["CodeFonc"])) ? string.Empty : (System.String)reader["CodeFonc"];
if (!string.IsNullOrEmpty(c.CodeFonc))
{
c.CodeFonc = c.CodeFonc.Substring(3, 3);
}
c.Centre = (Convert.IsDBNull(reader["Centre"])) ? string.Empty : (System.String)reader["Centre"];
c.RoleName = (Convert.IsDBNull(reader["RoleName"])) ? string.Empty : (System.String)reader["RoleName"];
c.RoleDisplayName = (Convert.IsDBNull(reader["RoleDisplayName"])) ? string.Empty : (System.String)reader["RoleDisplayName"];
rows.Add(c);
}
return(rows);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Insert(CsAdmRoles admRoles)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spx_AdmRoles_Insert";
cmd.Parameters.Clear();
cmd.Parameters.Add("@Centre", SqlDbType.VarChar).Value = admRoles.Centre;
cmd.Parameters.Add("@RoleID", SqlDbType.VarChar).Value = admRoles.RoleID;
cmd.Parameters.Add("@CodeFonc", SqlDbType.VarChar).Value = admRoles.CodeFonc;
cmd.Parameters.Add("@RoleName", SqlDbType.VarChar).Value = admRoles.RoleName;
cmd.Parameters.Add("@RoleDisplayName", SqlDbType.VarChar).Value = admRoles.RoleDisplayName;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public void Delete(CsAdmRoles admRoles)
{
Delete(admRoles.RoleID, admRoles.CodeFonc);
}
