public static Project ToProject(this ProjectInfoView sender)
{
var newProject = new Project()
{
Caption = sender.Caption,
ContactID = sender.ContactID,
CrtDate = sender.CrtDate,
ID = sender.ID,
IsInWork = sender.IsInWork,
Note = sender.Note,
Priority = sender.Priority,
Progress = sender.Progress,
ResponsiblePerson = sender.ResponsiblePerson,
RowState = sender.RowState,
Type = sender.Type
};
using (var dc = new ORM.FPMDataContext())
{
if (dc.Contact.Any(x => x.ID == sender.ContactID))
{
newProject.Contact = dc.Contact.Single(x => x.ID == sender.ContactID);
}
;
};
return(newProject);
}
private static void loadValues()
{
if (_values == null)
{
using (var dc = new ORM.FPMDataContext())
{
_values = dc.ParameterValue.ToList();
};
}
;
}
private static void loadParameters()
{
if (_parameters == null)
{
using (var dc = new ORM.FPMDataContext())
{
_parameters = dc.Parameter.ToList();
};
}
;
}
private void initDataSource()
{
_ds = new LinqInstantFeedbackDataSource();
var dc = new ORM.FPMDataContext();
dc.ObjectTrackingEnabled = false;
_ds.QueryableSource = dc.ProjectPivotView.Where(x => x.DeadLine >= DateFrom && x.DeadLine <= DateTo.AddDays(1).AddMinutes(-1));
_ds.KeyExpression = "ProjectID";
_ds.DefaultSorting = "DeadLine DESC";
OnPropertyChanged("DataSource");
}
public static bool CheckConnection(string connectionString, out string Message)
{
bool result = false;
try
{
using (var dc = new ORM.FPMDataContext(connectionString))
{
if (dc.Parameter.Any())
{
result = true;
}
;
};
Message = String.Empty;
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
