public int Add_Player(Player p)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
Player player = new Player();
Id data = new Id();
player.PlayerName = p.PlayerName;
player.TeamName = p.TeamName;
player.Age = p.Age;
player.BirthPlace = p.BirthPlace;
player.Role = p.Role;
player.BattingStyle = p.BattingStyle;
player.BowlingStyle = p.BowlingStyle;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
player.PlayerId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.Players.Add(player);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
Entities1 entity = new Entities1();
try
{
Player t = new Player();
Id i = new Id();
t.PlayerName = txtPlayerName.Text;
t.TeamName = txtTeamName.SelectedValue;
t.Age = int.Parse(txtAge.Text);
t.BirthPlace = txtBirthPlace.Text;
t.Role = txtRole.Text;
t.BattingStyle = txtBattingStyle.Text;
t.BowlingStyle = txtBowlingStyle.Text;
BLL obj = new BLL();
obj.insert_Player(t);
Response.Write("<script type = 'text/javascript'>alert('Inserted successfully')</script>");
}
catch (Exception ex)
{
throw ex;
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (tb_user_name.Text.Trim() == "" && tb_password.Text.Trim() == "")
{
MessageBox.Show("Please input username/email and password!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
EmptyTb();
tb_user_name.Focus();
}
else
{
Entities1 mdl = new Entities1();
mdl.Connection.Open();
using (MD5 md5Hash = MD5.Create())
{
string hash = this.GetMd5Hash(md5Hash, tb_password.Text);
user login = mdl.sp_login_user(tb_user_name.Text, hash).FirstOrDefault();
if (login != null)
{
Global.GlobalVar = tb_user_name.Text;
MDI frmMDI = new MDI();
//Application.Run(new MDI());
this.Close();
frmMDI.ShowDialog();
}
else
{
MessageBox.Show("Username/Email or password Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
EmptyTb();
tb_user_name.Focus();
}
}
}
}
public int Delete_News(int id)
{
var obj = new List <News>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.News
where t.MatchId == id
select t).ToList();
foreach (var t in obj)
{
entity.News.Remove(t);
}
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
Ticket t = new Ticket();
Entities1 entity = new Entities1();
for (int i = 0; i < 10; i++)
{
for (int j = 0; j < 10; j++)
{
count[i, j] = 100;
}
}
TeamName1.Text = count[0, 0].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_Statistics(Stat x)
{
var obj = new List <Stat>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.Stats
where t.TeamId == x.TeamId
select t).ToList();
obj[0].TeamId = x.TeamId;
obj[0].Played = x.Played;
obj[0].Won = x.Won;
obj[0].Lost = x.Lost;
obj[0].Tied = x.Tied;
obj[0].NR = x.NR;
obj[0].NetRR = x.NetRR;
obj[0].Pts = x.Pts;
obj[0].FromPoints = x.FromPoints;
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
}
public void Update_Tc(TicketCategory x)
{
var obj = new List <TicketCategory>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.TicketCategories
where t.TicketCategoryId == x.TicketCategoryId
select t).ToList();
obj[0].TicketCategoryId = x.TicketCategoryId;
obj[0].TicketCategoryName = x.TicketCategoryName;
obj[0].TicketDescription = x.TicketDescription;
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
}
public int Add_News(News s)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
News news = new News();
Id data = new Id();
news.MatchName = s.MatchName;
news.Newsdate = s.Newsdate;
news.NewsDescription = s.NewsDescription;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
news.NewsId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.News.Add(news);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
public bool SendStateInfoDB(string userNickName, PersonStateInfo state, string message)
{
try
{
Entities1 dbContext = new Entities1();
var count = dbContext.LEAVEWORDINFO.ToList().Count;
var leaveMsg = new LEAVEWORDINFO()
{
WORDID = Guid.NewGuid().ToString(),
NICKNAME = userNickName,
MESSAGE = message,
LEAVETIME = DateTime.Now
};
if (state == PersonStateInfo.课)
{
leaveMsg.LEAVESTATE = "上课";
}
if (state == PersonStateInfo.请假)
{
leaveMsg.LEAVESTATE = "请假";
}
dbContext.LEAVEWORDINFO.Add(leaveMsg);
var num = dbContext.SaveChanges();
if (num == 1)
{
return(true);
}
}
catch
{
}
return(false);
}
public int Add_Statistics(Stat s)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
Stat stat = new Stat();
Id data = new Id();
stat.TeamName = s.TeamName;
stat.Played = s.Played;
stat.Won = s.Won;
stat.Lost = s.Lost;
stat.Tied = s.Tied;
stat.NR = s.NR;
stat.NetRR = s.NetRR;
stat.Pts = s.Pts;
stat.FromPoints = s.FromPoints;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
stat.StatId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.Stats.Add(stat);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
public int Add_Tc(TicketCategory s)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
TicketCategory ticketcat = new TicketCategory();
Id data = new Id();
ticketcat.TicketCategoryName = s.TicketCategoryName;
ticketcat.TicketDescription = s.TicketDescription;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
ticketcat.TicketCategoryId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.TicketCategories.Add(ticketcat);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
public int Add_Schedule(Schedule s)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
Schedule sch = new Schedule();
Id data = new Id();
sch.MatchName = s.MatchName;
sch.VenueName = s.VenueName;
sch.ScheduleDate = s.ScheduleDate;
sch.StartTime = s.StartTime;
sch.EndTime = s.EndTime;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
sch.ScheduleId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.Schedules.Add(sch);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
public int Add_Match(Match m)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
Match match = new Match();
Id data = new Id();
match.MatchName = m.MatchName;
match.TeamOneName = m.TeamOneName;
match.TeamTwoName = m.TeamTwoName;
match.VenueName = m.VenueName;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
match.MatchId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.Matches.Add(match);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
public int Add_Venue(Venue v)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
Venue venue = new Venue();
Id data = new Id();
venue.VenueName = v.VenueName;
venue.Location = v.Location;
venue.VenueDescription = v.VenueDescription;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
venue.VenueId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.Venues.Add(venue);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
public void Update_Schedule(Schedule x)
{
var obj = new List <Schedule>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.Schedules
where t.ScheduleId == x.ScheduleId
select t).ToList();
obj[0].ScheduleId = x.ScheduleId;
obj[0].MatchId = x.MatchId;
obj[0].Schedule_VenueId = x.Schedule_VenueId;
obj[0].ScheduleDate = x.ScheduleDate;
obj[0].StartTime = x.StartTime;
obj[0].EndTime = x.EndTime;
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
}
public bool SendSignInfoToDB(PersonSignInfo personSign)
{
try
{
Entities1 dbContext = new Entities1();
var count = dbContext.SIGNINFO.ToList().Count;
SIGNINFO signInfo = new SIGNINFO()
{
SIGNINFOID = Guid.NewGuid().ToString(),
NICKNAME = personSign.UserNickName,
SIGNTIME = personSign.SignTime,
};
if (personSign.IsSign == true)
{
signInfo.ISSIGN = "YES";
}
if (personSign.IsSign == false)
{
signInfo.ISSIGN = "No";
}
dbContext.SIGNINFO.Add(signInfo);
var num = dbContext.SaveChanges();
if (num == 1)
{
return(true);
}
}
catch
{
}
return(false);
}
public int Add_Statistics(Stat s)
{
try
{
Entities1 entity = new Entities1();
Stat st = new Stat()
{
TeamId = s.TeamId,
Played = s.Played,
Won = s.Won,
Lost = s.Lost,
Tied = s.Tied,
NR = s.NR,
NetRR = s.NetRR,
Pts = s.Pts,
FromPoints = s.FromPoints
};
entity.Stats.Add(st);
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
private bool TryCreateNewDatabase(string serverName, string Database, bool IntegratedSecurity, string UserID, string Password)
{
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
sqlBuilder.DataSource = serverName;
sqlBuilder.InitialCatalog = Database;
sqlBuilder.MultipleActiveResultSets = true;
if (IntegratedSecurity)
{
sqlBuilder.IntegratedSecurity = true;
}
else
{
sqlBuilder.UserID = UserID;
sqlBuilder.Password = Password;
}
Entities1.DefaultConnectionString = sqlBuilder.ToString();
Entities1.DefaultCommandTimeoutSeconds = 300;
using (Entities1 dc = new Entities1())
{
//dc.Database.CreateIfNotExists();
//dc.Database.Initialize(true);
dc.Database.Connection.Open();
}
return(true); // no exception, database created, success
}
public int Delete_Tc(int id)
{
var obj = new List <TicketCategory>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.TicketCategories
where t.TicketCategoryId == id
select t).ToList();
foreach (var t in obj)
{
entity.TicketCategories.Remove(t);
}
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
public JsonResult GetVisitReasons()
{
List <TVisitReason> all = null;
using (Entities1 dc = new Entities1()) {
dc.Configuration.ProxyCreationEnabled = false;
var visitReason = from a in dc.TVisitReasons
select new {
a
};
if (visitReason != null)
{
all = new List <TVisitReason>();
foreach (var i in visitReason)
{
TVisitReason con = i.a;
all.Add(con);
}
}
}
return(new JsonResult {
Data = all, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public void Update_Team(Team x)
{
var obj = new List <Team>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.Teams
where t.TeamId == x.TeamId
select t).ToList();
obj[0].TeamName = x.TeamName;
obj[0].HomeGround = x.HomeGround;
obj[0].Owners = x.Owners;
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
}
public List <News> SelectAll_News()
{
List <News> t = new List <News>();
try
{
Entities1 entity = new Entities1();
var obj = (from t1 in entity.News
select new
{
t1.MatchId,
t1.NewsDescription
});
foreach (var up in obj)
{
t.Add(new News()
{
MatchId = up.MatchId,
NewsDescription = up.NewsDescription
});
}
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(t);
}
public ActionResult ListOrder(int id)
{
using (Entities1 db = new Entities1())
{
return(View(db.Orders.Where(x => x.userID == id).ToList()));
}
}
public void Update_Player(Player x)
{
var obj = new List <Player>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.Players
where t.PlayerId == x.PlayerId
select t).ToList();
obj[0].PlayerName = x.PlayerName;
obj[0].TeamId = x.TeamId;
obj[0].Age = x.Age;
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
}
public ActionResult Login(string returnUrl)
{
Entities1 et = new Entities1();
Cart ct = et.Carts.Find(1);
ct.Item1 = 25;
ct.Item2 = 25;
ct.Item3 = 25;
ct.Item4 = 25;
ct.Item5 = 25;
ct.Item6 = 25;
et.SaveChanges();
//String connectionStr = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Hira\Documents\Visual Studio 2013\Projects\foodweb\foodweb\App_Data\mydb.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework";
//SqlConnection con = new SqlConnection(connectionStr);
//String query = "update Cart set item1 = 25, item2 = 25,item3 = 25, item4 = 25, item5 = 25, item6 = 25 where Id=1";
//SqlCommand cmd = new SqlCommand(query, con);
//con.Open();
//int i = cmd.ExecuteNonQuery();
//if (i > 0)
//{
// Console.WriteLine("inserted");
//}
//con.Close();
ViewBag.ReturnUrl = returnUrl;
return(View());
}
public void Update_Venue(Venue x)
{
var obj = new List <Venue>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.Venues
where t.VenueId == x.VenueId
select t).ToList();
obj[0].VenueId = x.VenueId;
obj[0].Location = x.Location;
obj[0].VenueDescription = x.VenueDescription;
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
Entities1 entity = new Entities1();
try
{
Schedule t = new Schedule();
Id i = new Id();
t.MatchName = txtMatchName.Text;
t.VenueName = ddlVenue.SelectedValue;
t.ScheduleDate = DateTime.Parse(txtScheduleDate.Text);
t.StartTime = txtStartTime.Text;
t.EndTime = txtEndTime.Text;
BLL obj = new BLL();
obj.insert_Schedule(t);
Response.Write("<script type = 'text/javascript'>alert('Inserted successfully')</script>");
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_Match(Match x)
{
var obj = new List <Match>();
try
{
Entities1 entity = new Entities1();
obj = (from t in entity.Matches
where t.MatchId == x.MatchId
select t).ToList();
obj[0].MatchId = x.MatchId;
obj[0].TeamOneId = x.TeamOneId;
obj[0].TeamTwoId = x.TeamTwoId;
obj[0].VenueId = x.VenueId;
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
Entities1 entity = new Entities1();
try
{
Stat t = new Stat();
Id i = new Id();
t.TeamName = TeamName.SelectedValue;
t.Played = int.Parse(txtPlayed.Text);
t.Won = int.Parse(txtWon.Text);
t.Lost = int.Parse(txtLost.Text);
t.Tied = int.Parse(txtTied.Text);
t.NR = int.Parse(txtNR.Text);
t.NetRR = decimal.Parse(txtNetRR.Text);
t.Pts = int.Parse(TextBox1.Text);
t.FromPoints = int.Parse(txtFromPoints.Text);
BLL obj = new BLL();
obj.insert_Statistics(t);
Response.Write("<script type = 'text/javascript'>alert('Inserted successfully')</script>");
}
catch (Exception ex)
{
throw ex;
}
}
public int Add_Team(Team t)
{
try
{
Entities1 entity = new Entities1();
Entities1 ent = new Entities1();
Team team = new Team();
Id data = new Id();
team.TeamName = t.TeamName;
team.HomeGround = t.HomeGround;
team.Owners = t.Owners;
var val = (entity.Ids.OrderByDescending(u => u.idd).FirstOrDefault());
team.TeamId = val.idd;
data.name = "";
ent.Ids.Add(data);
entity.Teams.Add(team);
ent.SaveChanges();
entity.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return(1);
}
