public static bool InsertData(TeamInfo nwteam, string tblName)//insert in team table { //tblName = "TeamdataTable"; string query = "INSERT INTO " + tblName + "(TeamName,TeamSemester,TeamDepart) VALUES('" + nwteam.TeamName.ToUpper() + "','" + nwteam.Teasemester + "','" + nwteam.Depart.ToUpper() + "');"; try { DataAcesslogic.ReadDataFromDb(_dataSet, query, tblName); return(true); } catch (Exception ex) { throw ex; } }
//table taniss public static bool validtabletanessteam(TeamInfo nwteam) { bool vtm = TeamInfo.validtaemData(nwteam); if (vtm) { if (!validationtabletanessDb(nwteam))//this validation is changed only for in all games { return(true); } return(false); } return(false); }
public static bool validationtabletanessDb(TeamInfo nwteam)//team validition from regstrd teams { string query = "Select * From TAbletennisteamTable Where Teamname='" + nwteam.TeamName.ToUpper() + "'"; try { DataAcesslogic.ReadDataFromDb(_dataSet, query, "TAbletennisteamTable"); //football if (_dataSet.Tables["TAbletennisteamTable"].Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public static bool validtaemData(TeamInfo val) //Function For Check Alphabets { for (int i = 0; i <= 9; i++) { if (val._depart.Contains(i.ToString()) || val._teamName.Contains(i.ToString())) { return(false); } } if (val._teamName.Contains("+")) { return(false); } if (val._teamName.Contains("!")) { return(false); } if (val._teamName.Contains("@")) { return(false); } if (val._teamName.Contains("#")) { return(false); } if (val._teamName.Contains("$")) { return(false); } if (val._teamName.Contains("%")) { return(false); } if (val._teamName.Contains("^")) { return(false); } if (val._teamName.Contains("&")) { return(false); } if (val._teamName.Contains("*")) { return(false); } if (val._teamName.Contains("(")) { return(false); } if (val._teamName.Contains(")")) { return(false); } if (val._teamName.Contains("-")) { return(false); } if (val._teamName.Contains("_")) { return(false); } if (val._teamName.Contains("=")) { return(false); } if (val._teamName.Contains("`")) { return(false); } if (val._teamName.Contains("~")) { return(false); } if (val._teamName.Contains("|")) { return(false); } if (val._teamName.Contains("}")) { return(false); } if (val._teamName.Contains("\"")) { return(false); } if (val._teamName.Contains("/")) { return(false); } if (val._teamName.Contains("?")) { return(false); } if (val._teamName.Contains("]")) { return(false); } if (val._teamName.Contains("[")) { return(false); } if (val._teamName.Contains("'")) { return(false); } if (val._teamName.Contains(";")) { return(false); } if (val._teamName.Contains(":")) { return(false); } if (val._teamName.Contains(".")) { return(false); } if (val._teamName.Contains(",")) { return(false); } if (val._teasemester == "None") { return(false); } if (val._depart == "None") { return(false); } return(true); }
/* //teamname validition /// * public static List<TeamInfo> GetyteamNames() * { * try * { * string query = "Select * From TeamdataTable"; * string tblName = "TeamdataTable"; * List<TeamInfo> teamList = new List<TeamInfo>(); * * * if (_dataSet.Tables.Contains(tblName)) * { * * * * * } * else * { * DataAcesslogic.ReadDataFromDb(_dataSet, query, tblName); * } * * * for (int i = 0; i < _dataSet.Tables[tblName].Rows.Count; i++) * { * DataRow row = _dataSet.Tables[tblName].Rows[i]; * * TeamInfo team = new TeamInfo(); * team.Teamid = Convert.ToInt32(row["ID"].ToString()); * team.Depart =row["TeamDepart"].ToString(); * team.Teasemester = row["TeamSemeser"].ToString(); * team.TeamName = row["Teamname"].ToString(); * * teamList.Add(team); * * } // end of loop * * return teamList; * } * catch (Exception ex) * { throw ex; } * * } // end of GetDeptNames * * * * * * * public static bool validcrickteamname(TeamInfo nwteam) * { * string query = "Select * From TeamdataTable Where Teamname='" + nwteam.TeamName.ToUpper() + "' and TeamSemester='" + nwteam.Teasemester.ToUpper() + "' and teamdepart='" + nwteam.Depart.ToUpper() + "' "; * * try * { * DataAcesslogic.ReadDataFromDb(_dataSet, query, "TeamdataTable"); * * * if (_dataSet.Tables["TeamdataTable"].Rows.Count > 0) * { * return true; * } * else * { * return false; * } * * * * } * catch (Exception ex) * { throw ex; } * } * public static bool validpalyer(PlayerInfo newpalyer) * { * bool validplayr = PlayerInfo.validplayer(newpalyer); * if (validplayr) * { * if (validunistudent(newpalyer)) * { * if (!validplyrfrmtmdatA(newpalyer)) * { * * return true; * } * * } * } * return false; * * * } * //uni record validtion.... * public static bool validplyrfrmtmdatA(PlayerInfo unistu) * { * * string query = "Select * From PlayerdataTable Where StudentName='" + unistu.PlayrName + "' and StudentRegNO='" + unistu.PlayerRegno + "' ";//"' and Teamid ='" + unistu.Playerteamid + "' and Depart ='" + unistu.Playerdepart + * * try * { * DataAcesslogic.ReadDataFromDb(_dataSet, query, "PlayerdataTable"); * * * if (_dataSet.Tables["PlayerdataTable"].Rows.Count > 0) * { * return true; * } * else * { * return false; * } * * * } * catch (Exception ex) * { throw ex; } * * * } * //Validition form other teeamsdata * * public static bool validunistudent(PlayerInfo unistu) * { * * string query = "Select * From UniData Where StudentName='" + unistu.PlayrName + "' and StudentRegNO='" + unistu.PlayerRegno + "' "; * * try * { * DataAcesslogic.ReadDataFromDb(_dataSet, query, "UniData"); * * * if (_dataSet.Tables["UniData"].Rows.Count > 0) * { * return true; * } * else * { * return false; * } * * * } * catch (Exception ex) * { throw ex; } * * * } * * * /* * //check nt the player of any other team * public static bool validteampalyer(PlayerInfo valid) * { * * string query = "Select * From PlayerdataTable Where Name='" + valid.PlayrName + "'RegNo='" + valid.PlayerRegno + "' "; * * try * { * DataTable _dTable = null; * * _dTable = DataAcesslogic.ReadDataFromDb(query); * * if (_dTable.Rows.Count > 0) * { * * return true; * } * else * { * return false; * } * * * } * catch (Exception ex) * { throw ex; } * * * } * * * * * * * //Function Of Insert * public static void InsertData(TeamInfo newteam) * { * * string query = "INSERT INTO TeamdataTable VALUES('" + newteam.TeamName + "','" + newteam.Teasemester + "','" + newteam.Depart + "','" + "');"; * * try * { * DataTable _dTable = null; * * _dTable = DataAcesslogic.ReadDataFromDb(query); * * * * * } * catch (Exception ex) * { throw ex; } * * } //End Of Insert Function * * */ public static bool team(TeamInfo nwteam) { return(true); }