public string getProjectDirectoryString()
{
if (DatabaseHandler.isNull(project_directory))
{
return("");
}
return("Project Directory:\n\n" + "<" + project_directory + ">");
}
public string getEmailHeader()
{
if (DatabaseHandler.isNull(project_number))
{
return("");
}
return("[" + this.project_number + "] - ");
}
public override string SetProperty(CookDBDataContext db, string prop, string value)
{
string msg = "";
bool add = true;
if (prop.Equals("hours"))
{
decimal h = Decimal.Parse(value);
if (!h.Equals(this.hours))
{
msg += this.hours + " -> " + h;
this.hours = h;
}
}
else if (prop.Equals("contact_id"))
{
if (!DatabaseHandler.isNull(value))
{
int cid = int.Parse(value);
if (cid != this.contact_id)
{
msg += (this.Contact != null ? this.Contact.contact_name : "") + " -> "
+ Contact.getContactName(db, cid);
this.contact_id = cid;
}
}
}
else if (prop.Equals("hour_type"))
{
int ht = int.Parse(value);
if (ht != this.hour_type)
{
msg += (this.AssessmentHourType != null ? this.AssessmentHourType.assessment_hour_type : "") + " -> "
+ db.AssessmentHourTypes.Single(a => a.assessment_hour_type_id == ht).assessment_hour_type;
this.hour_type = ht;
}
}
else
{
//description
add = false;
msg = base.SetProperty(db, prop, value);
}
if (add && msg.Length > 0)
{
msg = prop + ": " + msg + "\n";
}
return(msg);
}
public override string SetProperty(CookDBDataContext db, string prop, string value)
{
if (prop.Equals("primary"))
{
if (!DatabaseHandler.isNull(value))
{
bool p = bool.Parse(value);
if (this.primary != p)
{
string msg = prop + ": " + this.primary + " -> " + p + "\n";
this.primary = p;
return(msg);
}
}
return("");
}
return(base.SetProperty(db, prop, value));
}
public override string SetProperty(CookDBDataContext db, string prop, string value)
{
string msg = prop + ": ";
if (prop.Equals("contact_id"))
{
if (!DatabaseHandler.isNull(value))
{
int cid = int.Parse(value);
if (cid != this.contact_id)
{
msg += (this.Contact != null ? this.Contact.contact_name : "") + " -> "
+ Contact.getContactName(db, cid);
this.contact_id = cid;
}
}
}
return(msg);
}
public static IQueryable <ProjectContact> getContactsFromRequest(CookDBDataContext db, HttpRequest req)
{
IQueryable <ProjectContact> q = db.ProjectContacts;
if (!DatabaseHandler.isNull(req.Params.Get("project_id")))
{
q = q.Where(a => a.project_id == int.Parse(req.Params.Get("project_id")));
}
if (!DatabaseHandler.isNull(req.Params.Get("contact_id")))
{
q = q.Where(a => a.contact_id == int.Parse(req.Params.Get("contact_id")));
}
if (!DatabaseHandler.isNull(req.Params.Get("contact_type")))
{
q = q.Where(a => a.contact_type == int.Parse(req.Params.Get("contact_type")));
}
return(q);
}
public static bool isNull(string str)
{
return(DatabaseHandler.isNull(str));
}