static public bool DeleteRequestStatu(DdRequestStatusExt item, RevisionInfo revisionInfo)
{
DaRequestStatus da = new DaRequestStatus(DataStore.DbConnection);
bool ok = da.DeleteById(item.Id);
if (ok) AddChangeLog(da.TableName, item.Id, item.Timestamp, revisionInfo); //delete
return ok;
}
static public bool AddRequestStatu(ref DdRequestStatusExt item, RevisionInfo revisionInfo)
{
DaRequestStatus da = new DaRequestStatus(DataStore.DbConnection);
da.Clear();
da.ChangeRequestREF = item.ChangeRequestREF;
da.Comment = item.Comment;
da.EffectiveDate = item.EffectiveDate;
da.Hours = item.Hours;
da.Modified = item.Modified;
da.ModifiedBy = item.ModifiedBy;
da.PersonREF = item.PersonREF;
da.StatusID = item.StatusID;
bool ok = da.Insert();
if (ok) AddChangeLog(da.TableName, da.Id, da.Timestamp, revisionInfo); //add
if (ok) item = new DdRequestStatusExt(da.GetBuffer());
return ok;
}
static public bool SaveRequestStatu(ref DdRequestStatusExt item, RevisionInfo revisionInfo)
{
DaRequestStatus da = new DaRequestStatus(DataStore.DbConnection);
if (!da.GetById(item.Id)) return false;
da.ChangeRequestREF = item.ChangeRequestREF;
da.Comment = item.Comment;
da.EffectiveDate = item.EffectiveDate;
da.Hours = item.Hours;
da.PersonREF = item.PersonREF;
da.StatusID = item.StatusID;
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 DdRequestStatusExt(da.GetBuffer());
}
return ok;
}
