public static List <FeedBackQue> GetAll(int FeedBkId)
{
DBCon OBJCon = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
List <FeedBackQue> ListTmp = new List <FeedBackQue>();
try
{
string Query = "SELECT * FROM FeedBackQuestion where FeedBkFormID=" + FeedBkId;
cmd = new SqlCommand(Query, OBJCon.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
FeedBackQue ObjTmp = new FeedBackQue();
ObjTmp.ID = SDR.GetInt32(0);
ObjTmp.Title = SDR.GetString(1);
ObjTmp.Status = SDR.GetBoolean(2);
ObjTmp.QuestionType = SDR.GetInt32(3);
ObjTmp.FeedBkFormID = SDR.GetInt32(4);
ObjTmp.OrderNo = SDR.GetInt32(5);
ListTmp.Add(ObjTmp);
}
}
catch (System.Exception e) { e.ToString(); }
finally { cmd.Dispose();; OBJCon.Con.Close(); }
return(ListTmp);
}
public static FeedBackQue Getone(int QID)
{
DBCon OBJCon = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
FeedBackQue ObjTmp = new FeedBackQue();
try
{
string Query = "SELECT TOP 1 * FROM FeedBackQuestion where ID=" + QID;
cmd = new SqlCommand(Query, OBJCon.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTmp.ID = SDR.GetInt32(0);
ObjTmp.Title = SDR.GetString(1);
ObjTmp.Status = SDR.GetBoolean(2);
ObjTmp.QuestionType = SDR.GetInt32(3);
ObjTmp.FeedBkFormID = SDR.GetInt32(4);
ObjTmp.OrderNo = SDR.GetInt32(5);
}
}
catch (System.Exception e) { e.ToString(); }
finally { cmd.Dispose(); OBJCon.Con.Close(); }
return(ObjTmp);
}