public static bool UpdateByID(Project o)
{
o.modifydate = DateTime.Now;
pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter();
int ret = ta.UpdateByID(
o.name,
o.description,
o.creator_id,
o.createdate,
o.modifydate,
o.startdate,
o.enddate,
o.id
);
if(ret == 1) return true;
return false;
}
public static bool Insert(Project o)
{
o.createdate = o.modifydate = DateTime.Now;
pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter();
o.id = Convert.ToInt32(ta.InsertQuery(o.name,o.description,o.creator_id,o.createdate,o.modifydate,o.startdate,o.enddate));
return true;
}
public static Project GetByID(int id)
{
try{
pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter();
pmanAPI.App_Data.pmanDB.ProjectDataTable table = ta.GetDataByID(id);
pmanAPI.App_Data.pmanDB.ProjectRow row = (pmanAPI.App_Data.pmanDB.ProjectRow)table.Rows[0];
return Project.LoadFromModel(row);
}
catch(Exception){
return null;
}
}
public static List<Project> GetAll()
{
pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter();
pmanAPI.App_Data.pmanDB.ProjectDataTable table = ta.GetData();
return LoadFromModel(table);
}
public static bool Exists(int id)
{
pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter();
if (ta.GetSumByID(id) == 0)
return false;
return true;
}
public static bool Delete(Project o)
{
pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.ProjectTableAdapter();
return ta.DeleteQuery(o.id) == 0?false:true;
}
