public CodeFrm(TablesNames CodeName) { //cDSyndicateTableAdapter.Connection.ConnectionString = SqlDB.SqlConStr; //cDEDARETTableAdapter.Connection.ConnectionString = SqlDB.SqlConStr; //cDModereaTableAdapter.Connection.ConnectionString = SqlDB.SqlConStr; InitializeComponent(); ViewName = CodeName; switch (CodeName) { case TablesNames.CDSyndicate: gridControlCode.MainView = gridViewCDSyndicate; cDSyndicateTableAdapter.Fill(dSFellowship.CDSyndicate); gridControlCode.DataSource = cDSyndicateBindingSource; Text += " النقابات الفرعية"; break; case TablesNames.CDEDARET: cDModereaTableAdapter.Fill(dSFellowship.CDModerea); cDSyndicateTableAdapter.Fill(dSFellowship.CDSyndicate); gridControlCode.MainView = gridViewCDEDARET; cDEDARETTableAdapter.Fill(dSFellowship.CDEDARET); gridControlCode.DataSource = cDEDARETBindingSource; Text += " الادارات"; break; case TablesNames.CDModerea: gridControlCode.MainView = gridViewCDModerea; cDModereaTableAdapter.Fill(dSFellowship.CDModerea); gridControlCode.DataSource = cDModereaBindingSource; Text += " المديريات"; break; case TablesNames.CDState: gridControlCode.MainView = gridViewCDState; cDStateTableAdapter.Fill(dSFellowship.CDState); gridControlCode.DataSource = cDStateBindingSource; Text += " الانواع"; break; case TablesNames.CDJob: gridControlCode.MainView = gridViewCDJob; cDJobTableAdapter.Fill(dSFellowship.CDJob); gridControlCode.DataSource = cDJobBindingSource; Text += " الوظائف"; break; case TablesNames.CDAttach: gridControlCode.MainView = gridViewCDAttach; cDAttachTableAdapter.Fill(dSFellowship.CDAttach); gridControlCode.DataSource = cDAttachBindingSource; Text += " المرفقات"; break; default: break; } ((GridView)gridControlCode.MainView).BestFitColumns(); }
public Dictionary<string, string> Read(Guid Id, TablesNames tableName) { TableInform table; DbConnection connection; DataRow result; connection = TableInform.Connection; table = new TableInform(tableName.ToString()); DataRow dr = table.Table.AsEnumerable().SingleOrDefault(r => r.Field<Guid>("ID") == Id); var dict = table.ConvertRowToDict(dr); return dict; }
public void Insert(Dictionary<string, string> dictionary, TablesNames tableName) { TableInform table; DbConnection connection; DataRow result; table = new TableInform(tableName.ToString()); connection = TableInform.Connection; result = table.ConvertDictToRow(dictionary); table.Table.Rows.Add(result); table.Update(new DataRow[] { result }); }
public void Delete(Dictionary<string, string> dictionary, TablesNames tableName) { TableInform table; DbConnection connection; DataRow row; string IdValue; IdValue = null; table = new TableInform(tableName.ToString()); table.Table.PrimaryKey = new DataColumn[] { table.Table.Columns["Id"] }; connection = TableInform.Connection; if (dictionary.TryGetValue("Id", out IdValue)) { row = table.Table.Rows.Find(IdValue); row.Delete(); table.Update(new DataRow[] { row }); } }
public int GetIdElement(TablesNames tb, string con) { switch (tb) { case TablesNames.Books: return(context.Lib.First(s => s.Book_title == con).Id); case TablesNames.BuyOrders: return(context.BuyOrders.First(s => s.Id_book == GetIdElement(TablesNames.Books, con)).Id); case TablesNames.Employees: return(context.Employees.First(s => s.FIO == con).Id); case TablesNames.ReadOrders: return(context.ReadingOrders.First(s => s.Id_book == GetIdElement(TablesNames.Books, con)).Id); default: return(-1); } }
public void Update(Dictionary<string, string> dictionary, TablesNames tableName) { TableInform table; DbConnection connection; string IdValue; DataRow row; IdValue = null; table = new TableInform(tableName.ToString()); connection = TableInform.Connection; table.Table.PrimaryKey = new DataColumn[] { table.Table.Columns["Id"] }; if (dictionary.TryGetValue("Id", out IdValue)) { row = table.Table.Rows.Find(IdValue); foreach (KeyValuePair<string, string> pair in dictionary) { row[pair.Key] = pair.Value; } table.Update(new DataRow[] { row }); } }
public List<Dictionary<string, string>> ReadAll(TablesNames tableName, Gender gender) { TableInform table; DbConnection connection; DataRow[] rows; List<Dictionary<string, string>> resultedList; connection = TableInform.Connection; resultedList = new List<Dictionary<string, string>>(); table = new TableInform(tableName.ToString()); if (gender == Gender.NotSpecified) { rows = table.Table.Select(); } else { string param = String.Format("LEAGUE = '{0}'", gender.ToString()); rows = table.Table.Select(param); } foreach (var row in rows) { var result = table.ConvertRowToDict(row); resultedList.Add(result); } return resultedList; }
public List<Dictionary<string, string>> FindSerchResults(string serchableName, TablesNames tableName, Gender gender) { TableInform table; DbConnection connection; List<Dictionary<string, string>> result; result = new List<Dictionary<string, string>>(); connection = TableInform.Connection; table = new TableInform(tableName.ToString()); var rowList = table.Table.AsEnumerable().Where(r => r.Field<string>("Name").Contains(serchableName.ToUpper())).ToList(); if (rowList.Count > 0) { foreach (var row in rowList) { if (row.Field<string>("League") == gender.ToString()) { result.Add(table.ConvertRowToDict(row)); } } return result; } return null; }
private List<Dictionary<string, string>> ReadByIds(TablesNames tableName, List<Guid> idList) { TableInform table; List<Dictionary<string, string>> resultedList; resultedList = new List<Dictionary<string, string>>(); table = new TableInform(tableName.ToString()); if (idList.Count > 0) { foreach (var id in idList) { var row = (from r in table.Table.AsEnumerable() where r.Field<Guid>("Id") == id select r).SingleOrDefault(); var result = table.ConvertRowToDict(row); resultedList.Add(result); } return resultedList; } return null; }
private List<Guid> GetTeamsByGameId(TablesNames tableName, Guid gameId) { TableInform table; List<Guid> result; table = new TableInform(tableName.ToString()); var res = (from r in table.Table.AsEnumerable() where r.Field<Guid>("Id") == gameId select r).SingleOrDefault(); result = new List<Guid>(); result.Add((Guid)res["TeamOneId"]); result.Add((Guid)res["TeamTwoId"]); return result; }
private List<Guid> GetPlayersByGameId(TablesNames tableName, Guid gameId) { TableInform table; table = new TableInform(tableName.ToString()); var res = (from r in table.Table.AsEnumerable() where r.Field<Guid>("GameId") == gameId select r.Field<Guid>("PlayerId")).ToList(); return res; }
private List<Guid> GetGamesByTeamId(TablesNames tableName, Guid teamId) { TableInform table; List<Dictionary<string, string>> resultedList; resultedList = new List<Dictionary<string, string>>(); table = new TableInform(tableName.ToString()); var res = (from r in table.Table.AsEnumerable() where r.Field<Guid>("TeamOneId") == teamId || r.Field<Guid>("TeamTwoId") == teamId select r.Field<Guid>("Id")).ToList(); return res; }
private List<Guid> GetInfoByPlayerId(TablesNames tableName, Guid playerId) { TableInform table; table = new TableInform(tableName.ToString()); string param = (tableName.ToString().Substring(8, 4) + "Id"); var res = (from r in table.Table.AsEnumerable() where r.Field<Guid>("PlayerId") == playerId select r.Field<Guid>(param)).ToList(); return res; }