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