static public int GetmovieId(string movieName) { DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); var getMovieId = nw.Movies.Where(x => x.Name == movieName).FirstOrDefault(); return(getMovieId.Id); }
protected void Page_Load(object sender, EventArgs e) { count = 0; if (TextBox1.Text == "" && TextBox2.Text == "" && TextBox3.Text == "") { var currentUser = (UserInfoClass)Session["UserInfo"]; Label1.Text = currentUser.getUserName(); DataClasses3DataContext dc = new DataClasses3DataContext(); var StudentBio = from q in dc.StudentBios where q.Username == Label1.Text select q; foreach (var StudentBio1 in StudentBio) { count = count + 1; TextBox1.Text = StudentBio1.Name; TextBox2.Text = StudentBio1.Class; TextBox3.Text = StudentBio1.Writeup; } loadedOnce = loadedOnce + 1; } else { count = 1;//screen has been changed before } }
private void button1_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(textBox1.Text) || String.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("Bạn chưa nhập đủ username và password"); } else { DataClasses3DataContext data = new DataClasses3DataContext(); var admin = data.NhanViens.Where(p => p.username.Contains(textBox1.Text) && p.password.Contains(textBox2.Text)).Select(p => new { p.MaNV, p.TenNhanVien, p.username, p.password, p.MaQuyen }); if (admin.Any()) { Admin ad = new Admin(); foreach (var item in admin) { SetValueForText1 = item.TenNhanVien; MaNV = item.MaNV; checkQuyen = item.MaQuyen; } ad.Show(); this.Hide(); } if (!admin.Any()) { MessageBox.Show("Kiểm tra lại username và password"); } } }
static public int GetcustomerId(string custName) { DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); var getCustId = nw.Customers.Where(x => x.Name == custName).FirstOrDefault(); return(getCustId.Id); }
protected void Button1_Click(object sender, EventArgs e) { DataClasses3DataContext dc = new DataClasses3DataContext(); StudentBio newStudentBio = new StudentBio(); newStudentBio.Username = Label1.Text; newStudentBio.Name = TextBox1.Text; newStudentBio.Class = TextBox2.Text; newStudentBio.Writeup = TextBox3.Text; if (count == 0) { dc.StudentBios.InsertOnSubmit(newStudentBio); dc.SubmitChanges(); } else { var StudentBio = from q in dc.StudentBios where q.Username == Label1.Text select q; foreach (var StudentBio1 in StudentBio) { StudentBio1.Name = TextBox1.Text; StudentBio1.Class = TextBox2.Text; StudentBio1.Writeup = TextBox3.Text; dc.SubmitChanges(); } } }
public static void InsertNewCustomer(string strCustName, int intAge, string strSubscription) { DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); Customer cust = new Customer(); cust.Name = strCustName; cust.Age = intAge; cust.Subscription = strSubscription; nw.Customers.InsertOnSubmit(cust); nw.SubmitChanges(); }
public static void InsertNewMovie(string strMovieName, string strCategoryName) { string strConnectionString = DalUtils.GetConnectionString(); DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); Movies movie = new Movies(); movie.Name = strMovieName; movie.Category = strCategoryName; nw.Movies.InsertOnSubmit(movie); nw.SubmitChanges(); }
public static void InsertNewRental(string strCustName, string strMovieName)//כותב לטבלה את הנתונים ומחזיר כמה שורות הושפעו { DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); int getCustId = GetcustomerId(strCustName); int getMovieId = GetmovieId(strMovieName); Rental rental = new Rental(); rental.CustID = getCustId; rental.MovieID = getMovieId; nw.Rentals.InsertOnSubmit(rental); nw.SubmitChanges(); }
static public void DeleteRentedMovie(string Name, string Movie) { int getCustId = GetcustomerId(Name); int getMovieId = GetmovieId(Movie); DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); var listToBeDeleted = nw.Rentals.Where(x => x.CustID == getCustId && x.MovieID == getMovieId); foreach (var item in listToBeDeleted) { nw.Rentals.DeleteOnSubmit(item); } nw.SubmitChanges(); }
public static List <Rental> GetRentalList() { List <Rental> list = new List <Rental>(); DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); var resultQuery = from rent in nw.Rentals select rent; foreach (var item in resultQuery) { list.Add(new Rental { Id = item.Id, CustID = item.CustID, MovieID = item.MovieID }); } return(list); }
public static List <Movies> GetMoviesList() { List <Movies> list = new List <Movies>(); DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); var resultQuery = from movie in nw.Movies select movie; foreach (var item in resultQuery) { list.Add(new Movies { Id = item.Id, Name = item.Name, Category = item.Category }); } return(list); }
public static List <Customer> GetCustomersList() { List <Customer> list = new List <Customer>(); DataClasses3DataContext nw = new DataClasses3DataContext(DalUtils.GetConnectionString()); var resultQuery = from cust in nw.Customers select cust; foreach (var item in resultQuery) { list.Add(new Customer { Id = item.Id, Name = item.Name, Age = item.Age, Subscription = item.Subscription }); } return(list); }
public IHttpActionResult Get() { // Validate the Header and return the token string token = ValidateHeader.validate(Request); if (token == null) { return(BadRequest(HttpErrorMessages.InvalidHeader)); } // Validate the Token and return 'BadRequest' or 'Unauthorized' if it's the case int typeOfAuth = 1; HttpStatusCode Status = TokenValidation.validatetoken(token, typeOfAuth); IHttpActionResult response = ResponseMessage(new HttpResponseMessage(Status)); // If the Token is Valid, execute service if (Status == HttpStatusCode.OK) { JWTModel jwtmodel = TokenFactory.getJWTmodelPayload(token); string partnerusername = jwtmodel.username; string userType = jwtmodel.typeofuser; int eventID = jwtmodel.eventid; try { DataClasses3DataContext dbContext = new DataClasses3DataContext(); var partnerid = dbContext.TbPartners.FirstOrDefault(a => a.username == partnerusername); if (jwtmodel.typeofuser == "user" || jwtmodel.typeofuser == "admin") { var sessions = from u in dbContext.TbSessions where u.Event_Id == eventID // Multi-event select u; GateControlModel doorsAndSessions = new GateControlModel(); List <SessionModel> listOfSessions = new List <SessionModel>(); List <Doors> listOfDoors = new List <Doors>(); foreach (var session in sessions) { SessionModel mSession = new SessionModel(); mSession.sessionName = session.NameSession; mSession.sessionId = session.Session_Id; listOfSessions.Add(mSession); } var doors = from u1 in dbContext.RelAccessDoors join u2 in dbContext.TbAccesses on u1.Access_Id_CMS equals u2.AccessIdCms join u3 in dbContext.TbSessions on u2.Session_Id equals u3.Session_Id where u3.Event_Id == eventID // Multi-event select u1; foreach (var door in doors) { Doors doormodel = new Doors(); var matchingvalue = from u in listOfDoors where u.doorId == door.Door_Id select u; if (matchingvalue.Count() < 1) { doormodel.doorId = door.Door_Id ?? default(int); doormodel.doorLabel = door.Door_Name; listOfDoors.Add(doormodel); } } doorsAndSessions.doors = listOfDoors; doorsAndSessions.sessions = listOfSessions; return(Ok(doorsAndSessions)); } return(Unauthorized()); } catch (Exception e) { return(InternalServerError(e)); } } else { return(response); } }
public IHttpActionResult Post(ValidationModel data) { // Validate the Header and return the token string token = ValidateHeader.validate(Request); if (token == null) { return(BadRequest(HttpErrorMessages.InvalidHeader)); } // Validate the Token and return 'BadRequest' or 'Unauthorized' if it's the case int typeOfAuth = 1; HttpStatusCode Status = TokenValidation.validatetoken(token, typeOfAuth); IHttpActionResult response = ResponseMessage(new HttpResponseMessage(Status)); // If the Token is Valid, execute service if (Status == HttpStatusCode.OK) { int eventID = TokenFactory.getEventIdPayload(token); if (data.state != 0 && data.state != 1) { System.ArgumentException argEx = new System.ArgumentException("The state is not valid"); return(InternalServerError(argEx)); } try { DataClasses3DataContext dbContext = new DataClasses3DataContext(); var tag = (from u in dbContext.TbTags // Check if the barcode exists where u.BarCode == data.barcode select u).FirstOrDefault(); AuthUserModel userdata = new AuthUserModel(); if (tag == null) { userdata.status = StatusCodes.TagNotInDatabase; return(Ok(userdata)); } if (tag.Enabled != true) { userdata.status = StatusCodes.TagNotEnabled; return(Ok(userdata)); } // Check if EventID requires Registration var currentEvent = (from u in dbContext.TbEvents where u.EventId == eventID select u).FirstOrDefault(); if (currentEvent != null && currentEvent.RegistrationRequired == true) { // Check if user registered if (tag.TbUser.vipregistered != true) { userdata.status = StatusCodes.UserNotRegistered; return(Ok(userdata)); } } // If it exists, search if that tag is related to the access given var accesses = from u1 in dbContext.RelAccessDoors where u1.Door_Id == data.doorId // REQUIREMENT: DoorID UNIQUE for multi-event situations join u2 in dbContext.TbAccesses on u1.Access_Id_CMS equals u2.AccessIdCms where u2.Session_Id == data.sessionId join u3 in dbContext.RelTagVouchers on u2.AccessId equals u3.AccessId where u3.TagId == tag.TagId select u3; var doorAccesses = from u in dbContext.RelAccessDoors where u.Door_Id == data.doorId select u; if (accesses.Count() > 0 && accesses.Count() >= doorAccesses.Count()) { // Ad-Hoc - Porta 9 (Restaurante Staff Parceiros) if (data.doorId == 22) { var entriesAtThisDoor = from u in dbContext.TbLogs where u.DoorId == 22 && u.SessionId == data.sessionId select u; if (entriesAtThisDoor.Count() >= 70) { userdata.status = StatusCodes.MaxDoorEntrancesReached; return(Ok(userdata)); } } foreach (var acc in accesses) { if (acc.TbAccess.Reentry == true && acc.State == 1 && data.state == 0) {// If the user tries to exit on a non-reentry zone userdata.status = StatusCodes.ExitNonReentryZone; return(Ok(userdata)); } if (acc.TbAccess.Reentry == true && acc.State == 1 && data.state == 1) {// If the user tries to enter on a non-reentry zone userdata.status = StatusCodes.NonReentryZone; return(Ok(userdata)); } if (acc.State == data.state) {// if the user tries to reenter without being granted exit userdata.status = StatusCodes.ReentranceWithoutPreviousExit; return(Ok(userdata)); } acc.State = data.state; // update the state (IN or OUT) acc.TimeStamp = DateTime.Now; if (data.state == 1) { // Update tag.HasEntered = true; } try { dbContext.SubmitChanges(); } catch (Exception e) { return(InternalServerError(e)); } var user = (from u in dbContext.TbTags // Search for the user associated with the tag where u.TagId == tag.TagId select u.TbUser).First(); userdata.userID = user.UserId; var userdatas = from u in dbContext.TbUsersDatas // Search for the data associated with that user where u.UserId == user.UserId select u; var partner = (from u in dbContext.TbPartners // Search for the partner associated with that user where u.PartnerId == user.PartnerId select u).First(); var profile = (from u in dbContext.TbProfiles where u.ProfileId == user.ProfileId // Search for the profile associated with that user select u).First(); userdata.profileLabel = partner.PartnerLabel; if (profile.Staff == true) // Checks if user is staff or vip { userdata.type = 1; } else { userdata.type = 0; } userdata.partnerLabel = partner.PartnerLabel; foreach (var udata in userdatas) // Fills the json with user info { if (udata.DataName == "Foto") { if (!string.IsNullOrEmpty(udata.Value)) { string output = udata.Value.Substring(udata.Value.IndexOf(',') + 1); userdata.photo = output; } } if (udata.DataName == "Nome") { string mName = udata.Value; userdata.name = mName.Count() > 22 ? mName.Substring(0, 22) + "..." : mName; } userdata.status = StatusCodes.Success; } } // Log Types // 1 - Entrance; 2 - Exit int logType = data.state == 1 ? (int)Enums.LogTypes.Entrance : (int)Enums.LogTypes.Exist; dbContext.InsertLogEntry(eventID, userdata.userID, data.doorId, data.sessionId, logType); return(Ok(userdata)); } else { userdata.status = StatusCodes.NotAllowed; return(Ok(userdata)); } } catch (Exception) { AuthUserModel userdata = new AuthUserModel(); userdata.status = StatusCodes.GenericError; return(Ok(userdata)); } } else { return(response); } }
public IHttpActionResult Get() { // Validate the Header and return the token string token = ValidateHeader.validate(Request); if (token == null) { return(BadRequest(HttpErrorMessages.InvalidHeader)); } // Validate the Token and return 'BadRequest' or 'Unauthorized' if it's the case int typeOfAuth = 1; HttpStatusCode Status = TokenValidation.validatetoken(token, typeOfAuth); IHttpActionResult response = ResponseMessage(new HttpResponseMessage(Status)); // If the Token is Valid, execute service if (Status == HttpStatusCode.OK) { int eventID = TokenFactory.getEventIdPayload(token); try { DataClasses3DataContext dbContext = new DataClasses3DataContext(); var partnersQuery = from u in dbContext.TbPartners // Search all partners in the database, with criteria join u2 in dbContext.TbPartnerDatas on u.PartnerId equals u2.PartnerId join u3 in dbContext.TbTexts on u2.TextCode equals u3.TextCode where u.IsStaff == true && u.EventId == eventID // Multi-event orderby u.PartnerLabel ascending select new { partnerId = u.PartnerId, partnerIdLabel = u.PartnerLabel, sentEmail = u.SentMail, isAdmin = u.IsAdmin, fieldname = u3.TextLabel, value = u2.Value, type = u2.Type, order = u2.Order, mandatory = u2.Mandatory, textCode = u2.TextCode }; Dictionary <int, Partner> partnersDict = new Dictionary <int, Partner>(); foreach (var partnerQuery in partnersQuery) { if (partnerQuery.isAdmin == true) { continue; } if (!partnersDict.ContainsKey(partnerQuery.partnerId)) { Partner partner = new Partner(); partner.partnerId = partnerQuery.partnerId; partner.partnerLabel = partnerQuery.partnerIdLabel; partner.sentmail = partnerQuery.sentEmail ?? default(bool); partner.list = new List <PartnerModel>(); partnersDict.Add(partnerQuery.partnerId, partner); } PartnerModel data = new PartnerModel(); data.fieldname = partnerQuery.fieldname; data.value = partnerQuery.value; data.type = partnerQuery.type; data.order = partnerQuery.order; data.id = partnerQuery.partnerId; data.mandatory = partnerQuery.mandatory; data.fieldcode = partnerQuery.textCode; partnersDict[partnerQuery.partnerId].list.Add(data); } Partners partnerslist = new Partners(); partnerslist.partners = partnersDict.Select(d => d.Value).ToList(); return(Ok(partnerslist)); } catch (Exception e) { return(InternalServerError(e)); } } else { return(response); } }
private void DodajBotun_Click(object sender, EventArgs e) { k.sprava = textBox1.Text; k.kolicina = decimal.ToInt32(numericUpDown1.Value); //za vadenje podataka iz baze -> LINQ DataClasses3DataContext db3 = new DataClasses3DataContext(); var varijabla = from s in db3.tblInvertars select s.sprava; string[] name = varijabla.ToArray(); var varijabla2 = from s in db3.tblInvertars select s.kolicina; int[] broj = varijabla2.ToArray(); string korisnikov_unos = textBox1.Text; int korisnikova_kolicina = Convert.ToInt32(numericUpDown1.Value); bool temp = false; if (korisnikova_kolicina > 0) { for (int j = 0; j < name.Count(); j++) { if (korisnikov_unos == name[j]) { var result = MessageBox.Show("Jeste li sigurni da želite obrisati opremu?", "Obavijest", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { k.kolicina = broj[j] + korisnikova_kolicina; bool success1 = i.Update(k); if (success1) { MessageBox.Show("Uređena oprema.", "Obavijest"); temp = false; loadFormAgain(); break; } } else { loadFormAgain(); } } else { temp = true; } } if (temp) { var result = MessageBox.Show("Jeste li sigurni da želite dodati novu opremu?", "Obavijest", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { bool success = i.Insert(k); if (success) { MessageBox.Show("Uspješno dodana nova oprema.", "Obavijest"); loadFormAgain(); } else { MessageBox.Show("Nešto je poslo po krivu", "Upozorenje"); } } else { loadFormAgain(); } } } else { MessageBox.Show("Količina ne može biti jednaka 0", "Obavijest"); loadFormAgain(); } }
private void BrisiBotun_Click(object sender, EventArgs e) { k.sprava = textBox1.Text; k.kolicina = Convert.ToInt32(numericUpDown1.Value); //za vadenje podataka iz baze -> LINQ DataClasses3DataContext db3 = new DataClasses3DataContext(); var varijabla = from s in db3.tblInvertars select s.sprava; string[] name = varijabla.ToArray(); var varijabla2 = from s in db3.tblInvertars select s.kolicina; int[] broj = varijabla2.ToArray(); string korisnikov_unos = textBox1.Text; int korisnikova_kolicina = Convert.ToInt32(numericUpDown1.Value); bool temp = true; for (int j = 0; j < name.Count(); j++) { if (korisnikov_unos == name[j]) { if (korisnikova_kolicina > broj[j]) { MessageBox.Show("Unijeli ste količinski iznos veći nego što je u bazi!", "Upozorenje"); temp = false; break; } else if (korisnikova_kolicina == broj[j]) { var result = MessageBox.Show("Jeste li sigurni da želite obrisati opremu?", "Obavijest", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { bool success = i.Delete(k); if (success) { MessageBox.Show("Uređena oprema.", "Obavijest"); temp = false; loadFormAgain(); } else { MessageBox.Show("Pogreška pri uređivanju opreme.", "Upozorenje"); } } else { temp = false; break; } } else { var result = MessageBox.Show("Jeste li sigurni da želite obrisati opremu?", "Obavijest", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { k.kolicina = broj[j] - korisnikova_kolicina; bool success2 = i.Update(k); if (success2) { MessageBox.Show("Uređena oprema.", "Obavijest"); temp = false; loadFormAgain(); break; } } else { temp = false; break; } } } } if (temp) { var result = MessageBox.Show("Jeste li sigurni da želite obrisati opremu?", "Obavijest", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { bool success = i.Delete(k); if (success) { MessageBox.Show("Oprema uspjesno izbrisana.", "Obavijest"); loadFormAgain(); } else { MessageBox.Show("Pogreska pri brisanju opreme.", "Upozorenje"); } } } }
public IHttpActionResult Get(int partnerID, int profileID) { // Validate the Header and return the token string token = ValidateHeader.validate(Request); if (token == null) { return(BadRequest(HttpErrorMessages.InvalidHeader)); } // Validate the Token and return 'BadRequest' or 'Unauthorized' if it's the case int typeOfAuth = 1; HttpStatusCode Status = TokenValidation.validatetoken(token, typeOfAuth); IHttpActionResult response = ResponseMessage(new HttpResponseMessage(Status)); // If the Token is Valid, execute service if (Status == HttpStatusCode.OK) { int eventID = TokenFactory.getEventIdPayload(token); try { DataClasses3DataContext dbContext = new DataClasses3DataContext(); var eventTagUniverse = from u1 in dbContext.TbTags join u2 in dbContext.TbUsers on u1.UserId equals u2.UserId join u3 in dbContext.TbPartners on u2.PartnerId equals u3.PartnerId where u3.EventId == eventID && u3.IsStaff == true // Staff only select new { EventTag = u1.TagId, EventTagStatus = u1.Enabled, PartnerID = u2.PartnerId, ProfileID = u2.ProfileId }; int nrTagsPerEvent = eventTagUniverse.Count(); int nrAccreditatedTagsPerEvent = -1; int nrUnAccreditatedTagsPerEvent = -1; if (partnerID == -1 && profileID == -1) // Without filters { var accreditations = from u in eventTagUniverse where u.EventTagStatus == true select new { EventAccreditatedTag = u.EventTag }; nrAccreditatedTagsPerEvent = accreditations.Count(); var nonAccreditations = from u in eventTagUniverse where u.EventTagStatus == null || u.EventTagStatus == false select new { EventAccreditatedTag = u.EventTag }; nrUnAccreditatedTagsPerEvent = nonAccreditations.Count(); } else { if (partnerID > -1 && profileID == -1) // Filtered for partnerID { var accreditations = from u in eventTagUniverse where u.EventTagStatus == true && u.PartnerID == partnerID select new { EventAccreditatedTag = u.EventTag }; nrAccreditatedTagsPerEvent = accreditations.Count(); var nonAccreditations = from u in eventTagUniverse where (u.EventTagStatus == null || u.EventTagStatus == false) && u.PartnerID == partnerID select new { EventAccreditatedTag = u.EventTag }; nrUnAccreditatedTagsPerEvent = nonAccreditations.Count(); } else { if (partnerID == -1 && profileID > -1) // Filtered for profileID { var accreditations = from u in eventTagUniverse where u.EventTagStatus == true && u.ProfileID == profileID select new { EventAccreditatedTag = u.EventTag }; nrAccreditatedTagsPerEvent = accreditations.Count(); var nonAccreditations = from u in eventTagUniverse where (u.EventTagStatus == null || u.EventTagStatus == false) && u.ProfileID == profileID select new { EventAccreditatedTag = u.EventTag }; nrUnAccreditatedTagsPerEvent = nonAccreditations.Count(); } else // Filtered for partnerID and profileID { var accreditations = from u in eventTagUniverse where u.EventTagStatus == true && u.PartnerID == partnerID && u.ProfileID == profileID select new { EventAccreditatedTag = u.EventTag }; nrAccreditatedTagsPerEvent = accreditations.Count(); var nonAccreditations = from u in eventTagUniverse where (u.EventTagStatus == null || u.EventTagStatus == false) && u.PartnerID == partnerID && u.ProfileID == profileID select new { EventAccreditatedTag = u.EventTag }; nrUnAccreditatedTagsPerEvent = nonAccreditations.Count(); } } } if (nrAccreditatedTagsPerEvent == 0 && nrUnAccreditatedTagsPerEvent == 0) { StatusModel statusModel = new StatusModel(); statusModel.status = StatusCodes.EmptyDataSet; return(Ok(statusModel)); } ReportModel newReport = new ReportModel(); newReport.reportTitle = "Acreditações"; newReport.Xlabel = "Subconjuntos"; newReport.Ylabel = "Número de acreditações"; List <ReportData> newReportData = new List <ReportData>(); ReportData reportData1 = new ReportData(); reportData1.Xdata = "Com acreditação"; reportData1.Ydata = nrAccreditatedTagsPerEvent; newReportData.Add(reportData1); ReportData reportData2 = new ReportData(); reportData2.Xdata = "Sem acreditação"; reportData2.Ydata = nrUnAccreditatedTagsPerEvent; newReportData.Add(reportData2); newReport.reportData = newReportData; return(Ok(newReport)); } catch (Exception e) { return(InternalServerError(e)); } } else { return(response); } }
private void kampusGymHome_Load(object sender, EventArgs e) { // SVE ZA RASPORED pictureBox string[] sva_polja = { "a1b1", "a1b2", "a1b3", "a1b4", "a1b5", "a1b6", "a2b1", "a2b2", "a2b3", "a2b4", "a2b5", "a2b6", "a3b1", "a3b2", "a3b3", "a3b4", "a3b5", "a3b6", "a4b1", "a4b2", "a4b3", "a4b4", "a4b5", "a4b6", "a5b1", "a5b2", "a5b3", "a5b4", "a5b5", "a5b6", "a6b1", "a6b2", "a6b3", "a6b4", "a6b5", "a6b6", "a7b1", "a7b2", "a7b3", "a7b4", "a7b5", "a7b6", "a8b1", "a8b2", "a8b3", "a8b4", "a8b5", "a8b6", "a9b1", "a9b2", "a9b3", "a9b4", "a9b5", "a9b6", "a10b1", "a10b2", "a10b3", "a10b4", "a10b5", "a10b6", "a11b1", "a11b2", "a11b3", "a11b4", "a11b5", "a11b6", "a12b1", "a12b2", "a12b3", "a12b4", "a12b5", "a12b6", "a13b1", "a13b2", "a13b3", "a13b4", "a13b5", "a13b6" }; int j = 0; int k = 0; int counter = 0; int index = 0; DataClasses1DataContext db1 = new DataClasses1DataContext(); var varijabla1 = from s in db1.tblRasporeds select s.botunIme; string[] ime_botuna = varijabla1.ToArray(); var varijabla2 = from s in db1.tblRasporeds select s.botunText; string[] text_botuna = varijabla2.ToArray(); // za rasoired for (j = 0; j < sva_polja.Length; j++) { for (k = 0; k < text_botuna.Length; k++) { if (sva_polja[j] == ime_botuna[k]) { counter++; index = k; } } if (counter > 0 && (text_botuna[index] == "Privatni trening" || text_botuna[index] == "Kickbox" || text_botuna[index] == "Kružni trening")) { trening_raspored++; } counter = 0; index = 0; } panel2.Height = buttonNaslovna.Height; panel2.Top = buttonNaslovna.Top; panel1.BackColor = ColorTranslator.FromHtml("#222831"); //Button button = (Button)sender; buttonNaslovna.BackColor = Color.FromArgb(0, 129, 138); buttonClanstvo.BackColor = ColorTranslator.FromHtml("#222831"); buttonInformacije.BackColor = ColorTranslator.FromHtml("#222831"); buttonZaposlenici.BackColor = ColorTranslator.FromHtml("#222831"); buttonRaspored.BackColor = ColorTranslator.FromHtml("#222831"); buttonInventar.BackColor = ColorTranslator.FromHtml("#222831"); //za vadenje podataka iz baze clanove-> LINQ DataClasses3DataContext db3 = new DataClasses3DataContext(); var pomocna3 = from s in db3.tblMembers select s.spol; string[] spol = pomocna3.ToArray(); var temp3 = from s in db3.tblMembers select s.vrsta_treninga; string[] text = temp3.ToArray(); var varijabla3 = from s in db3.tblMembers select s.id; int[] broj = varijabla3.ToArray(); int[] temp_niz = { 0, 0, 0 }; int[] spol_niz = { 0, 0 }; //sprema u public varijablu broj clanova clanovi = broj.Length; label1.Text = clanovi + " članova"; //za vadenje podataka iz baze clanove-> LINQ DataClasses4DataContext db4 = new DataClasses4DataContext(); //sprema u public varijablu broj zaposlenika var varijabla4 = from s in db4.tblZaposlenicis select s.id_zaposlenika; int[] number = varijabla4.ToArray(); zaposlenici = number.Length; label2.Text = zaposlenici + " zaposlenika"; //za raspored picturebox label3.Text = trening_raspored + " treninga"; // za graf for (int i = 0; i < text.Length; i++) // vadimo vrste treniga za chart2 { if (text[i] == "Teretana") { temp_niz[0]++; } else if (text[i] == "Kickbox") { temp_niz[1]++; } else if (text[i] == "Kružni trening") { temp_niz[2]++; } else { continue; } } for (int i = 0; i < text.Length; i++) // vadimo vrste ljudi za chart1 { if (spol[i] == "Muški") { spol_niz[0]++; } else if (spol[i] == "Ženski") { spol_niz[1]++; } else { continue; } } chart1.Series["s1"].IsValueShownAsLabel = true; chart1.Series["s1"].Points.AddXY("1", spol_niz[0]); //ovo ce bit muski chart1.Series["s1"].Points.AddXY("2", spol_niz[1]); // ovo zenski chart1.Series["s1"].Points[0].LegendText = "Muškarci"; chart1.Series["s1"].Points[1].LegendText = "Žene"; chart2.Series["s2"].IsValueShownAsLabel = true; chart2.Series["s2"].Points.AddXY("1", temp_niz[0]); //teretana chart2.Series["s2"].Points.AddXY("2", temp_niz[1]); // kickbox chart2.Series["s2"].Points.AddXY("3", temp_niz[2]); //kruzni trening chart2.Series["s2"].Points[0].LegendText = "Teretana"; chart2.Series["s2"].Points[1].LegendText = "Kickbox"; chart2.Series["s2"].Points[2].LegendText = "Kružni trening"; #region Kartezijev graf /* AKO SE ODLUCIMO ZA KARTEZIJEV * cartesianChart1.Series = new LiveCharts.SeriesCollection * { * new LineSeries * { * Values=new ChartValues<ObservablePoint> * { * new ObservablePoint(1,1), * new ObservablePoint(2,2), * new ObservablePoint(3,1), * new ObservablePoint(5,3), * new ObservablePoint(8,6), * new ObservablePoint(10,2), * }, * PointGeometrySize=15 * }, * new LineSeries * { * Values=new ChartValues<ObservablePoint> * { * new ObservablePoint(1,1), * new ObservablePoint(2,2), * new ObservablePoint(3,3), * new ObservablePoint(4,4), * new ObservablePoint(5,5), * new ObservablePoint(6,6), * }, * PointGeometrySize=15 * }, * new LineSeries * { * Values=new ChartValues<ObservablePoint> * { * new ObservablePoint(2,10), * new ObservablePoint(6,8), * new ObservablePoint(3,5), * new ObservablePoint(1,3), * new ObservablePoint(5,5), * new ObservablePoint(4,2), * }, * PointGeometrySize=15 * } * * };*/ #endregion }
public IHttpActionResult Get() { // Validate the Header and return the token string token = ValidateHeader.validate(Request); if (token == null) { return(BadRequest(HttpErrorMessages.InvalidHeader)); } // Validate the Token and return 'BadRequest' or 'Unauthorized' if it's the case int typeOfAuth = 1; HttpStatusCode Status = TokenValidation.validatetoken(token, typeOfAuth); IHttpActionResult response = ResponseMessage(new HttpResponseMessage(Status)); // If the Token is Valid, execute service if (Status == HttpStatusCode.OK) { int eventID = TokenFactory.getEventIdPayload(token); try { DataClasses3DataContext dbContext = new DataClasses3DataContext(); var eventPartners = from u in dbContext.TbPartners where u.EventId == eventID && u.IsStaff == true // Staff only orderby u.PartnerLabel ascending select new { PartnerID = u.PartnerId, PartnerLabel = u.PartnerLabel }; var eventProfiles = from u in dbContext.TbProfiles where u.EventId == eventID && u.Staff == true // Staff only orderby u.ProfileLabel ascending select new { ProfileID = u.ProfileId, ProfileLabel = u.ProfileLabel }; ReportingFilterLists reportingFilterLists = new ReportingFilterLists(); List <PartnerReportModel> partnerList = new List <PartnerReportModel>(); // Default entry PartnerReportModel partnerReportModelDefault = new PartnerReportModel(); partnerReportModelDefault.partnerID = -1; partnerReportModelDefault.partnerLabel = "todos"; partnerList.Add(partnerReportModelDefault); foreach (var item1 in eventPartners) { PartnerReportModel partnerReportModel = new PartnerReportModel(); partnerReportModel.partnerID = item1.PartnerID; partnerReportModel.partnerLabel = item1.PartnerLabel; partnerList.Add(partnerReportModel); } List <ProfileReportModel> profileList = new List <ProfileReportModel>(); // Default entry ProfileReportModel profileReportModelDefault = new ProfileReportModel(); profileReportModelDefault.profileID = -1; profileReportModelDefault.profileLabel = "todos"; profileList.Add(profileReportModelDefault); foreach (var item2 in eventProfiles) { ProfileReportModel profileReportModel = new ProfileReportModel(); profileReportModel.profileID = item2.ProfileID; profileReportModel.profileLabel = item2.ProfileLabel; profileList.Add(profileReportModel); } reportingFilterLists.partnerList = partnerList; reportingFilterLists.profileList = profileList; return(Ok(reportingFilterLists)); } catch (Exception e) { return(InternalServerError(e)); } } else { return(response); } }