public static List<myChatLine> GetAllChatLine() { myChatLineData tempADO = new myChatLineData(); List<myChatLine> list=new List<myChatLine>(); DataSet tempDS = tempADO.GetAllChatLine(); if (tempADO.HasData) { foreach (DataRow row in tempDS.Tables[0].Rows) list.Add(new myChatLine(row)); return list; } return new List<myChatLine>(); }
public bool UpdateData() { myChatLineData data=new myChatLineData(); List<SqlParameter> tempAL = new List<SqlParameter>(); SqlParameter tempP; tempP = new SqlParameter(); tempP.ParameterName = "@ChatLineID"; tempP.Size = 4; tempP.SqlDbType = SqlDbType.Int; tempP.Value = myChatLineID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@UserID"; tempP.Size = 4; tempP.SqlDbType = SqlDbType.Int; tempP.Value = myUserID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@GameRoomID"; tempP.Size = 4; tempP.SqlDbType = SqlDbType.Int; tempP.Value = myGameRoomID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@ChatLineContent"; tempP.Size = 1200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myChatLineContent; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@TimePosted"; tempP.Size = 12; tempP.SqlDbType = SqlDbType.DateTime; tempP.Value = myTimePosted; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); data.RunProcedure("csp_UpdateChatLine", tempAL); return true; }
public bool InsertData() { myChatLineData data=new myChatLineData(); List<SqlParameter> tempAL = new List<SqlParameter>(); SqlParameter tempP;DataSet tempDS; tempP = new SqlParameter(); tempP.ParameterName = "@UserID"; tempP.Size = 4; tempP.SqlDbType = SqlDbType.Int; tempP.Value = myUserID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@GameRoomID"; tempP.Size = 4; tempP.SqlDbType = SqlDbType.Int; tempP.Value = myGameRoomID; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@ChatLineContent"; tempP.Size = 1200; tempP.SqlDbType = SqlDbType.VarChar; tempP.Value = myChatLineContent; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempP = new SqlParameter(); tempP.ParameterName = "@TimePosted"; tempP.Size = 12; tempP.SqlDbType = SqlDbType.DateTime; tempP.Value = myTimePosted; tempP.Direction = ParameterDirection.Input; tempAL.Add(tempP); tempDS = data.RunProcedure("csp_InsertChatLine", tempAL); myChatLineID= int.Parse(tempDS.Tables[0].Rows[0][0].ToString()); tempDS.Dispose(); return true; }
public bool GetChatLineByChatLineID(int val) { myChatLineData tempADO = new myChatLineData(); DataSet tempDS = tempADO.GetChatLineByChatLineID(val); if (tempADO.HasData){ UpdateChatLine(tempDS.Tables[0].Rows[0]); return true;}return false; }
public static List<myChatLine> GetChatLinesByGameRoomID__Paging(int aGameRoomID,int aPageNumber,int aCount ) { myChatLineData tempADO = new myChatLineData(); List<myChatLine> list=new List<myChatLine>(); DataSet tempDS = tempADO.GetChatLinesByGameRoomID__Paging( aGameRoomID,aPageNumber,aCount); if (tempADO.HasData) { foreach (DataRow row in tempDS.Tables[0].Rows) list.Add(new myChatLine(row)); return list; } return new List<myChatLine>(); }
public static int GetChatLinesByGameRoomID__Count(int aGameRoomID ) { myChatLineData tempADO = new myChatLineData(); DataSet tempDS = tempADO.GetChatLinesByGameRoomID__Count( aGameRoomID); if (tempADO.HasData) { return int.Parse(tempDS.Tables[0].Rows[0][0].ToString()); } return 0; }