public int VenueLogin(string userName, string password)
{
int venueKey = 0;
int result = db.usp_venueLogin(userName, password);
if (result != -1)
{
var key = (from vl in db.VenueLogins
where vl.VenueLoginUserName.Equals(userName)
select new { vl.VenueKey }).FirstOrDefault();
venueKey = (int)key.VenueKey;
}
return(venueKey);
}
public int LoginVenue(string VenueLoginUserName, string VenueLoginPasswordPlain)
{
int VenueKey = 0;
int result = db.usp_venueLogin(VenueLoginUserName, VenueLoginPasswordPlain);
if (result != -1)
{
var key = (from v in db.VenueLogins
where v.VenueLoginUserName.Equals(VenueLoginUserName)
select new { v.VenueKey }).FirstOrDefault();// returns the first one , because key is not seen as a single value
// the key contains "Reviewer = key", so that's why we need the key.ReviewerKey
VenueKey = (int)key.VenueKey;
}
return(VenueKey);
}
public int VenueLogin(string password, string username)
{
int result = db.usp_venueLogin(username, password);
if (result != -1)
{
var key = from k in db.VenueLogins
where k.VenueLoginUserName.Equals(username)
select new { k.VenueLoginKey };
foreach (var k in key)
{
result = (int)k.VenueLoginKey;
}
}
return(result);
}
//Venue Login start here
public int venueLogin(string username, string password)
{
int result = pj.usp_venueLogin(username, password);
if (result != -1)
{
var key = from vl in pj.Venues
where vl.VenueName.Equals(username)
select new { vl.VenueKey };
foreach (var vl in key)
{
result = (int)vl.VenueKey;
}
}
return(result);
}
public int VenueLogin(string username, string password)
{
int key = 0;
int pass = ste.usp_venueLogin(username, password);
if (pass != -1)
{
var ven = from v in ste.VenueLogins
where v.VenueLoginUserName.Equals(username)
select new { v.VenueKey };
foreach (var v in ven)
{
key = (int)v.VenueKey;
}
}
return(key);
}
public int LoginVenue(string userName, string password)
//Returns venueKey
{
int reviewerKey = -1;
//Returns int which represents the successfulness of the login.
// -1 means it failed.
int loginSuccess = db.usp_venueLogin(userName, password);
if (loginSuccess != -1)
{
var venueInfo = (from vl in db.VenueLogins
where vl.VenueLoginUserName.Equals(userName)
select new { vl.VenueKey }).FirstOrDefault();
reviewerKey = (int)venueInfo.VenueKey;
}
return(reviewerKey);
}
