public void SetNewID()
{
using (var db = new MyFileItEntities())
{
var ev = db.TEAMEVENTPLAYERROSTERs.OrderByDescending(o => o.ID).FirstOrDefault();
this.ID = ev == null ? 1 : ev.ID + 1;
}
}
public void SetNewID()
{
using (var db = new MyFileItEntities())
{
var ev = db.APPUSERs.OrderByDescending(o => o.ID).FirstOrDefault();
this.ID = ev == null ? 1 : ev.ID + 1;
this.DATECREATED = DateTime.Now;
}
}
public static bool ValidCoachName(string firstName, string lastName)
{
var result = true;
using (var db = new MyFileItEntities())
{
result = !db.COACHes.Any(sr => sr.FIRSTNAME.Equals(firstName, StringComparison.CurrentCultureIgnoreCase) || sr.LASTNAME.Equals(lastName, StringComparison.CurrentCultureIgnoreCase));
}
return(result);
}
public static bool ValidTeamEventDocumentName(string documentName)
{
var result = true;
using (var db = new MyFileItEntities())
{
result = !db.TEAMEVENTDOCUMENTs.Any(d => d.DOCUMENTNAME.Equals(documentName, StringComparison.CurrentCultureIgnoreCase));
}
return(true);
}
public int GetNewAppUserOrganizationID()
{
int result = -1;
using (var db = new MyFileItEntities())
{
var ev = db.APPUSERORGANIZATIONs.OrderByDescending(o => o.ID).FirstOrDefault();
result = ev == null ? 1 : ev.ID + 1;
}
return(result);
}
public static bool ValidUserName(string userName)
{
var result = true;
using (var db = new MyFileItEntities())
{
result = !db.APPUSERs.Any(u => u.USERNAME.ToLower() == userName.ToLower());
}
return(true);
}
public static bool ValidSalesRepName(string emailAddress)
{
var result = true;
using (var db = new MyFileItEntities())
{
result = !db.SALESREPs.Any(sr => sr.EMAILADDRESS.ToLower() == emailAddress);
//result = !db.SALESREPs.Any(sr => sr.FIRSTNAME.Equals(firstName, StringComparison.CurrentCultureIgnoreCase) && sr.LASTNAME.Equals(lastName, StringComparison.CurrentCultureIgnoreCase));
}
return(result);
}
public static bool ValidTeamEventPlayerRoster(int teamEventId, int appUserId, ref string error)
{
var result = true;
using (var db = new MyFileItEntities())
{
result = !db.TEAMEVENTPLAYERROSTERs.Any(r => r.APPUSERID == appUserId && r.TEAMEVENTID == teamEventId);
if (!result)
{
error = "Player is already on the roster.";
}
}
return(result);
}
public SHAREDOCUMENT(int appUserId, int fileCabinetDocumentId, int?teamEventDocumentId, string comment, bool emergency, string emergencyEmailAddress, ref string errorMessage)
{
using (var db = new MyFileItEntities())
{
var teamEventDocument = teamEventDocumentId != null?db.TEAMEVENTDOCUMENTs.SingleOrDefault(td => td.ID == teamEventDocumentId) : null;
var fileCabinetDocument = db.FILECABINETDOCUMENTs.SingleOrDefault(d => d.ID == fileCabinetDocumentId);
//var organization = db.ORGANIZATIONs.SingleOrDefault(o => o.ID == organizationId);
if ((teamEventDocument == null && !emergency) || fileCabinetDocument == null)
{
if (teamEventDocument == null)
{
errorMessage += "Team event document not found.";
}
if (fileCabinetDocument == null)
{
errorMessage += "Document not found.";
}
//if (organization == null)
//{
// errorMessage += "Organization not found.";
//}
}
else
{
SetNewID();
FILECABINETDOCUMENTID = fileCabinetDocumentId;
TEAMEVENTDOCUMENTID = teamEventDocumentId;
DOCUMENTID = fileCabinetDocument.DOCUMENTID;
APPUSERID = appUserId;
SCANDATE = fileCabinetDocument.SCANDATE;
COMMENT = comment;
LOCATION = "";//TODO: not sure about this field
DOCUMENTTYPEID = fileCabinetDocument.DOCUMENTTYPEID;
DOCUMENTSTATUSID = fileCabinetDocument.DOCUMENTSTATUSID;
EMERGENCY = emergency.ConvertToFirebirdString();
EMERGENCYEMAILADDRESS = emergencyEmailAddress;
CABINETID = fileCabinetDocument.CABINETID;//organization.CABINETID;
DOCUMENTDATE = fileCabinetDocument.DOCUMENTDATE;
DATECREATED = DateTime.Now;
VIEWDOCUMENTKEY = Guid.NewGuid().ToString();
ISACTIVE = true.ConvertToFirebirdString();
}
}
}
