public string QueryDeleteAll(BaseModele bm) { string query = $"delete {bm.GetType().Name}"; Console.WriteLine(query); return(query); }
public string QueryDelete(BaseModele bm) { string query = $"delete {bm.GetType().Name} where id = '{bm.Id}'"; Console.WriteLine(query); return(query); }
public BaseModele FindById(BaseModele modele, string id) { List <BaseModele> bms = FindQuery($"select top 1 * from {modele.GetType().Name} where id='{id}'", modele); if (bms.Count != 0) { return(bms[0]); } throw new Exception("aucune resultat"); }
public string GetRefTable(BaseModele bm) { string nomtable = bm.GetType().Name; if (nomtable.Length <= 4) { return(nomtable.ToUpper()); } return(nomtable.Substring(0, 4).ToUpper()); }
public string QueryUpdate(BaseModele bm) { FieldInfo[] fieldInfos = GetFieldInfos(bm); string valueColonne = ""; foreach (var field in fieldInfos) { valueColonne += $"{field.Name} = @{field.Name}, "; } valueColonne = valueColonne.Remove(valueColonne.Length - 2); string query = $"update {bm.GetType().Name} set {valueColonne} where id = '{bm.Id}'"; Console.WriteLine(query); return(query); }
public string QueryList(BaseModele bm, string where) { if (string.IsNullOrEmpty(where)) { where = ""; } else { where = $"where {where}"; } string query = $"select * from {bm.GetType().Name} {where}"; Console.WriteLine(query); return(query); }
public string QuerySave(BaseModele baseModele) { FieldInfo[] fields = GetFieldInfos(baseModele); string nomColone = ""; string valueColone = ""; foreach (var field in fields) { nomColone += $"{field.Name}, "; valueColone += $"@{field.Name}, "; } nomColone = nomColone.Remove(nomColone.Length - 2); valueColone = valueColone.Remove(valueColone.Length - 2); string query = $"insert into {baseModele.GetType().Name} (id, {nomColone}) values(@id, {valueColone})"; Console.WriteLine(query); return(query); }
public List <BaseModele> FindQuery(string requette, BaseModele bm, SqlConnection conn) { Connexion c = new Connexion(); SqlDataReader sqd = null; List <BaseModele> lmModeles = new List <BaseModele>(); Console.WriteLine(requette); try { FieldInfo[] fields = GetFieldInfos(bm); sqd = c.ResultSet(requette, conn); while (sqd.Read()) { BaseModele modele = (BaseModele)Activator.CreateInstance(bm.GetType()); modele.Id = sqd["id"].ToString(); foreach (var field in fields) { if (sqd[field.Name].GetType() != typeof(DBNull)) { field.SetValue(modele, sqd[field.Name]); } } lmModeles.Add(modele); } } catch (Exception e) { Console.WriteLine(e); throw; } finally { c.Close(sqd, null); } return(lmModeles); }
public string GetSeq(BaseModele bm) { return($"id{bm.GetType().Name}".ToLower()); }
public FieldInfo[] GetFieldInfos(BaseModele bm) { return(bm.GetType().GetFields(BindingFlags.NonPublic | BindingFlags.Instance)); }