//delete an existing task
public bool DeleteTask(Int32 taskID)
{
bool isSuccessful = true;
try
{
DBObject taskDB = new DBObject();
List <IDataParameter> pars = new List <IDataParameter>();
IDataParameter par = taskDB.CreateParameter;
par.ParameterName = "@taskid";
par.Value = taskID;
pars.Add(par);
string sql = @"delete from task where taskid=@taskID";
taskDB.ExecuteTransaction(sql, pars, CommandType.Text, true);
}
catch (Exception ex)
{
isSuccessful = false;
throw new Exception(ex.Message);
}
return(isSuccessful);
}
//update an existing task
public bool UpdateTask(Int32 taskID, String taskName, String Description, DateTime?startDate, DateTime?dueDate, DateTime?completeDate,
String assignTo, String Status, String updateBy, DateTime?updateDatetime)
{
bool isSuccessful = true;
try
{
DBObject taskDB = new DBObject();
List <IDataParameter> pars = new List <IDataParameter>();
IDataParameter par;
//assign all value to the parameter
par = taskDB.CreateParameter;
par.DbType = DbType.Int32;
par.ParameterName = "@partaskID";
par.Value = taskID;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.String;
par.ParameterName = "@partaskName";
par.Value = taskName;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.String;
par.ParameterName = "@parDescription";
par.Value = Description;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.DateTime;
par.ParameterName = "@parstartDate";
par.Value = startDate;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.DateTime;
par.ParameterName = "@parduedate";
par.Value = dueDate;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.DateTime;
par.ParameterName = "@parcompleteDate";
if (completeDate.HasValue)
{
par.Value = completeDate;
}
else
{
par.Value = DBNull.Value;
}
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.String;
par.ParameterName = "@parassignTo";
par.Value = assignTo;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.String;
par.ParameterName = "@parstatus";
par.Value = Status;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.String;
par.ParameterName = "@parupdateBy";
par.Value = updateBy;
pars.Add(par);
par = taskDB.CreateParameter;
par.DbType = DbType.DateTime;
par.ParameterName = "@parupdateDatetime";
par.Value = updateDatetime;
pars.Add(par);
//update an existing task according task id
string sql = "update task set taskname=@partaskName, description=@parDescription, startdate=@parstartDate," +
"duedate=@parduedate, completedate=@parcompleteDate, assignto=@parassignTo, status=@parstatus, " +
"updateby=@parupdateBy, updatedatetime=@parupdateDatetime where taskid=@partaskID";
taskDB.ExecuteTransaction(sql, pars, CommandType.Text, true);
}
catch (Exception ex)
{
isSuccessful = false;
throw new Exception(ex.Message);
}
return(isSuccessful);
}
