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