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