public void Update(clsRubricStructureBO Rub) { OleDbConnection con = null; try { con = new OleDbConnection(connection_string); con.Open(); OleDbCommand cmd = new OleDbCommand("update RubriqueStructureGrossToNet " + " set IdSoc=@IdSoc,Label=@Label,NomColonne=@NomColonne,ColonneType=@ColonneType,StartString=@StartString,EndString=@EndString,ConvertOut=@ConvertOut,ReplaceString=@ReplaceString)" + " where Id=@Id" , con); cmd.Parameters.Add(new OleDbParameter("@Id", Rub.Id)); cmd.Parameters.Add(new OleDbParameter("@IdSoc", Rub.IdSoc)); cmd.Parameters.Add(new OleDbParameter("@Label", Rub.Label)); cmd.Parameters.Add(new OleDbParameter("@NomColonne", Rub.Label)); cmd.Parameters.Add(new OleDbParameter("@StartString", Rub.StartString)); cmd.Parameters.Add(new OleDbParameter("@EndString", Rub.EndString)); cmd.Parameters.Add(new OleDbParameter("@ColonneType", Rub.ColonneType)); cmd.Parameters.Add(new OleDbParameter("@ConvertOut", Rub.ConvertOut)); cmd.Parameters.Add(new OleDbParameter("@ReplaceString", Rub.ReplaceString)); cmd.Parameters.Add(new OleDbParameter("@Order", Rub.ReplaceString)); cmd.ExecuteNonQuery(); } catch { } finally { con.Close(); con.Dispose(); } }
public void Add(clsRubricStructureBO Rub) { OleDbConnection con = null; try { con = new OleDbConnection(connection_string); con.Open(); OleDbCommand cmd = new OleDbCommand("insert into RubriqueStructureGrossToNet (Id,IdSoc,Label,NomColonne,ColonneType,StartString,EndString,ConvertOut,ReplaceString,Order)" + "values (@Id,@IdSoc,@Label,@NomColonne,@ColonneType,@StartString,@EndString,@ConvertOut,@ReplaceString,@Order)" , con); cmd.Parameters.Add(new OleDbParameter("@Id", Rub.Id)); cmd.Parameters.Add(new OleDbParameter("@IdSoc", Rub.IdSoc)); cmd.Parameters.Add(new OleDbParameter("@Label", Rub.Label)); cmd.Parameters.Add(new OleDbParameter("@NomColonne", Rub.Label)); cmd.Parameters.Add(new OleDbParameter("@StartString", Rub.StartString)); cmd.Parameters.Add(new OleDbParameter("@EndString", Rub.EndString)); cmd.Parameters.Add(new OleDbParameter("@ColonneType", Rub.ColonneType)); cmd.Parameters.Add(new OleDbParameter("@ConvertOut", Rub.ConvertOut)); cmd.Parameters.Add(new OleDbParameter("@ReplaceString", Rub.ReplaceString)); cmd.Parameters.Add(new OleDbParameter("@Order", Rub.ReplaceString)); cmd.ExecuteNonQuery(); } catch { } finally { con.Close(); con.Dispose(); } }
public List<clsRubricStructureBO> GetListRubricsByIdSoc(int IdSoc) { OleDbConnection con = null; clsRubricStructureBO rub; List<clsRubricStructureBO> List = new List<clsRubricStructureBO>(); try { con = new OleDbConnection(connection_string); con.Open(); OleDbCommand cmd = new OleDbCommand("select Id,IdSoc,Label,NomColonne,ColonneType,StartString,EndString,ConvertOut,ReplaceString,Order from RubriqueStructureGrossToNet " + " where IdSoc = " + IdSoc + " Order by Oder " , con); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { rub = new clsRubricStructureBO(); rub.Id = int.Parse(dr["Id"].ToString()); rub.IdSoc = int.Parse(dr["IdSoc"].ToString()); rub.Label = dr["Label"].ToString(); rub.NomColonne = dr["NomColonne"].ToString(); rub.ReplaceString = dr["ReplaceString"].ToString(); rub.StartString = int.Parse(dr["StartString"].ToString()); rub.EndString = int.Parse(dr["EndString"].ToString()); rub.ColonneType = dr["ColonneType"].ToString(); rub.Order = int.Parse(dr["Order"].ToString()); List.Add(rub); } } catch { } finally { con.Close(); con.Dispose(); } return List; }
public clsRubricStructureBO GetDetails(int Id) { OleDbConnection con = null; clsRubricStructureBO rub = new clsRubricStructureBO(); try { con = new OleDbConnection(connection_string); con.Open(); OleDbCommand cmd = new OleDbCommand("select Id,IdSoc,Label,NomColonne,ColonneType,StartString,EndString,ConvertOut,ReplaceString,Order from RubriqueStructureGrossToNet " , con); OleDbDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { rub.Id = int.Parse(dr["Id"].ToString()); rub.IdSoc = int.Parse(dr["IdSoc"].ToString()); rub.Label = dr["Label"].ToString(); rub.NomColonne = dr["NomColonne"].ToString(); rub.ReplaceString = dr["ReplaceString"].ToString(); rub.StartString = int.Parse(dr["StartString"].ToString()); rub.EndString = int.Parse(dr["EndString"].ToString()); rub.ColonneType = dr["ColonneType"].ToString(); rub.Order = int.Parse(dr["Order"].ToString()); } } catch { } finally { con.Close(); con.Dispose(); } return rub; }
public void Delete(clsRubricStructureBO Rub) { OleDbConnection con = null; try { con = new OleDbConnection(connection_string); con.Open(); OleDbCommand cmd = new OleDbCommand("delete from RubriqueStructureGrossToNet " + " where Id=@Id" , con); cmd.Parameters.Add(new OleDbParameter("@Id", Rub.Id)); cmd.ExecuteNonQuery(); } catch { } finally { con.Close(); con.Dispose(); } }