public string GetNoOfInq()
{
DataCon dc = new DataCon();
string zk = "select * from inquiry where InquiryDate='" + current_time.ToShortDateString() + "' and IsAnswered=0";
DataSet ds = new DataSet();
ds = dc.getdata(zk);
return(ds.Tables[0].Rows.Count.ToString());
}
public string GetNoOfAdmInq()
{
DataCon dc = new DataCon();
string zk = "select * from admissionform where RegistarionDate='" + current_time.ToShortDateString() + "' and IsAnswered=0";
DataSet ds = new DataSet();
ds = dc.getdata(zk);
return(ds.Tables[0].Rows.Count.ToString());
}
private void BarGraphSystem()
{
_myMenu = new Menu("Show Average of Reviews for Restaurants", "Dinner Spinner", "Top 10 Restaurants", "Back to Main Menu");
_myMenu.Title = "Bar Graph Menu";
bool running = true;
while (running)
{
_myMenu.Display();
int selection = Validation.IntVal("Enter Selection");
switch (selection)
{
case 1:
{
Console.Clear();
_data = new DataCon();
_data.BarGraph();
Console.ReadKey();
}
break;
case 2:
{
Console.Clear();
_data = new DataCon();
_data.BarGraphRand();
Console.ReadKey();
}
break;
case 3:
{
Console.Clear();
_data = new DataCon();
_data.BarGraph();
Console.ReadKey();
}
break;
case 4:
{
Selection();
}
break;
}
}
}
protected void gvModuleInfo_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataCon dataCon = new DataCon();
SqlConnection sqlconn = dataCon.getCon();
string fileid = gvModuleInfo.DataKeys[e.RowIndex].Value.ToString();
if (fileid == "34")
{
Response.Write("<script language=javascript>alert('综合交流专题不能删除！');</script>");
return;
}
string str = "select ModuleImage from tb_Module where ModuleID=" + fileid;
sqlconn.Open();
SqlCommand sqlcom = new SqlCommand(str, sqlconn);
SqlDataReader sdr = sqlcom.ExecuteReader();
sdr.Read();
string filename = sdr["ModuleImage"].ToString();
string strFilePath = Server.MapPath("~/IndexImages/") + filename;
if (File.Exists(strFilePath))
{
File.Delete(strFilePath);
}
string strImageurl2 = Server.MapPath("~/NewsImages/") + filename;
if (File.Exists(strImageurl2))
{
File.Delete(strImageurl2);
}
sdr.Close();
sqlconn.Close();
string sqlstr = "delete from tb_Module where ModuleID='" + gvModuleInfo.DataKeys[e.RowIndex].Value + "'";
string sqlstrcard = "delete from tb_card where ModuleID='" + gvModuleInfo.DataKeys[e.RowIndex].Value + "'";
string sqlstrRevertCard = "delete from tb_RevertCard where CardID IN ( select CardID from tb_Card where ModuleID='" + gvModuleInfo.DataKeys[e.RowIndex].Value + "' )";
List <string> SQLStringList = new List <string>();
SQLStringList.Add(sqlstrRevertCard); //先删除所含帖子的回复贴
SQLStringList.Add(sqlstrcard); //再删除所含帖子
SQLStringList.Add(sqlstr); //最后删除专题自己
int flag = DbHelperSQL.ExecuteSqlTran(SQLStringList);
if (flag > 0)
{
Response.Write("<script language=javascript>alert('删除成功');</script>");
Response.Redirect("ManageMudole.aspx");
}
Response.Redirect("ManageMudole.aspx");
}
//Methods
private void FiveStarRating()
{
_myMenu = new Menu("List Restaurants Alphebetically", "List Restaurants Reverse Aplphebetical", "Sort Restaurants From Best to Worst", "Sort Restaurants From Worst to Best", "Show Only X and Up", "Exit");
_myMenu.Title = "Rating Menu";
bool running = true;
while (running)
{
_myMenu.Display();
int selection = Validation.IntVal("Enter Selection");
switch (selection)
{
case 1:
{
Console.Clear();
_data = new DataCon();
_data.Alphabet();
Console.ReadKey();
}
break;
case 2:
{
Console.Clear();
_data = new DataCon();
_data.ReverseAlphabet();
Console.ReadKey();
}
break;
case 3:
{
Console.Clear();
_data = new DataCon();
_data.BestToWorst();
Console.ReadKey();
}
break;
case 4:
{
Console.Clear();
_data = new DataCon();
_data.WorstToBest();
Console.ReadKey();
}
break;
case 5:
{
Console.Clear();
XAndUp();
}
break;
case 6:
{
Selection();
}
break;
}
}
}
private void Selection()
{
_myMenu = new Menu("Convert Reviews From SQL to JSON", "Showcase our 5 Star Rating System", "Showcase our Animated Bar Graph Review System", "Play a Card Game", "Exit");
bool running = true;
while (running)
{
_myMenu.Display();
int selection = Validation.IntVal("Enter Selection");
switch (selection)
{
case 1:
{
Console.Clear();
_data = new DataCon();
_data.ToJson();
Console.ReadKey();
}
break;
case 2:
{
Console.Clear();
FiveStarRating();
Console.ReadKey();
}
break;
case 3:
{
Console.Clear();
BarGraphSystem();
Console.ReadKey();
}
break;
case 4:
{
Console.Clear();
_data = new DataCon();
_data.Cardgame();
Console.ReadKey();
}
break;
case 5:
{
Environment.Exit(0);
}
break;
}
}
}
private void XAndUp()
{
_myMenu = new Menu("Show the Best", "4 and Up", "3 and Up", "Show One Star", "Unrated", "Exit");
_myMenu.Title = "X and Up Menu";
bool running = true;
while (running)
{
_myMenu.Display();
int selection = Validation.IntVal("Enter Selection");
switch (selection)
{
case 1:
{
Console.Clear();
_data = new DataCon();
_data.FiveStars();
Console.ReadKey();
}
break;
case 2:
{
Console.Clear();
_data = new DataCon();
_data.FourAndUp();
Console.ReadKey();
}
break;
case 3:
{
Console.Clear();
_data = new DataCon();
_data.ThreeAndUp();
Console.ReadKey();
}
break;
case 4:
{
Console.Clear();
_data = new DataCon();
_data.OneStar();
Console.ReadKey();
}
break;
case 5:
{
Console.Clear();
_data = new DataCon();
_data.Unrated();
Console.ReadKey();
}
break;
case 6:
{
Selection();
}
break;
}
}
}
