static public bool DeleteProject(DdProjectExt item, RevisionInfo revisionInfo)
{
DaProject da = new DaProject(DataStore.DbConnection);
bool ok = da.DeleteById(item.Id);
if (ok) AddChangeLog(da.TableName, item.Id, item.Timestamp, revisionInfo); //delete
return ok;
}
static public bool AddProject(ref DdProjectExt item, RevisionInfo revisionInfo)
{
DaProject da = new DaProject(DataStore.DbConnection);
da.Clear();
da.ClientREF = item.ClientREF;
da.Description = item.Description;
da.Modified = item.Modified;
da.ModifiedBy = item.ModifiedBy;
da.ProjectID = item.ProjectID;
da.TaskHeadingREF = item.TaskHeadingREF;
da.Title = item.Title;
bool ok = da.Insert();
if (ok) AddChangeLog(da.TableName, da.Id, da.Timestamp, revisionInfo); //add
if (ok) item = new DdProjectExt(da.GetBuffer());
return ok;
}
static public bool SaveProject(ref DdProjectExt item, RevisionInfo revisionInfo)
{
DaProject da = new DaProject(DataStore.DbConnection);
if (!da.GetById(item.Id)) return false;
da.ClientREF = item.ClientREF;
da.Description = item.Description;
da.ProjectID = item.ProjectID;
da.TaskHeadingREF = item.TaskHeadingREF;
da.Title = item.Title;
bool ok = true;
if (da._IsModified)
{
da.Modified = DateTime.Now;
da.ModifiedBy = Environment.UserName;
ok = da.Save();
if (ok) AddChangeLog(da.TableName, da.Id, da.Timestamp, revisionInfo);
if (ok) item = new DdProjectExt(da.GetBuffer());
}
return ok;
}
private void AddData()
{
int proNum = 1031;
for (int cix = 6; cix < 10; cix++)
{
DdClientExt ddc = new DdClientExt();
ddc.ClientID = "Client-" + cix.ToString();
ddc.FullName = "Client Named " + cix.ToString();
DataStore.AddClient(ref ddc, new RevisionInfo());
for (int pix = 1; pix < 4; pix++)
{
DdTaskHeadingExt ddh = new DdTaskHeadingExt();
ddh.ProjectREF = DataStore.NullId;
ddh.TaskHeadingID = DateTime.Now.ToString("yyyyMMddHHmmssffff");
ddh.Title = "General";
DataStore.AddTaskHeading(ref ddh, new RevisionInfo());
DdProjectExt ddp = new DdProjectExt();
ddp.ClientREF = ddc.Id;
ddp.Description = "Project Number " + pix.ToString();
ddp.ProjectID = "P" + proNum.ToString("0000");
ddp.TaskHeadingREF = ddh.Id;
DataStore.AddProject(ref ddp, new RevisionInfo());
proNum += 1;
ddh.ProjectREF = ddp.Id;
ddh.TaskHeadingID = "General";
DataStore.SaveTaskHeading(ref ddh, new RevisionInfo());
}
}
}