//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); }