public Guid InsertTaskType(TaskTypeEntity taskTypeEntity) { Guid result; Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("usp_TaskTypeInsert"); db.AddInParameter(dbCommand, "@TaskDescription", DbType.String, taskTypeEntity.TaskDescription); db.AddInParameter(dbCommand, "@TaskCode", DbType.String, taskTypeEntity.TaskCode); db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, taskTypeEntity.CreatedBy); db.AddOutParameter(dbCommand, "@TaskTypeId", DbType.Guid, 30); db.ExecuteNonQuery(dbCommand); result = new Guid(db.GetParameterValue(dbCommand, "@TaskTypeId").ToString()); return result; }
public bool UpdateTaskType(TaskTypeEntity taskTypeEntity) { return taskDao.UpdateTaskType(taskTypeEntity); }
public bool UpdateTaskType(TaskTypeEntity taskTypeEntity) { bool result; Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("usp_TaskTypeUpdate"); db.AddInParameter(dbCommand, "@TaskTypeId", DbType.Guid, taskTypeEntity.TaskTypeId); db.AddInParameter(dbCommand, "@TaskDescription", DbType.String, taskTypeEntity.TaskDescription); db.AddInParameter(dbCommand, "@TaskCode", DbType.String, taskTypeEntity.TaskCode); db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, taskTypeEntity.UpdatedBy); db.ExecuteNonQuery(dbCommand); result = true; return result; }
public Guid InsertTaskType(TaskTypeEntity taskTypeEntity) { return taskDao.InsertTaskType(taskTypeEntity); }