public NewProjectWin(Project prj)
{
NewProject = new Project(prj);
isUpdateble = true;
InitializeComponent();
init();
}
private void delUser_Click(object sender, System.Windows.RoutedEventArgs e)
{
if (PrjCatalog.SelectedItem != null)
{
int index = PrjCatalog.SelectedIndex;
Project prj = (Project)PrjCatalog.SelectedItem;
prj.DeleteProject();
projects[index] = new Project(prj){IsDelete = true};
}
}
public Project(Project prj)
{
GUID = prj.GUID;
Description = prj.Description;
DateStart = prj.DateStart;
DateEnd = prj.DateEnd;
DateCreate = prj.DateCreate;
Customer = new User(prj.Customer);
Leader = new User(prj.Leader);
Percents = prj.Percents;
if(prj.Parent!=null)
{
Parent = new Project(prj.Parent);
}
Type = prj.Type;
IsDelete = prj.IsDelete;
}
public static void AddNewProject(Project prj)
{
ExecuteNonQuery(
string.Format(
"insert into Projects values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}')",
prj.GUID,
prj.Description,
DateTimeToSQLiteFormat(prj.DateStart),
DateTimeToSQLiteFormat(prj.DateEnd),
DateTimeToSQLiteFormat(prj.DateCreate),
prj.Customer.GUID,
prj.Leader.GUID,
prj.Percents,
prj.Parent == null ? "" : prj.Parent.GUID,
prj.Type,
"...", "...", "...", prj.IsDelete),
null, true);
}
public Task(Task task)
{
GUID = task.GUID;
OrderDate = task.OrderDate;
EndDate = task.EndDate;
Performer = new User(task.Performer);
Customer = new User(task.Customer);
Topic = task.Topic;
Description = task.Description;
Priority = task.Priority;
Project = new Project(task.Project);
TimePlan = task.TimePlan;
TimeAdjustment = task.TimeAdjustment;
TimeFact = task.TimeFact;
Percents = task.Percents;
IsImportant = task.IsImportant;
IsNew = task.IsNew;
IsDelete = task.IsDelete;
}
public NewProjectWin()
{
NewProject = new Project();
InitializeComponent();
init();
}
public static void UpdateProject(Project prj)
{
ExecuteNonQuery(
string.Format(
"update Projects set Description='{0}',DateStart='{1}',DateEnd='{2}',DateCreate='{3}',Customer='{4}',Leader='{5}',Percents='{6}',Parent='{7}',IsDelete='{8}' where GUID=@GUID",
prj.Description,
DateTimeToSQLiteFormat(prj.DateStart),
DateTimeToSQLiteFormat(prj.DateEnd),
DateTimeToSQLiteFormat(prj.DateCreate),
prj.Customer.GUID,
prj.Leader.GUID,
prj.Percents,
prj.Parent,
prj.IsDelete ? 1:0),
new List<SQLiteParameter>
{
new SQLiteParameter("GUID", prj.GUID)
},
true);
}
public static Project GetParentProjectFromGUID(string guid, bool all = false)
{
SQLiteConnection connection = new SQLiteConnection(ConnectionString);
Project parent = new Project(false);
try
{
connection.Open();
string command = string.Concat("select * from Projects where GUID=@GUID", all ? "" : " and (IsDelete='False' or IsDelete='0')");
SQLiteCommand cmd = new SQLiteCommand(command, connection);
cmd.Parameters.Add(new SQLiteParameter("GUID", guid));
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//string parentGUID = reader.GetString(reader.GetOrdinal("Parent"));
object o = reader["IsDelete"];
parent = new Project(false)
{
GUID = reader.GetString(reader.GetOrdinal("GUID")),
Description = reader.GetString(reader.GetOrdinal("Description")),
DateStart = reader.GetDateTime(reader.GetOrdinal("DateStart")),
DateEnd = reader.GetDateTime(reader.GetOrdinal("DateEnd")),
DateCreate = reader.GetDateTime(reader.GetOrdinal("DateCreate")),
Customer = GetUserFromGUID(reader.GetString(reader.GetOrdinal("Customer"))),
Leader = GetUserFromGUID(reader.GetString(reader.GetOrdinal("Leader"))),
Percents = reader.GetDouble(reader.GetOrdinal("Percents")),
Parent = null,/*string.IsNullOrWhiteSpace(parentGUID) ? null : GetParentProjectFromGUID(parentGUID)*/
Type = reader.GetInt32(reader.GetOrdinal("Type")),
IsDelete = Convert.ToBoolean(o)
};
}
}
catch (Exception exc)
{
MessageWindows.Show("GetParentProjectFromGUID:Exception", exc.Message);
return parent;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return parent;
}
public static void AddProject(Project prj)
{
SQLiteWorker.AddNewProject(prj);
}
