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