private int SaveToDB(string filename, int ticketid) { try { FileInfo fileStream = new FileInfo(filename); var fileupload = new FileUpload(); byte[] filecontent = new byte[fileStream.Length]; FileStream imagestream = fileStream.OpenRead(); imagestream.Read(filecontent, 0, filecontent.Length); imagestream.Close(); fileupload.Filedata = filecontent; fileupload.FileName = fileStream.Name; fileupload.UploadDate = DateTime.Now; fileupload.Filetype = fileStream.Name.Split('.')[1].ToString(); fileupload.TicketId = ticketid; TicketDB.FileUpload.Add(fileupload); TicketDB.SaveChanges(); if ((System.IO.File.Exists(filename))) { System.IO.File.Delete(filename); } return(1); } catch (System.Exception e) { Log.LogDebug(e.Message); return(0); } }
private void wjwCountNum_Click(object sender, RoutedEventArgs e) { TicketDB ticket = new TicketDB(); int num = int.Parse(count.Text); Hashtable table = new Hashtable(); if (num > 0) { table = ticket.findBallListOfNum(num); } if (table != null) { List <int> redList = (List <int>)table["redList"]; List <int> blueList = (List <int>)table["blueList"]; List <int> redFullList = (List <int>)table["redFullList"]; List <int> blueFullList = (List <int>)table["blueFullList"]; if (redList != null && blueList != null && redList.Count > 0 && blueList.Count > 0) { this.content.Text = sb.getAppearRedBall(redList) + sb.getNoAppearRedBall(redList) + sb.getAppearBlueBall(blueList) + sb.getNoAppearBlueBall(blueList) + sb.getRedBallFrequency(redFullList) + sb.getBlueBallFrequency(blueFullList); } else { this.content.Text = "没有相关数据!\r\n"; } } }
private void BtnAddOrUpdate_Click(object sender, EventArgs e) { if (FieldsAreValid()) { PopulateTicket(); TicketDB.AddOrUpdate(Ticket); this.Close(); } }
public IActionResult Put(int id, [FromBody] keyvalueModel value) { ApplicationMaster _applicationMaster = new ApplicationMaster() { ApplicationId = value.Id, ApplicationName = value.keyValue, IsDeleted = false }; TicketDB.Entry(_applicationMaster).State = EntityState.Modified; return(Ok(TicketDB.SaveChanges())); }
private void wjwOperation_Click(object sender, RoutedEventArgs e) { TicketDB ticket = new TicketDB(); List <int> list = ticket.findListOfOneNum("2018"); if (list != null && list.Count > 0) { var result = new DiscreteMarkov(list, 33, 5); this.content.Text = "预测状态概率::" + result.PredictValue[0] + "\r\n" + "概率转移矩阵:" + result.ProbMatrix + "\r\n"; } }
public IActionResult Post([FromBody] keyvalueModel value) { var app = new ApplicationMaster() { ApplicationId = value.Id, ApplicationName = value.keyValue, IsDeleted = false }; TicketDB.ApplicationMaster.Add(app); TicketDB.SaveChanges(); TicketDB.Dispose(); return(CreatedAtAction(nameof(GetById), new { id = app.ApplicationId })); }
private void BtnCreateTicket_Click(object sender, EventArgs e) { if (IsValid()) { string title = TxtTitle.Text; DateTime?due = (DtpDueDate.Checked) ? (DateTime?)DtpDueDate.Value : null; Priority priority = (Priority)CboPriorities.SelectedItem; Ticket newTicket = new Ticket(title, due, priority); TicketDB.Create(newTicket); } LoadTickets(); }
public IActionResult Put(int id, [FromBody] Tickets value) { Tickets _ticket = new Tickets() { TicketId = id, Title = value.Title, Tdescription = value.Tdescription, CreatedBy = value.CreatedBy, StatusId = value.StatusId, Createddate = value.Createddate, AssignedTo = value.AssignedTo, PriorityId = value.PriorityId, TypeId = value.TypeId, ApplicationId = value.ApplicationId, ModuleId = value.ModuleId, ResponseDeadline = value.ResponseDeadline, ResolutionDeadline = value.ResolutionDeadline, RootCauseId = value.RootCauseId, Comments = value.Comments, UpdatedBy = Convert.ToInt32(GetClaimValue(ClaimTypes.Name)), LastModifiedon = value.LastModifiedon }; if (_ticket.TicketId == 0) { TicketDB.Tickets.Add(_ticket); } else { TicketDB.Entry(_ticket).State = EntityState.Modified; } return(Ok(TicketDB.SaveChanges())); }
private void BtnCreateTicket_Click(object sender, EventArgs e) { if (IsValid()) { string title = TxtTitle.Text; DateTime?due = (DateTime?)DtpDueDate.Value; Priority priority = (Priority)CboPriorities.SelectedItem; Ticket newTicket = new Ticket(title, due, priority); TicketDB.Create(newTicket); FrmAddComment newComment = new FrmAddComment(newTicket); newComment.ShowDialog(); } LoadTickets(); }
public IActionResult Put(int id, [FromBody] TodoList value) { TodoList _todoitem = new TodoList() { TodoId = value.TodoId, Userid = value.Userid, Titile = value.Titile, Description = value.Description, ActionDate = value.ActionDate, IsActive = value.IsActive }; if (_todoitem.TodoId == 0) { TicketDB.TodoList.Add(_todoitem); } else { TicketDB.Entry(_todoitem).State = EntityState.Modified; } TicketDB.SaveChanges(); return(Ok(1)); }
private void wjwSameForecast_Click(object sender, RoutedEventArgs e) { NumConfig numConfig = new NumConfig(); String termStr = term.Text; if (termStr == null || termStr == "") { return; } TicketDB ticket = new TicketDB(); List <int> list = ticket.findSameForecastListOfTerm(termStr); if (list != null) { this.content.Text = sb.getAppearRedBall(list) + sb.getNoAppearRedBall(list); } else { this.content.Text = "没有相关数据!\r\n"; } }
public IActionResult adduser([FromBody] UserModel value) { try { if (value.FirstName == null || value.LastName == null || value.EmailId == null || value.Roleid == null) { throw new InvalidOperationException("invalid user details"); } Log.LogInformation("Saving users"); TicketDB.Resource.Add(new Resource() { Fname = value.FirstName, Lname = value.LastName, Email = value.EmailId, Pwd = "1234", Roles = "2", Isactive = true }); TicketDB.SaveChanges(); Log.LogInformation("Saving complete"); return(Ok(1)); } catch (System.Exception e) { Log.LogError(null, e); return(ValidationProblem("something wrong with user details " + e.Message)); } }
public IActionResult Delete(int id) { TicketDB.ApplicationMaster.Remove(TicketDB.ApplicationMaster.FirstOrDefault(x => x.ApplicationId == id)); TicketDB.SaveChanges(); return(Ok(1)); }
protected virtual void LoadTickets() { LstTickets.DataSource = null; LstTickets.DataSource = TicketDB.GetAllTicketsCreatedByUser(State.CurrUser); }
public TicketBiz() { ticketdb = new TicketDB(); }
protected virtual void LoadTickets() { LstTickets.DataSource = null; LstTickets.DataSource = TicketDB.GetAllTickets(); }
public void LoadEntities() { UserDB userDB = new UserDB(); ManifestationDB manifestationDB = new ManifestationDB(); LocationDB locationDB = new LocationDB(); TicketDB ticketDB = new TicketDB(); CommentDB commentDB = new CommentDB(); User user1 = new User(); user1.Username = "******"; user1.Name = "User1"; user1.Surname = "User1"; user1.Password = "******"; user1.Gender = "male"; user1.Role = "Buyer"; user1.DateOfBirth = Convert.ToDateTime("12/01/1995"); user1.ManifestationId = ""; user1.TicketId = "2894181f-4595-4a3f-8f68-39e937d4d206"; user1.Type = "Bronze"; user1.Points = 133; user1.NoQuit = 0; user1.IsBlocked = false; user1.IsActive = true; userDB.Insert(user1); User user2 = new User(); user2.Username = "******"; user2.Name = "User2"; user2.Surname = "User2"; user2.Password = "******"; user2.Gender = "male"; user2.Role = "Buyer"; user2.DateOfBirth = Convert.ToDateTime("12/05/1965"); user2.ManifestationId = ""; user2.TicketId = ""; user2.Type = ""; user2.Points = 0; user2.NoQuit = 0; user2.IsBlocked = false; user2.IsActive = true; userDB.Insert(user2); User seller = new User(); seller.Username = "******"; seller.Name = "seller1"; seller.Surname = "seller1"; seller.Password = "******"; seller.Gender = "male"; seller.Role = "Seller"; seller.DateOfBirth = Convert.ToDateTime("10/05/1994"); seller.ManifestationId = "5b6a4143-87c0-4d7b-817b-0458dd7cf726"; seller.TicketId = ""; seller.Type = ""; seller.Points = 0; seller.NoQuit = 0; seller.IsBlocked = false; seller.IsActive = true; userDB.Insert(seller); User seller2 = new User(); seller2.Username = "******"; seller2.Name = "seller2"; seller2.Surname = "seller2"; seller2.Password = "******"; seller2.Gender = "male"; seller2.Role = "Seller"; seller2.DateOfBirth = Convert.ToDateTime("02/11/1945"); seller2.ManifestationId = "168273d1-fdcb-4527-8c8a-e77bd4b331d4"; seller2.TicketId = ""; seller2.Type = ""; seller2.Points = 0; seller2.NoQuit = 0; seller2.IsBlocked = false; seller2.IsActive = true; userDB.Insert(seller2); Manifestation event1 = new Manifestation(); event1.Id = new Guid("d58dfb04-822f-41d7-b170-973e69514fce"); event1.Name = "Event1"; event1.Type = "Festival"; event1.Capacity = 190; event1.CapacityVIP = 20; event1.CapacityRegular = 130; event1.CapacityFunPit = 40; event1.Price = 100; event1.EventTime = new DateTime(2020, 12, 15); event1.Status = "Approved"; event1.Place = "81 Bulevar oslobodjenja, Novi Sad, Serbia"; event1.SellerId = "seller1"; event1.Pictures = "poster2.png;"; event1.IsActive = true; event1.LocationId = "2d3b287e-ba87-49ab-971f-af431648eb2d"; manifestationDB.Insert(event1); Manifestation event2 = new Manifestation(); event2.Id = new Guid("5b6a4143-87c0-4d7b-817b-0458dd7cf726"); event2.Name = "Event2"; event2.Type = "Concert"; event2.Capacity = 100; event2.CapacityVIP = 10; event2.CapacityRegular = 70; event2.CapacityFunPit = 20; event2.Price = 500; event2.EventTime = new DateTime(2021, 1, 25); event2.Status = "Approved"; event2.Place = "Mise Dimitrijevica 2, Novi Sad, Serbia"; event2.SellerId = "seller1"; event2.Pictures = "poster1.jpg;"; event2.IsActive = true; event2.LocationId = "28a19974-ea43-46dc-972a-8f8eeb7d52ee"; manifestationDB.Insert(event2); Manifestation event3 = new Manifestation(); event3.Id = new Guid("168273d1-fdcb-4527-8c8a-e77bd4b331d4"); event3.Name = "Event3"; event3.Type = "Festival"; event3.Capacity = 50; event3.CapacityVIP = 5; event3.CapacityRegular = 35; event3.CapacityFunPit = 10; event3.Price = 1000; event3.EventTime = new DateTime(2021, 2, 5); event3.Status = "Approved"; event3.Place = "Mise Dimitrijevica 2, Novi Sad, Serbia"; event3.SellerId = "seller2"; event3.Pictures = "poster1.jpg;"; event3.IsActive = true; event3.LocationId = "28a19974-ea43-46dc-972a-8f8eeb7d52ee"; manifestationDB.Insert(event3); Location location1 = new Location(); location1.Id = new Guid("28a19974-ea43-46dc-972a-8f8eeb7d52ee"); location1.Address = "Mise Dimitrijevica 2, Novi Sad, Serbia"; location1.Lattitude = 45.247537f; location1.Longitude = 19.834377f; locationDB.Insert(location1); Location location2 = new Location(); location2.Id = new Guid("2d3b287e-ba87-49ab-971f-af431648eb2d"); location2.Address = "81 Bulevar oslobodjenja, Novi Sad, Serbia"; location2.Lattitude = 45.254244f; location2.Longitude = 19.836737f; locationDB.Insert(location2); Ticket ticket1 = new Ticket(); ticket1.Id = "2894181f-4595-4a3f-8f68-39e937d4d206"; ticket1.Buyer = "User1 User1"; ticket1.EventTime = new DateTime(2020, 12, 15); ticket1.IsActive = true; ticket1.ManifestationId = "d58dfb04-822f-41d7-b170-973e69514fce"; ticket1.Price = 1000; ticket1.SellerId = "seller1"; ticket1.Status = "Reserved"; ticket1.Type = "Regular"; ticketDB.Insert(ticket1); Comment comment1 = new Comment(); comment1.Id = new Guid("6cd3d269-ea5b-4110-a4f1-b28518bfffce"); comment1.IsActive = false; comment1.ManifestationId = "d58dfb04-822f-41d7-b170-973e69514fce"; comment1.Rating = 5; comment1.Text = "Ova manifestacija je odlicna!"; comment1.UserId = "User1"; commentDB.Insert(comment1); }